Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Supress group footer totals in drilldown 1

Status
Not open for further replies.

PharmTek

Technical User
Aug 20, 2004
1
US
I have a drilldown report that needs to NOT show those totals when you select that level to drill down to the next for more detail.

So it looks like

**Next group down info**

Group footer totals (which was drilled down on) - this needs to disappear.

Not been able to do before - but thought this group was worth a shot - V8.5 Crystal
 
If you are willing to have the group headers not show on drilldown, you can use flags for this. I found this solution in thread767-480984 as suggested by Nuffsaid. Go to file->report options-> and uncheck "Show group headers on drilldown". Then create a formula:

//{@true} to be placed in GH#1:
whileprintingrecords;
booleanvar flag := true;

Then go to the section expert (format->section->GF#2->suppress->x+2 and enter:

whileprintingrecords;
booleanvar flag = false;

The GF#2 will appear when you drill down on GH#1, but will disappear when you drill down on GF#2.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top