Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 467
  • Last Modified:

subreport supress and show 'no records'

I have a summary and a detail section inside a main report (via subreports) I have it so the users show in the summary even if they don't have calls. Unfortunately the detail in the second subreport will show a 'blank' call page. I want to supress this detail and replace it with a text that says 'no calls exist for this user' Is there a way to do this based on logic like this

If subreport is blank show group header three (which will contain the message) ?
0
gilweber3
Asked:
gilweber3
  • 2
1 Solution
 
Kent FichtnerInformation Technology Systems SupervisorCommented:
What I would do is make a formula in the main report that has the call amount.

SHARED NumberVar CallAmount = <amount here>

Then in the subreport, you can split the details in to Detail A and Detail B.  Create another Formula in the subreport

SHARED NumberVar CallAmount;

Then on Detail A do a suppression based on formula

CallAmount = 0

In Detail B, put a text box that reads "No calls exist for this user".  Put a suppression based on a fomula

CallAmount <> 0

This should do what you want it to.  Hope that helps a little.
0
 
gilweber3Author Commented:
The Call amounts are actually in the two subreports. The main report is just a shell for the Hierarchy and contains the 2 sub reports in group headers.
0
 
Kent FichtnerInformation Technology Systems SupervisorCommented:
oh...that is great.  Then you don't need to do the formula, just use the database fields in the suppression based on the formula.
0
 
mlmccCommented:
You can suppress blank subreports in the SUBREPORT FORMAT
You can suppress a blank section in the SECTION EXPERT

You can use the shared variable described above to suppress a new GROUP HEADER SECTION that has your message.

mlmcc
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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