In ssrs 2005 i was successfully using one stored procedure with two paramaters in one report
so in table 1 - us was using as a data set as Text exec dbo.some_prc @param = 1
and in table 2 - us was using as a data set as text exec dbo.some_prc @param = 2
all in the report body.
This does not seem to work in ssrs 2008 - I can get it to render results - but once I re-establish my procedure in the dataset - it wants for me to add paramaters in the report.
I have tried adding default paramaters in the re-established datasets to no avail.when I load it to SSRS - it never times out but does not render.