March 11, 2008 at 4:40 am
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..
March 11, 2008 at 1:49 pm
Make sure that your stored procedure has fully qualified tables & database names, i.e. not just Sales but Production.dbo.Sales in the FROM clause. Then in the source for your report, fully qualify it also. It should fix you right up........it did for me anyway.
March 12, 2008 at 5:18 am
No Problem with Stored Procedure..
It is Working Fine..
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply