details section blank then don't show group header or footer

Crystal reports XI

If details section is blank then I don't want to show the group header or footer.  How do I go about that?  
LVL 3
ThomasBallardITAsked:
Who is Participating?
 
mlmccCommented:
So the group may have several records and some or all of them may be suppressed.

Try this
Add a formula
If {@AWG stockcode exemption} = " "  then'
   0
else
   1

Put that in the detail section
Add a summary (sum) on the field for the group

You should be able to suppress the group header and footer using the summary field by testing it for 0.

mlmcc
0
 
mlmccCommented:
You might look at this idea
http://www.experts-exchange.com/Database/Reporting_/Crystal_Reports/Q_21350521.html

In the group header can you determine if the detail section is blank?
You should only get the group header and footer if there is data for the group.

mlmcc
0
 
ThomasBallardITAuthor Commented:
Well there is data but I am suppressing it with this formula
{@AWG stockcode exemption} = " " in the details section.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.