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

Posted on 2004-10-22
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
    LVL 100

    Accepted Solution

    This problem is fixed in CR9.  Have you apllied the latest service pack for CR8.5, it may solve it.

    LVL 100

    Expert Comment

    Glad I could help


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    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…
    This video Micro Tutorial is the first in a two-part series that shows how to create and use custom scanning profiles in Nuance's PaperPort 14.5 ( But the ability to create custom scanning profiles al…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

    846 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

    Need Help in Real-Time?

    Connect with top rated Experts

    3 Experts available now in Live!

    Get 1:1 Help Now