ultrafish
asked on
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!!!!
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!!!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
mlmcc