2. PHPRunner General questions
  3. Report Questions
This topic is locked

Report Questions

 		6/7/2007 10:40:41 AM
PHPRunner General questions
rsawchuk author

I am just starting to get into the Reports component. I have run into several problems which I don't know whether they are limitations of the program or bugs.
The report is a simple two column report with the username and timestamp. I just want a report on the activity related to filling out a form.
I sorted the timestamp fine, but also want to do a secondary sort on the usernames. It seems to do a partial sort but does not sort all the usernames for the same date.
The second issue is when I try and do a search on a given date, it returns no records. I can get it to work with "less than" but not "equal to".
Am I doing something wrong, are these limitations or bugs?
Thanks,
Russ
Sergey Kornilov admin 6/7/2007

Russ,
you cannot search by date if you store timestamp in database field.
When you talking about sorting - what exactly do you mean?

Do you setup timestamp and username as grouping fields?
rsawchuk author 6/7/2007

After creating several more reports, I think I am getting the hang of it. I just need to experiment more to get the right data, presented in the right way.
THANK YOU! THANK YOU! for the reports component. I have been waiting for several years now for a software application that would do reports. I checked out several other php/mySql report packages -- one did not work at all, and the other had limitations. Using PHPRunner, with which I am very familiar, is the best solution for me. So thanks again.
I guess the only request that I have is to add an Export capability to the Reports. However, I understand that you have indicated that such functionality will be added in the next release.
Russ