Order of Evaluation Precedence 1

[CoffeeManOhYesIAm]

Good day, all:

This is probably an elementary question, but no less important to straighten out the flaws in my logic.

I've got a report that uses the structure outlined below to display 21 records. What is the exact flow of evaluation in the report for each record?

------------------------------------------------------------

RH
PH
GH1
GH2
GH3a
GH3b
GH3c
GH3d
GH3e
GH3f
GH3g
GH3h
GH3i
GH3j
GH3k
GH4
Details a
Details b
Details c
Details d
Details e
Details f
Details g
Details h
Details i
GF4
GF3
GF2
GF1
RF
PF

------------------------------------------------------------

Thanks in advance for your help,

-Gyo

 

[Turkbear]

Hi,
It depends:

What database and connection type?
What Crystal version?
How many tables involved?
How much is being done at the database side?
What exactly is meant by 'flow of evaluation'
Can you post what you see when you select Database..ShowSql?








To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[CoffeeManOhYesIAm]

Sorry, I forgot:

Crystal 8.5.
Progress database over ODBC connection.
7 tables in the main report + 32 tables in 18 subreports.
Grouping is done at the client.
"flow of evaluation" refers to:
Record #1 - Evaluate RH, then PH, then GH1, then GH2, then ..., ... then RF, then PF (or whatever, I don't know the order!)

Databse...ShowSql is grayed out.

 

[rosemaryl]

Dear CoffeeMan...

Go into the help in Crystal and do a search for pass or multi-pass.

You should find a chart that shows you how crystal processes using the two-pass reporting concept.

Also, Crystal is a banded report writer, meaning that CR writes the report vertically. Rather then posting the contents of the kb articles, please read either article at the link provided below. While there isn't ar article specifically for 8.5 there is one for 7.0 and lower and one for CR 9. Not much has changed so either document would server to inform you on what you have requested.

CR 9 and higher:

http://support.businessobjects.com/communityCS/TechnicalPapers/cr9_evaluationtimes.pdf.asp

CR 7 and lower:

http://support.businessobjects.com/communityCS/TechnicalPapers/scr7_evaluationtime.pdf.asp

Regards,

ro

Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762

 

[synapsevampire]

Crystal functions similarly to a SQL statement.

So to attempt to answer your question, the flow is that all details are processed at the innermost group level, much as your diagram assumed.

So at the end of all of the details within the last GF4, you would find the last detail row of the report, as you would find at the group footer of the last group of data within 3, 2 and 1.

I think that Ro meant that Crystal may make up to 3 passes in a report.

Here's some more info:

http://www.businessobjects.com/prod...nlineHelp/html/crconreportprocessingmodel.htm

-k

 

[rosemaryl]

Dear SV,

You are correct.

I show this chart in every single Crystal Class I teach ... so you would think I would remember that! It's just that Crystal themselves refers to it as the Two-Pass reporting process...

regards and hope you are doing well,

ro

Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762

 

[synapsevampire]

Hi Ro, and it's always good to read you.

Yeah, I like this chart, it simplifies the system pretty well.

Oh, I guess unless you're teaching a Crystal (BO) employee.

I don't see anything about Business Objects Crystal Reports in your tagline, I would guess that the mere mention of BO would net an additional $25 hourly to the rate

Hope it's all going brilliantly for you.

BTW I'm looking for NYC contracts right now, hopefully to start in mid to late June.

-k

 

[rosemaryl]

SV

Shoot me an email with a contact number ... I would like/need to talk to you.

Regards,

ro

Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762

 

[synapsevampire]

I just did so.

-k

 

[CoffeeManOhYesIAm]

Thanks, Ro & SV for your advice and helpful links.

In the future, I will look in the crystalusergde.pdf before i post to this forum!

best regards,

CMoyia