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

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:
http://support.businessobjects.com/library/kbase/articles/c2005853.asp
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.
Thanks!


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?
Thanks!!!!
ultrafishAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

mlmcc
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mlmccCommented:
Glad I could help

mlmcc
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.

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.