2. PHPRunner General questions
  3. New user using 3.0b, Totals Ques.
This topic is locked

New user using 3.0b, Totals Ques.

 		1/25/2006 1:30:47 PM
PHPRunner General questions
T
 Turbanator author

I specified Totals for columns and totals are shoing on each page output (50 at a time)...how do I get grand totals at the Last page?
Sorry if this was posted elsewhere.
-T
admin 1/26/2006

Hi,
PHPRunner can calculate totals for one page only.
If you need to calc grand totals you can use ListOnLoad event for selecting the totals from your database table and displaying them on the page.
T
 		Turbanator author 1/26/2006

Hi,

PHPRunner can calculate totals for one page only.
If you need to calc grand totals you can use ListOnLoad event for selecting the totals from your database table and displaying them on the page.


Is the ListOnLoad event javascript or sql statement? As you can tell, I'm new.
I was also trying to maually edit the SQL statement itself for generating a LIST page of ONLY totals by doing a SELECT SUM(amount) FROM tablex GROUP BY company but it didn't like that obviously. I have a tablex which has detail and I only need a list page to show a summary by company.
great product by the way, I wish I knew more to handle the Events.
admin 1/27/2006

Hi,
PHPRunner events are PHP procedures being called on specific events where you can put your custom code. You can add event handlers on Events tab in PHPRunner 3.0
PHPRunner doesn't support GROUP BY queries. I recommend you to create a view in your database and then use this view in PHPRunner.