2. PHPRunner General questions
  3. [SOLVED]  Totals for entire database
This topic is locked
[SOLVED]

 Totals for entire database

 		11/15/2016 7:22:30 PM
PHPRunner General questions
greggk author

So, I have a project where I have daily sales, and I have the totals for different columns which I did through the totals page in PHP runner. It works great, however I just realized today it's only totaling whatever is displayed on the page. So if you are only display 20 lines per page, it's only totaling those 20 lines. I want it to total all the lines, so if there are 400 lines in the database, that's the total I want, without having to display them all.

is there a way to do that through PHP Runner?
lefty 11/16/2016

Use Report feature for this with Global Summary checked. That will give you global totals without having to show every record.
greggk author 11/17/2016

Ok, I think that may work. I liked the layout of the list page better, but I'll make it work with the global report. Thank you for that tip.