Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


suppress an empty subreport (with new page before and after the group)

Posted on 2004-10-22
Medium Priority
Last Modified: 2008-02-07
hi all,

I  am working on CR 8.5, which has 1 main report and 1 sub-report (linked), they are linked with an companyID, so if the main report has one companyID say "1001" and if the subreport doesn't have it, it will still be printed, and now I want to suppress the whole sub-report if the sub-report doesn't have this companyID in the database (of the subreport), now I can successfully suppress all the fields (report header, group header, details, and group footer) which suppose to return an empty report, and in the main report I suppress that field (which is in group footer d) if it is blank, and it doesn't work, a blank page still appear in the output, anyone has any idea?
there is actually a solution here:
however my problem is for this empty report, I put it in a group footer (the forth group footer), whereas I insert a new page both before and after this footer, therefore a blank page always appear. please help.

Well, up to this point I get it done basically, however, as the subreport will prompt for parameter fields, if I insert the subreport twice, I have to enter the parameter twice which may cause error, is there any possible solution so that I can eliminate one step for entering actually duplicate data?
Question by:ultrafish
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 101

Accepted Solution

mlmcc earned 750 total points
ID: 12386541
This problem is fixed in CR9.  Have you apllied the latest service pack for CR8.5, it may solve it.

LVL 101

Expert Comment

ID: 12406655
Glad I could help


Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
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…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Suggested Courses

609 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