Up to my knowledge, stored procedure has to return single dataset for SSRS Reports generation. If the SP returns more than one dataset, the Report will take the first dataset...

Hi,

1) You should create multiple stored procedures since each SP can be used as a dataset. Then you can add the datasets in Data Tab -> Dataset dropdown -> New...

Many Thanks to you.

I wrote a function and i got the result too.

CREATE FUNCTION select_concat (@A INT )

RETURNS VARCHAR(MAX) AS BEGIN

DECLARE @p...

CREATE TABLE Table1(A INT, B VARCHAR(10))

GO

CREATE TABLE TABLE2(C INT, D INT, E VARCHAR(10))

GO

Table1 DATA:

A B

------

1 XX

2 YY

Table2 DATA:

C ...