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

Suppressing a Group 1

Status
Not open for further replies.

CTLReporting

Technical User
Jul 17, 2003
17
US
To all:

Is there a way to suppress a group header if there is only one group? I want the Group Header to show if there is more than one group, but if not, I don't want it to show the header for just one group. Any input would be helpful.

Thank you,


CTL Reports Group,
Running Crystal Reports 8.0 and 8.5
Bentonville, AR
FoodLabReports@ctlusa.net
 
Go to format section->group header->suppress->x+2 and enter:

distinctcount({table.groupfield}) = 1

...where {table.groupfield} is the field you are grouping on.

-LB
 
Thank you, but my formula editor has a x-2 button not an x+2 button

=O)

Thanks again, it worked great!

CTL Reports Group,
Running Crystal Reports 8.0 and 8.5
Bentonville, AR
FoodLabReports@ctlusa.net
 
For a minute there, I thought I was still getting it wrong--for a long time I was calling it the E2 button, and I don't have a clue where I got that. But try a magnifying glass, there really is a "+" there in the middle. At least in 8.0! :)

-LB
 
I set my resolution to 640x480 and I saw the plus sign! Ha! I'm blind! Good job having great Eye-sight. I would have replied to this earlier, but on setting the resolution back to original, I went one past and into the out of range section of 1280x1024 and i had to restart in VGA mode to change it! haha.

CTL Reports Group,
Running Crystal Reports 8.0 and 8.5
Bentonville, AR
FoodLabReports@ctlusa.net
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top