2. ASPRunnerPro General questions
  3. Passing Filter Parameters to a Report
This topic is locked

Passing Filter Parameters to a Report

 		6/18/2014 9:13:33 AM
ASPRunnerPro General questions
M
 Mike Nagel author

Is there a way to pass filter parameters to a report? For instance, if I only wanted to see data from a specific period, I'd like to specify the starting and ending dates for that period. Thanks!
Sergey Kornilov admin 6/18/2014

Sure, proceed to reports search page, run a search and see how parameters are sent via URL.
Here is an example from the live demo:

http://xlinesoft.com/livedemo/asprunner/livedemo4/Employee_Sales_for_1996_report.asp?q=(OrderDate~between~1996-7-1~date13~1996-9-30)
M
 		Mike Nagel author 6/26/2014



Sure, proceed to reports search page, run a search and see how parameters are sent via URL.
Here is an example from the live demo:

http://xlinesoft.com/livedemo/asprunner/livedemo4/Employee_Sales_for_1996_report.asp?q=(OrderDate~between~1996-7-1~date13~1996-9-30)


That's not what we want to do. We do not want to pull a report that includes all the records and then filter it. We want to filter it before the report is generated.
Thanks!
Sergey Kornilov admin 6/26/2014

You didn't understand what I'm saying. Point your users to the advanced search page like http://xlinesoft.com/livedemo/asprunner/livedemo4/Employee_Sales_for_1996_search.asp
S
 		smireb 6/26/2014

What about just passing over the masterkey from current edit page?