I have several reports using the same procedure for to data sets. so in ds 1 it uses EXEC dbo.USP_SSRS_Procedure @Type = 1 and in ds 2 it would use EXEC dbo.USP_SSRS_Procedure @Type = 2 so the report in the body has 2 tables using each result set. It renders ok in VS and in SSRS 2005 but when I load the report to ssrs it does not render. KDW

Hi There What type your parameter is it could be possible that you have declared your parameter as string Please try to put EXEC dbo.USP_SSRS_Procedure @Type = '2' or EXEC dbo.USP_SSRS_Procedure @Type = '1' Please let me know if you have any questions Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

String or Numeric - It doesn't matter...it will not render if you appropriately map the paramater types to the respective types in the procedure... That is not the issue. These reports were migrated from ssrs 2005 and worked on a 2005 instance - moved to 2008 and they will not work in the sql server but the render ok in visual studio.KDW

Hi There Did you try this option Please try to put EXEC dbo.USP_SSRS_Procedure @Type = '2' or EXEC dbo.USP_SSRS_Procedure @Type = '1' by putting values in string Please update Many thanks Syed PS! It happened sometime to me as well when I give default value to a parameter like 1 it does not work but if I choose =1 Please try this option it might resolve your problem

In the paramaters section of the VS/BIDS - I do not want any paramaters or defaults I want to choose the defaults in the datasource itself without using the ssrs paramater selections KDW

Hi There I have tried my best to reproduce your problem inside my test environment but I could not Here is what I did Create A Stored Procedure which accept Parameter Say CompanyIDCreate two dataset with that SP and pass parameter values 1 and 2 by going to dataset parameter properties tabCreate two table and associate each dataset with one table I am putting screenshot for your help Please let me know if you have any questions Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful

Yes - That is exactly what I have tried. Now in mine it also recognizes the param in the report data section - I do not do anythingwith the defaults. i can get it to render ok in Visual Studio - but when i try to render from the SSRS server - it will not finish the page...thank you for your persisitenceKDW