Make a Report from two different data source..

Hi,
I am trying to make a Report on SQL Server Reporting Services 2005.
Here I am facing a problem that is follows-
I have a two seprate database server Server1 and Server2 and from both
server have table1 on server1 and table2 on server2.
I just want to make a report to accessing a data from both server
tables. I dont know how can I make a Report through SSRS-2005.
Please help any one have idea..
This would be helpful for me.
Thanks,
Rahul.Any chance you could link the two SQL servers together? You cannot
run a single query against two individual servers unless they are
"aware" of each other, and linking is one way to do that.
You could set up individual datasets and perhaps link them together
using parameters, also.
On Mar 31, 5:57 am, mukul <mukuljainshas...@.gmail.com> wrote:
> Hi,
> I am trying to make a Report on SQL Server Reporting Services 2005.
> Here I am facing a problem that is follows-
> I have a two seprate database server Server1 and Server2 and from both
> server have table1 on server1 and table2 on server2.
> I just want to make a report to accessing a data from both server
> tables. I dont know how can I make a Report through SSRS-2005.
> Please help any one have idea..
> This would be helpful for me.
> Thanks,
> Rahul.|||Although you cannot join data together in RS. You can use subreports.
Subreports work great for this sort of thing.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"mukul" <mukuljainshastri@.gmail.com> wrote in message
news:9717ddc3-8972-41a4-8862-6b4b75f2ed71@.s13g2000prd.googlegroups.com...
> Hi,
> I am trying to make a Report on SQL Server Reporting Services 2005.
> Here I am facing a problem that is follows-
> I have a two seprate database server Server1 and Server2 and from both
> server have table1 on server1 and table2 on server2.
> I just want to make a report to accessing a data from both server
> tables. I dont know how can I make a Report through SSRS-2005.
> Please help any one have idea..
> This would be helpful for me.
> Thanks,
> Rahul.|||On Mar 31, 4:38=A0pm, "Jerry H." <boilersr...@.gmail.com> wrote:
> Any chance you could link the two SQL servers together? =A0You cannot
> run a single query against two individual servers unless they are
> "aware" of each other, and linking is one way to do that.
> You could set up individual datasets and perhaps link them together
> using parameters, also.
> On Mar 31, 5:57 am, mukul <mukuljainshas...@.gmail.com> wrote:
>
> > Hi,
> > I am trying to make a Report on SQL Server Reporting Services 2005.
> > Here I am facing a problem that is follows-
> > I have a two seprate database server Server1 and Server2 and from both
> > server have table1 on server1 and table2 on server2.
> > I just want to make a report to accessing a data from both server
> > tables. I dont know how can I make a Report through SSRS-2005.
> > Please help any one have idea..
> > This would be helpful for me.
> > Thanks,
> > Rahul.- Hide quoted text -
> - Show quoted text -
Hi Jerry,
Thanks a lot for reply.
Yes, If this is possible by linking the server then its Ok, but I dont
know the procedure to link the two server and after linking how I can
access the data from different database server through the query?
Please can you help me out to solve this report.
Thanks you for your support,
Rahul.|||On Mar 31, 7:48=A0pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Although you cannot join data together in RS. You can use subreports.
> Subreports work great for this sort of thing.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "mukul" <mukuljainshas...@.gmail.com> wrote in message
> news:9717ddc3-8972-41a4-8862-6b4b75f2ed71@.s13g2000prd.googlegroups.com...
>
> > Hi,
> > I am trying to make a Report on SQL Server Reporting Services 2005.
> > Here I am facing a problem that is follows-
> > I have a two seprate database server Server1 and Server2 and from both
> > server have table1 on server1 and table2 on server2.
> > I just want to make a report to accessing a data from both server
> > tables. I dont know how can I make a Report through SSRS-2005.
> > Please help any one have idea..
> > This would be helpful for me.
> > Thanks,
> > Rahul.- Hide quoted text -
> - Show quoted text -
Hi Bruce,
Thank you very much for your response,
Please could you give me the idea how can I achieve the target report
through subreports.
I dont know how can I made a subreports in RS when the data are coming
from different database server.
Thank you,
Rahul.|||You can have multiple data sources. Each dataset comes from a single data
source. So, if you have a master-detail type report you have the main report
with a dataset going to one server and then a subreport (which is just a
regular report with a parameter) to the other. You drag and drop the
subreport onto the main report, right mouse click, parameters and map the
parameter of the subreport to a field of the main report.
For master - detail reports, regardless of where the data is coming from)
that is how you design a report.
Note about linked servers. This is a SQL Server thing and advanced in my
book. The reason I feel that way is that if you try to do a join using lined
servers you can end up downloading the complete remote table. Fine if the
table is small but not so fine if there is any size whatsoever.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"mukul" <mukuljainshastri@.gmail.com> wrote in message
news:9668f8bc-a8cc-4e79-9bf5-fa83767e3b06@.q27g2000prf.googlegroups.com...
On Mar 31, 7:48 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Although you cannot join data together in RS. You can use subreports.
> Subreports work great for this sort of thing.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "mukul" <mukuljainshas...@.gmail.com> wrote in message
> news:9717ddc3-8972-41a4-8862-6b4b75f2ed71@.s13g2000prd.googlegroups.com...
>
> > Hi,
> > I am trying to make a Report on SQL Server Reporting Services 2005.
> > Here I am facing a problem that is follows-
> > I have a two seprate database server Server1 and Server2 and from both
> > server have table1 on server1 and table2 on server2.
> > I just want to make a report to accessing a data from both server
> > tables. I dont know how can I make a Report through SSRS-2005.
> > Please help any one have idea..
> > This would be helpful for me.
> > Thanks,
> > Rahul.- Hide quoted text -
> - Show quoted text -
Hi Bruce,
Thank you very much for your response,
Please could you give me the idea how can I achieve the target report
through subreports.
I dont know how can I made a subreports in RS when the data are coming
from different database server.
Thank you,
Rahul.