Link to home
Create AccountLog in
Avatar of gilweber3
gilweber3Flag for United States of America

asked on

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) ?
Avatar of Kent Fichtner
Kent Fichtner
Flag of United States of America image

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.
Avatar of gilweber3

ASKER

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.
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.
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account