Solved

subreport supress and show 'no records'

Posted on 2013-05-20
4
460 Views
Last Modified: 2013-05-21
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
Comment
Question by:gilweber3
  • 2
4 Comments
 
LVL 4

Expert Comment

by:Kent Fichtner
ID: 39181585
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
 

Author Comment

by:gilweber3
ID: 39181680
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
 
LVL 4

Expert Comment

by:Kent Fichtner
ID: 39181745
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
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 39181746
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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question