Click here to Skip to main content
15,868,016 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I created a new SSRS report that will return the output of a SQL Server stored procedure.

When I run the stored procedure in SSMS, output is 5 different tables.

While running in SSRS Im getting only first table output.

Is there any possiblity to get all the tables in SSRS.
Posted

Is there any possiblity to get all the tables in SSRS.
Yes & No. :)

You can have all tables in SSRS using separate datasets.
You cannot have all the tables using single stored procedure. Reporting Services supports stored procedures that return only one table. If a stored procedure returns multiple tables, only the first one is used.

So, either you join all tables together to return just one table OR create separate stored procedures, and separate datasets to get them.
 
Share this answer
 
hello all,
My requirement is:-
Creat PROC Test(@SearchBy int)
Begin
If (SearchBy ==1)
Select * FROM EMP

If (SearchBy ==2)
Select * FROM DEPT

If .....

If....

If ...

End
At a time only one output will come
How i can bind result with SSRS report ,in future i can add if condition but i donot want to perform any actcivity in SSRS report.

Please help
 
Share this answer
 
Comments
[no name] 18-Jul-15 2:37am    
wt goes wrong...
[no name] 18-Jul-15 2:37am    
where you struck

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900