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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Suppress group footer after drilling down?

Status
Not open for further replies.

vbit

Programmer
Jul 31, 2001
47
US

Is it possible to suppress or hide a group footer after drilling down in it? I want to be able to see the results of the drill down (i.e. detail section), but not see the group footer that I just double-clicked.

I'm using CR 8.5

Thanks.
 
If you can't suppress it, then could you suggest another way to do it?

Thank you.
 
As far as I know, if it is visible in the main report then it will be visible in the drill down.

You might try using an on-demand subreport. It is like a drill-down, but you can format it any way you like. However, the subreport object will appear in the main report as wide as the subreport needs to be. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB
 
Would it be possible to place a conditional suppress statement in the group footer based on a formula in the detail section?
(i.e. Formula that contains a boolean value placed in detail section. Then, conditional formula in suppress of group footer to see if boolean is true)

Is that possible?
 
Yes, but the formula will not change when you drill down. It will be the same before and after. Hiding the details doesn't affect formula processing. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB
 
So, the only way to accomplish this is to use an on-demand subreport?

What did you mean by "However, the subreport object will appear in the main report as wide as the subreport needs to be"?

Any other suggestions would be appreciated.

Thanks.
 
I can't think of any alternatives, but I don't pretend to know everything.

On demand subreports appear as boxes in the main report. They can be very slim vertically, but the subreport object's width in the main report determines the design area width of the subreport. So it can't be small horizontally.

Of course, you can take off the border so that the width of the object is invisible.

Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top