Conditional Header Suppression on Drill Down

[jwestmore]

I have a report that is grouped by:

Department,
Day of the week,
Numeric Sub Group

I want the user to open the report, double-click on the department, double-click on the day of the week and then have the detail display with the Numeric Sub-Group above it. In other words, I'd like the Numeric Sub-Group heading to show up when I've drilled down to the detail, but not when I'm at the Numeric Sub-Group level.

Any thoughts on how to do this?

Thanks!
Jon

 

[FVTrainer]

Which version of Crystal are you using? In CR 9, there is a DrillDownGroupLevel function. You could place a formula similar to the following in the conditional suppression formula for the Numeric Sub-Group group header:

DrillDownGroupLevel <> 3

If you're using a version prior to CR 9, you can try the logic described in the following thread:

Thread767-682614


The basic idea here is that variables that are initialized at a level higher than the level being drilled into become zero when you drill into a level that contains a formula referencing them. (Well the variable value becomes zero in the drilldown tab, not in the report as a whole). So you can test the value of the variable and if it's zero, use conditional suppression to suppress whatever you want in the drilldown tab.

If you need assistance applying the principle shown in the thread, let me know.

 

[jwestmore]

Thanks!

I read that was possible but couldn't find a resource for how to do it.

I'm using CR8.5

Jon