Just upgraded to phpRunner 5.2. Excellent! But - I have a simple project where in the prior version I had a report that would show a Summary Mileage Report by Category. I would get a sum total for Miles and Amount for each Category and a grand total for Miles and Amount at the bottom of the report. I have similar reports such as a Full Miles Report by Category where the only difference is that the "Show details and summary" box is checked. The Full report works proper (detail records shown w/totals). The summary report no longer shows Category level totals - nor does it show the grand total at the bottom of the page. I have double checked that the Miles and Amount is checked to Show and Sum. I have reset the pages in the visual editor for all the report pages (though I was not customizing them anyway). I have also tried all of the report layouts and still no appearance of Amount summary data. Oh - Last minute update: I triple checked things and while I still get no values shown/summarized on the main report web page, I then tried the Printer Friendly button (resulting in same problem - no data values/totals) But - when I pressed the Print Whole Report button - I got values/totals shown. Curiously also on the main web page it always shows a summary of 1 record. Template used is Madrid/Madrid. The reports are based on a single table (Id,Trx_Date,Category,Amount,Miles,Comment).
Here is what shows on the Main Web page for Report Summary Miles:
Category Amount Miles
Mileage@0.550
Summary for Category Mileage@0.550 - 1 records total
Sum
Category Amount Miles
Mileage@0.585
Summary for Category Mileage@0.585 - 1 records total
Sum
Category Amount Miles
Global summary 2 - records total
Sum [/size]
Here is what shows for the Printer Friendly page for the same report above:
Sum Miles Rpt
Page 1 of 1
Category Amount Miles
Mileage@0.550
Summary for Category Mileage@0.550 - 1 records total
Sum
Mileage@0.585
Summary for Category Mileage@0.585 - 1 records total
Sum
Global summary 2 - records total
Sum [/size]
And here is the same thing for the Print Whole Report button press:
Sum Miles Rpt
Page 1 of 2
Category Amount Miles
Mileage@0.550
Sum Miles Rpt
Page 2 of 2
Category Amount Miles
Summary for Category Mileage@0.550 - 29 records total
Sum 8,704.85 15,827.00
Mileage@0.585
Summary for Category Mileage@0.585 - 7 records total
Sum 2,134.09 3,648.00
Global summary 36 - records total
Sum 10,838.94 19,475.00 [/size]
What I am seeing is that the "Print Whole Report" result indeed has summary totals for Miles and Amount as well as accurate record counts. I am also observing separately that it hardly makes sense to generate a "Page 2" on such a short little report. I might correlate that maybe because the first group had 29 records and the Number of Lines per page setting is the default of 30 that it is internally paginating for the detail records while (correctly) never outputting them.
Anyone else seeing this behaviour???
Thanks!
UPDATE: -- This is still broken as best as I can tell. I have simple project I use live based on phpr 5.1 that works and built in this version, the above problem persists and prevent s me from using it for a live deployment. I also noticed the same problem reported where initiating a search and specifying the data as "between" causes another date field to appear but it is empty and seems to not work.