• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 353
  • Last Modified:

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?  
0
ThomasBallardIT
Asked:
ThomasBallardIT
  • 2
1 Solution
 
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
 
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now