AR13 Web Designer - Server Side filtering based on user populated parameters

Posted by: nicolaas.coetzee on 15 September 2019, 8:50 pm EST

    • Post Options:
    • Link

    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?

  • Posted 15 September 2019, 9:52 pm EST

    Hello,

    I have created two JSON for datasets in the Web Designer. You can copy both JSON files into the following location:

    C:\Users\MohitG\Documents\GrapeCity Samples\ActiveReports 13\Web\WebDesigner_MVC(Core)\datasets

    And run the WebDesigner_MVC(Core) sample.

    After that, please refer to the attached video to know how to use the parameter in Web designer.

    Please let me know if you have any other issue with this.

    Thanks,

    Mohit

    Order Details.zip

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels