Thread 149-1198292 FAO Lbass or another kind soul

[munchen]

Lbass

I know you fixed the above thread using a true and a false formula field. Could you help me with a similar issue?

I currently have two groups:
Group 1 – ID
Group 2 – Code

When the user runs the report they will only see the report header, page header, group footer 1 section and the report footer section. All others are hidden or suppressed.

I then want to drill down into the group footer 1 information whilst keeping the same page header information that the user sees when the report is first previewed.

However when I then attempt to drill down on the group footer 2 section and display the details section I want a different page header section to be displayed. (I assume I will have to have a page header b section).

In the above thread you had the following formulas:

//{@false}:
whileprintingrecords;
booleanvar flag := false;

//{@true}:
whileprintingrecords;
booleanvar flag := true;

and you said to place {@false} in the report header AND in a section after the subreport, e.g., if the subreport is in GF1a, then place {@false} in GF1b. Place true in the main report section where your subreport is located, e.g., GF1a in this example. Then go to the main report section expert->page header->suppress->x+2 and enter:

whileprintingrecords;
booleanvar flag;
flag = true; //note no colon

Could I use something similar? Where would I place the {@false} and {@true} fields and what would I have in the page header a and b sections?

 

[IanWaterman]

You really should tell us which version of Crystal you are using. Ver 9 and above have a new function

DrillDownGroupLevel

YOur second drill down should be at DrillDownGroupLevel = 2

Create a new page header subsection and in section expert suppress it when
DrillDownGroupLevel <> 2.

If you are not sure at what level you are just create a formula containing the function and place on report.
It will then display level when you drill down to that point.

Ian

 

[munchen]

Ian

Apologies. I'm aware of this new function but alas I am using version 8.5.

Any help would be appreciated.

 

[IanWaterman]

It is possible in 8.5 with some fairly horrible coding, but unfortunately I never managed to work out how to do.

Hopefully some one else can help you. YOu could also press your company for an upgrade and problem will be solved easily.

Ian

 

[lbass]

munchen,

Please do not direct your questions to a particular person--it is disrespectful of other contributors who may be better able to answer your question anyway.

The thread you cite is not a solution for your issue. What you might try instead is to insert a second detail section (detail_b) to use for your detail fields, and then add your "page header" fields to a detail_a section. Then in the section expert, conditionally suppress detail_a using:

recordnumber > 1

I'm not really sure how to suppress the first pageheader though. I know there is a method for doing something like this. Maybe do a search.

-LB

 

[lbass]

Please see FVTrainer's solution in thread149-708655.

-LB