471,873 Members | 1,785 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,873 software developers and data experts.

Generating Reports from Two Different Databases in SSRS-2005

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 1717

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
reply views Thread by YellowAndGreen | last post: by
reply views Thread by zermasroor | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.