469,642 Members | 1,279 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,642 developers. It's quick & easy.

Generating Reports from Two Different Databases in SSRS-2005

14
I'm Generating Reports in SSRS-2005..

Previously I got the Data from One Database & Generated Reports.. Now I used to get the Data from Two Different Databases(ie Database-1 & Database-2) & to generate the Reports..
I'm having one Stored Procedure(Get_Data) which will combine Two databases & get the data from them.. It is working fine for Me..(I tested in Sql Server Management Studio)..

But it is Not working fine in my Visual Studio..

If i'm using Connection String with SqlDataSource(from Tool Box) it is working fine.. Report is Generating Normally....

But through Coding it is not working..

Previously when i'm generating Report through Single Database it is worked fine(Through Coding only.. that time also I used Stored Procedure's).. But when i'm working with Two Stored Procedures it is not working.. ie Reports is not Generating..


What is the Problem...

Please give me Suggestions for this...


Thank You..
Mar 11 '08 #1
0 1638

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by airkart | last post: by
1 post views Thread by Kiran | last post: by
2 posts views Thread by BillCo | last post: by
reply views Thread by vic07 | last post: by
2 posts views Thread by Rob | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.