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.
Showing posts with label formatting. Show all posts
Showing posts with label formatting. Show all posts
Wednesday, 29 April 2009
Subscribe to:
Posts (Atom)