How to conditionally suppress a group footer in drill-down mode only?

[loobzer]

Hi folks,

I'm hoping someone can help with this. I'm running CR Developer 8.5. The detail section of my report is actually hidden except on drill-down. I have 3 groups outside my detail section. Group Footer 3 is what is normally displayed on the report and is where a user will drill down from. When I drill down into a record to see its "sub-records", the record that I drilled down into from Group Footer 3 shows at the bottom of the drill-down page. I've tried Underlaying it beneath the detail section but this doesn't produce any noticeable result.

I'm new to Crystal and not too hot with formulas. How can I conditionally suppress Group Footer 3 only on drill-down pages? Actual report section names aren't listed in the formula editor that can be used in the formula either.

Any ideas?

Chris Weil
Media Systems Consultant
Encoda Systems (HK) Limited
6th Floor, Landmark East
12 Ice House Street
Central, Hong Kong
chris.weil@encodasystems.com

 

[chris777]

Create an unlinked subreport and drop it in the detail section of the report. Edit the subreport and remove any fields from the design canvas. Create a formula with a shared variable assigned a value of 1 (i.e. shared numbervar x:=1) Then, hide the details of the main report. In the GF3, conditionally supress the footer if x=1 (shared numbervar x=1).

What happens, is, sub reports do not run when the main report section is supressed or hidden, so x will have no value. When you drill down, the sub report will run and will pass a value of 1 to the main report and trigger the conditional suppression.

After you test it, you can go into the sub report and supress the inidiviual sections of the sub report so it is not seen.

Chris
DFW Crystal User Group

http://www.dfwcug.com