You are not logged in.
We are using Report server for single Datasource individually.
We do have some Crystal Report that are link to multiples datasources. Is there a way to introduce those report in Report Server.
Thank you,
Offline
Hi jallard,
this is not currently possible. We have a ticket for this, though: RS-2483
Regards,
Eduardo
Offline
Hi Eduardo,
Do you have any idea how long will it take to make it possible? We really need Reportserver to be able to support multiple databases as soon as possible.
Most of the enterprises nowadays are using at least two different databases and for some reports they need to retrieve data from all them.
Thank you,
Offline
Dear Hamza,
reportserver does support multiple datasources but not multiple datasources in a single report. It is designed not to. Pls. try to pool data for a given report in a single datasource, you will never achieve good results with regards to perfomance and robustness if not so. Assume a report accessing several datasource of which one is not available at execution time ... .
You might consider using a scriptreport and collect the data yourself from multiple sources as a workaround.
wbr jan
Offline
This is currently not possible Jallard.
Offline
Hi Eduardo,
Is there any update on RS-2483 -- running a query against two datasources?
Offline
Hi kris,
this is currently in the development queue. I will update here when I have more information.
Please consider the following:
"You might consider using a scriptreport and collect the data yourself from multiple sources as a workaround."
Regards,
Eduardo
Offline