If you do a page break at a group footer, you end up with a blank page (it's not blank - it contains the report footer..) at the end of the report. To prevent this from occuring, go into the section expert and tick the box to throw a new page after the section then put the following condition into the conditional formula:
not onlastrecord
this will stop the page break after the last group footer and you can then output report totals on the rest of the page (assuming there is still room)
Oh the joys of manipulating data. I work in the NHS and for retail organisations, helping to make sense of the raw data that they generate. The tools available are varied and almost always wrong the wrong ones :) This blog is my incidental musings of things that have frustrated or interested me and I hope they will help to overcome some of the pitfalls I have encountered or inspire you to find new ways to solve your problems.
Wednesday, 29 April 2009
Tuesday, 28 April 2009
How to Hide an empty Sub Report in Crystal Reports 2008
I have generated a listing report which will occassionally have data in a sub report which is embedded in the details section. Despite setting the sub report to hide subreport if blank, the space taken up by the sub report object was still showing on the report.
I finally worked out that the solution was to create a subsection Details B and put the subreport in that and then set the subsection to suppress if blank. This had the desired results.
I finally worked out that the solution was to create a subsection Details B and put the subreport in that and then set the subsection to suppress if blank. This had the desired results.
Subscribe to:
Posts (Atom)