Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 351
  • 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

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

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