Page 1 of 1

Add the Dynamic Sorting, Filters on columns of report at runtime(i.e before rendering to viewer using Report.JS)

Posted: Wed Jul 29, 2020 8:09 am
by sathishy
Hi All,

I have use-cases like below:
1. Generate report at runtime and using data from SQL datasource. - I implemented this via programmatically.
2. Add Sorting, Filters at runtime before rendering at viewer.
3. is there any chance to maintain user specific visualizations changes(like: someone wants only few columns data, chartbars instead table forma etc in report)

Please suggest how we can achieve these using Report.JS(Javascript).

Thanks,
Sathish

Re: Add the Dynamic Sorting, Filters on columns of report at runtime(i.e before rendering to viewer using Report.JS)

Posted: Thu Jul 30, 2020 5:47 pm
by Lech Kulikowski
Hello,

You can implement it directly in code:
https://www.stimulsoft.com/en/samples/j ... -from-code

also, use request from user variables with Condtions to show/hide some elements, sample report in the attachment.

Thank you.

Re: Add the Dynamic Sorting, Filters on columns of report at runtime(i.e before rendering to viewer using Report.JS)

Posted: Thu Mar 11, 2021 8:13 am
by budha.jethava
Hello,

I'm adding dynamic sorting after report has been generated. report column sorting not working properly. one column has alpha numeric value and other column contain date having MM-dd-YYYY format. After applying sorting it's not working properly. I have added sorting code in viewer.php file. Please do needful.

-Regards,
Budha Jethava

Re: Add the Dynamic Sorting, Filters on columns of report at runtime(i.e before rendering to viewer using Report.JS)

Posted: Thu Mar 11, 2021 9:15 am
by Lech Kulikowski
Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.