#1 2018-11-09 13:18:50

jallard
Member
Registered: 2018-04-16
Posts: 1

Support for Report with Multi Datasources

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

#2 2018-11-19 09:20:40

eduardo
Administrator
Registered: 2016-11-01
Posts: 829
Website

Re: Support for Report with Multi Datasources

Hi jallard,

this is not currently possible. We have a ticket for this, though: RS-2483

Regards,
Eduardo

Offline

#3 2018-11-20 22:20:13

Hamza_DBM
Member
Registered: 2018-06-04
Posts: 30

Re: Support for Report with Multi Datasources

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

#4 2018-11-22 17:56:09

jalbrecht
Administrator
Registered: 2016-10-21
Posts: 131

Re: Support for Report with Multi Datasources

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

#5 2018-12-01 07:59:31

Mritunjay Gautam
Member
From: Indore
Registered: 2018-11-23
Posts: 2
Website

Re: Support for Report with Multi Datasources

This is currently not possible Jallard.

Offline

Board footer

Powered by FluxBB