2. PHPRunner General questions
  3. Ad Hoc Reports
This topic is locked

Ad Hoc Reports

 		5/26/2020 6:37:43 PM
PHPRunner General questions
R
 RBrogen author

Hi Everyone,
I've searched the forum but can't find anything so I am posting this in the hopes someone has done it before.
I have a report that is generated with my sql query that has WHERE statement filtering by Year=2020 and Month=1. What I want to be able to do is on the live report, have drop down fields that will allow the user to select a month/year to display the report details for. I have the basic report running but want to have the drop down fields to make it easy to get the data to run the business. Any ideas/guidance would be greatly appreciated.
M
 		MikeT 5/27/2020

Easiest way would probably be to change / setup the query so that it returns everything by default and set up the right fields to be shown on the filter panel.
R
 		RBrogen author 5/27/2020



Easiest way would probably be to change / setup the query so that it returns everything by default and set up the right fields to be shown on the filter panel.


Thanks for the reply Michael. I did wind up using the filter panel ... I was curious if anyone had done this using dropdowns on a normal list view as more of a curiosity.
Sergey Kornilov admin 5/27/2020

If you need dropdowns specifically - use the search panel.