This topic is locked

Report Paging still confusion..

2/7/2012 6:49:55 AM
PHPRunner General questions
Microe author

This has been driving me crazy over several projects and several PHP versions. How do reports determine when to create a new page when printing? I have a report that I am trying to make sense of how to make it page right. I am building this one in PHPRunner version 6. Here is a basic design.
It has three main fields: Day of week, Time and Appointment. I want it to group on Day of Week and Time. There can be multple appointments of varying number under each time. There is other appointment data, and trying to print all on one line does not work so I change the report in the visual editor to make each record span multiple lines vertically to make it readable. It looks like this:
Monday

[indent]9:00 am

Appointment 1 - Data for Appointment 1

Data for Appointment 1 - Data for Appointment 1

Appointment 2 - Data for Appointment 2

Data for Appointment 2 - Data for Appointment 2

Appointment 3 - Data for Appointment 3

Data for Appointent 3 - Data for Appointment 3
10:00 am

Appointment 4 - Data for Appointment 4

Data for Appointment 4 - Data for Appointment 4
11:00 am

Appointment 5 - Data for Appointment 5

Data for Appointment 5 - Data for Appointment 5

Appointment 6 - Data for Appointment 6

Data for Appointment 6 - Data for Appointment 6
[/indent]Tuesday
[indent]9:00 am

Appointment 7 - Data for Appointment 7

Data for Appointment 7 - Data for Appointment 7

Appointment 8 - Data for Appointment 8

Data for Appointment 8 - Data for Appointment 8
[/indent]And so forth. problem is no matter what I set I get a appointment record with lines split across pages. If I could tell it to always print only 5 records (appointments) per page, regardless of how many groups (days of week or times) it encounters then it would work. If I could also make it page after every day of week (I assume I can do that with a Page_After_Always style parameter) that would solve it all. But I can't figure out how to control the number of records per page. There is a lines-per-page setting in one place which I assume applies to the list display and not the printed report? There is also the groups per page setting but this seems to be totally unpredictable. I have tried to figure out the page counters in the PHP code but report generation calls so many different params and functions that it's complexity is quite hard to decipher.
Like I said, this paging thing has haunted me over several different major projects. Any help would be great