Hello to All,

we partly use MS Reporting Services for printing reports within Infor LN. Now we Need to create such a Report but with the possibility to integrate a SQL-Statement which will Access another database or datasource. Is that possible and how can we do that?

Thanks in advance.

Best Regards
Bernd

Yes, you can do that. Just create an additional data source in the report and datasets for it. You can also create a sub report to include the data from the other data source. In the latter case ensure you have KB https://www.inforxtreme.com/espublic/en/answerlinkdotnet/SoHo/solutions/SoHoViewSolutionC.aspx?SolutionID=1449643.asp applied.

Hello JaapJD, thanks for help.
I will check that as soon as possible.
Best Regards
Bernd