Announcement

Migration of this forum

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:

  • Each user will need to reset their password.
  • Please select "I forgot my password".
  • Enter the email address you used to register in this forum.
  • You will receive an email with a link to set a new password.
  • Please choose a new (secure) password and confirm the process.

We will keep you informed in the pinned thread.

Kind regards,
Your ReportServer Team

Migration des Forums

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:

  • Jeder Nutzer muss sein Passwort neu vergeben.
  • Wählt dazu einfach "Ich habe mein Passwort vergessen".
  • Gebt die E-Mail-Adresse ein, mit der ihr registriert seid.
  • Ihr erhaltet eine E-Mail mit einem Link zur Passwortvergabe.
  • Bitte wählt ein neues (sicheres) Passwort und bestätigt den Vorgang.

Wir halten euch im angepinnten Beitrag auf dem Laufenden!

Mit vielen Grüßen
Euer ReportServer Team

Pages: 1

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

jallard
Member
Registered: 2018-04-16

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

IF_Eduardo
Administrator
Registered: 2016-11-01
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

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

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
Website

Re: Support for Report with Multi Datasources

This is currently not possible Jallard.

Offline

#6 2020-03-18 19:00:49

kris
Member
Registered: 2020-02-18

Re: Support for Report with Multi Datasources

Hi Eduardo,

Is there any update on RS-2483 -- running a query against two datasources?

Offline

#7 2020-03-19 09:12:49

IF_Eduardo
Administrator
Registered: 2016-11-01
Website

Re: Support for Report with Multi Datasources

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

Pages: 1

Board footer

Powered by FluxBB