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_D ata) 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(f rom 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..
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_D ata) 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(f rom 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..