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) ?
gilweber3Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mlmccConnect With a Mentor Commented:
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
 
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
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.