Support for multiple datasources

ReportServer (EN)
1

hello ,
We are currently evaluating ReportServer for our reporting requirements. We plan to migrate our existing Jaspersoft reports to ReportServer. One of our Jasper reports includes a sub-report, where the main report connects to one database and the sub-report connects to another.

Does ReportServer support this kind of multi-database reporting structure? If so, how can we achieve it?

A quick response would be greatly appreciated.

Thanks ,
Nitin

2

Hello,

Unfortunately, this isn’t possible directly.

The best way to solve this is through scripting.
You could try changing the DSs for the subreports if there’s a suitable hook.

According to the developers, you could try this:
https://reportserver.net/api/latest/javadoc/net/datenwerke/rs/core/service/reportmanager/hooks/AdjustReportForExecutionHook.html

Here you can access the subreports and change the DSs.

Best regards
Jasmin