This topic is locked

Date Range

3/2/2012 3:56:47 PM
PHPRunner General questions
J
jlkbrich author

I created a report and would like to know how I can set the report up so that the user must enter a date rate and then those selected records will show in the report. The date range would be based on a due date field in the report.

C
cgphp 3/3/2012

You need something like a dropdown list box with values for search (days, months and years) in the report page. You can filter out the selected values in the "Before SQL query" event.

More info here: http://xlinesoft.com/phprunner/docs/before_sql_query_report.htm