Posted 15 September 2019, 8:50 pm EST
I am trying to find a way to at run time capture parameters from the user and then apply the captured values on the data source before any data retrieval is done.
A simple use case would be filtering a large data set (i.e. a table of a 1000000 records) based on capture dates on the records.
Pulling all the data to the report and then applying filters like specified in the Web Designer documentation creates a massive performance hit (https://help.grapecity.com/activereports/webhelp/AR13WebDesigner/webframe.html#Tutorial3CreateParameterizedReport.html)
Is there any way of doing this? Is there some part of the documentation that I have missed?