July 27, 2010 at 11:59 pm
using stored procedure with multiple select statements in reporting services
I want to use stored procedure in which more then one query is written use this stored procedure in reporting servies to create charts .when i use stored query only first query is executed and show only first query result but i need all query results to show in a chart. plz help me how to do this.
July 28, 2010 at 12:55 am
Hi,
Question: using stored procedure with multiple select statements
As a SQL Developer/Programmer U can write multiple select statements....
If U r with .NET application then u may use all these multiple select statements in Ur application for Dataset.
Where as in SSRS U cant get the Multipple Select stmts.
U should get the First Select Statement of the Procedure for Dataset in Ur report .
Cheers!
Sasidhar Pulivarthi
July 28, 2010 at 1:03 am
ya i can add multiple statements in stored procedure but when i use this procedure to show result in the form of charts in reporting services only first select statement's result shown not all queries result .I want result of all queries to show them in chart .
July 29, 2010 at 4:04 am
We cant get all Select stattements from single procedure....
If u want all
Create different datasets for each select statement in ssrs
or
Use union of all statements with some column predectable to seperate in SSRS
ex:
Select tbl1,tbcol1,tbcol2,.... from tbl_1
UNION
Select tbl2,tbcol1,tbcol2,.... from tbl_2
UNION
Select tbl3,tbcol1,tbcol2,.... from tbl_3
U can use single select statement from the dataset through Group by or Filter condition .
Cheers!
Sasidhar Pulivarthi
July 29, 2010 at 9:45 pm
Hi,
You can also use the additional @action parameter in the SP you have written for the Report. And based on the value of the @action you can create the different dataset for the charts and tables etc...
DO let me know in case of any doubts.
Thanks,
Ashish
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply