Friday, March 9, 2012

Multiple data sources applied to the same report row

Woulf anyone know, if RS would work with multiple data sources applied to
the same report. For example, in a report, there are two data sources
pointing to different servers and few of the report columns are associated
with one data source and few with the other. How RS can handle this sort of
requirement because supposedly there is no option in RS to create a dataset
that is based on multiple data sources.
There are few alternatives like using linked server logic or sub reporting
however we are unable to find any direct way of accomplishing it.You can create as many data sources as you want in each report.
You can only use 1 query per table or graph though. I put some of my tables
next to each other, to look like 1 table in some of my reports.
"Mike Hernandez" <mike@.newage.com> wrote in message
news:%23ZFy0OEwFHA.256@.TK2MSFTNGP15.phx.gbl...
> Woulf anyone know, if RS would work with multiple data sources applied to
> the same report. For example, in a report, there are two data sources
> pointing to different servers and few of the report columns are associated
> with one data source and few with the other. How RS can handle this sort
of
> requirement because supposedly there is no option in RS to create a
dataset
> that is based on multiple data sources.
> There are few alternatives like using linked server logic or sub
reporting
> however we are unable to find any direct way of accomplishing it.
>|||Hi Mike,
Could you tell me how to impose relations between two Datasets.
Regards
AmitK
Cindy Lee wrote:
> You can create as many data sources as you want in each report.
> You can only use 1 query per table or graph though. I put some of my tables
> next to each other, to look like 1 table in some of my reports.
>
> "Mike Hernandez" <mike@.newage.com> wrote in message
> news:%23ZFy0OEwFHA.256@.TK2MSFTNGP15.phx.gbl...
> > Woulf anyone know, if RS would work with multiple data sources applied to
> > the same report. For example, in a report, there are two data sources
> > pointing to different servers and few of the report columns are associated
> > with one data source and few with the other. How RS can handle this sort
> of
> > requirement because supposedly there is no option in RS to create a
> dataset
> > that is based on multiple data sources.
> >
> > There are few alternatives like using linked server logic or sub
> reporting
> > however we are unable to find any direct way of accomplishing it.
> >
> >

No comments:

Post a Comment