Page breaks on Reports

Hi,
I recommend you to have a look at the Print whole report option on the report page.

Hi Jane,
Thanks for that but this approach doesn't really help. Let me explain a little further with a real example.
I am generating a stocktaking report for an inventory. There are around twenty stock locations within the inventory, some of which are supervised by different store keepers. Within each location there can be one or more "shelves" where the actual items are held. The "print whole report" does not generate a page break before change in location or shelf, nor does it allow for the name of the groups (location and shelf) to be repeated at the top of each page. Indeed page breaks seem to be determined only by lines per page specified in the "page layout" page and no hard coded page breaks are inserted at all. edit Sorry that was incorrect, when printing from the browser changes on location are printed on new pages (however not in export to Word or PDF which I can live with) so it's the repetition of group names and column headings at the top of each page which is the real issue. My apologies for that error!
The quartermaster wants to run off a single report and hand out the pages to the appropriate store-keepers for completion. He has neither the time nor inclination to run off twenty seperate reports.
This is only one of many reports in the application that have similar requirements.
It is a real problem as this application is for a pretty demanding client who is willing to accept the advantages of moving to a web based application but will not accept any reduced functionality from their current system. Indeed it's a possible deal-breaker <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=45698&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' /> The reason that I need column name repetition is because some columns are NULL data on purpose (being areas where the store-keeper is required to manually write in details) and these are constricted when headings are not present.
So, I'd really appreciate some help!
Thanks,

Alex

Alex,
unfortunately there is no easy way to repeat column headers on each page (like in Excel).

As workaround you can export report to the Excel, select required options and print it.

Hi Jane,
At least I'm not being thick <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=45714&image=1&table=forumreplies' class='bbc_emoticon' alt=':rolleyes:' /> Sadly however a "workaround" is not an option for this client. I shall work on the hard way - and if anyone else can help I'd be grateful for your input.
If and when I come up with the answer I'll post it - now then ... where did I put my brain? I think I'll be needing it <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=45714&image=2&table=forumreplies' class='bbc_emoticon' alt=':)' />
Alex

Alex,
to break page after each group edit page in HTML mode on the Visual Editor tab. For example add new element and set up page-break-after or page-break-before property:

http://www.w3schools.com/CSS/css_reference.asp
Also you can edit this page and copy column headers manually on the Visual Editor tab.

Thanks Jane,
By moving the column titles from ShelfID_newgroup to the BEGIN Grid_block clause I am well on the way to achieving my target.
Not ready to tick the solved box yet but definitely moving forward.
Thanks again,
Alex

Sadly then my line counts got all skewed and I ended up with odd pages and tails and did not have enough time to work out if it could be corrected.
So I have taken on using FPDF directly as my reporting utility. By adding these reports which I write in PHP as link menu items I can achieve a consistent look and feel while having total control over my reports albeit through from scratch (almost) programming for each report.
I wonder if the development team might consider re-thinking this interface for the next generation of reporting in PHP Runner? I am sure that this wouldn't be so difficult for such a smart bunch of folks <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=46091&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' />

Thank you.

We'll add it to our suggestion list.

Cool, thanks.
I think the key is utilising the way FPDF uses its header and footer elements. Once I really understand it myself I might post up a few scripts but I started from here: Flexible reporting script
Kind regards,

Alex