You are not logged in.
Dear users of this forum,
we are pleased to inform you that we will be updating the software behind this forum in the near future.
Existing posts, users and categories will remain untouched.
Important:
We will keep you informed in the pinned thread.
Kind regards,
Your ReportServer Team
Liebe Nutzer dieses Forums,
wir freuen uns, euch mitteilen zu können, dass wir in naher Zukunft die Software hinter diesem Forum aktualisieren werden.
Existierende Beiträge, Nutzer und Kategorien bleiben weiterhin bestehen!
Wichtig:
Wir halten euch im angepinnten Beitrag auf dem Laufenden!
Mit vielen Grüßen
Euer ReportServer Team
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
Offline
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
Offline