Click here to Skip to main content
13,736,200 members
Rate this:
 
Please Sign up or sign in to vote.
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 31-Jul-12 20:17pm
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

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.
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

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
  Permalink  
Comments
Santhosh Babu Mahimairaj 18-Jul-15 2:37am
   
wt goes wrong...
Santhosh Babu Mahimairaj 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)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Cookies | Terms of Service
Web05-2016 | 2.8.180920.1 | Last Updated 16 Jul 2015
Copyright © CodeProject, 1999-2018
All Rights Reserved.
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100