ReportServer Forum

holybowie

Member

Registered: 2020-11-03

Scripting to add business logic checking.

Hi All,

I am doing a Office Utilization Monthly Summary Report for human resources department.

In this report, include many business logic. I cannot apply the logic in the SQL command directly.

Can I use scripting to select data from data sources and apply all the business logic checking in the data. 

Finally, allow user download the processed data as a excel report in report server UI.

Thank you all experts

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Scripting to add business logic checking.

Hi holybowie,

you can create a script datasource, where you may apply business logic using java / groovy. Details of script datasources here: https://reportserver.net/en/guides/scri … tasources/
Then you can access the script datasource normally, as any other datasource type, e.g. with dynamic lists.

You can of course export dynamic lists to excel, or you can use a JXLS report / JXLS template of dynamic list for making customizable Excel Exports.
Details of jxls reports: https://reportserver.net/en/guides/admi … S-Reports/
Details of jxls template of dynamic list: https://reportserver.net/en/guides/user … mic-Lists/  (6.12. Excel Templates with JXLS)

Regards,
Eduardo