2. PHPRunner General questions
  3. Sql Query help
This topic is locked

Sql Query help

 		9/3/2010 11:51:18 AM
PHPRunner General questions
swant author

I'm having trouble finding the correct sql output for what i want to do. I want to specify total records per user input for a time period.so i want to show how man records per a period time span and be able to have the user input the date span. so total records for month 8-1-10 - 8-31-10 or 8-1-10 - 12-31-10. make sense? i can make a report based on per month but i don't want to have to create a report for each month because there would be way to many reports.
Sergey Kornilov admin 9/3/2010

When you create a report PHPRunner allows you to group data monthly. Select date field as a group field and choose 'Month' as a period.
swant author 9/3/2010

am i doing that in designer? i see the group by button but i dont see that you can just pick month
sorry im a noob



When you create a report PHPRunner allows you to group data monthly. Select date field as a group field and choose 'Month' as a period.
Sergey Kornilov admin 9/3/2010

Proceed to 'Report: Group fields' screen. Choose date field as a group field. Choose 'Month' from 'Interval' dropdown box.
swant author 9/14/2010

this works great, is there a way to make is so you could choose lets say august for example instead of it showing all at once?



Proceed to 'Report: Group fields' screen. Choose date field as a group field. Choose 'Month' from 'Interval' dropdown box.