display data on report

i have got 2 stored procedures sp1 , sp2 return results.

1- sp1 returns dataset like:

period    gross      net       return     difference 

q1          2              6             7           -4
q2          4               4            2             0
q3          1              9              3           -8
q4          2              1             2            1  
...          ...               ...           ...         ...
...          ...             ...            ...           ...

2- sp2 returns dataset pivot of sp1 dataset i.e.

                   q1  q2   q3   q4 ...

gross          2     4     1     2    ...
net              6     4     9     1   ...
return         7      2    3     2   ...
difference  -4     0    -8    1   ...

question:
how possible place onto report exact copy of resultset that sp2 stored procedure returns?
note have result of sp1 if required purpose.

thanks

 

hi arkiboys,

in ssrs, can usehorizontal table pivot data vertical horizontal in matrix control.

in chrishays' professional blog, there detailed steps method, click linkhttp://blogs.msdn.com/b/chrishays/archive/2004/07/23/horizontaltables.aspx reference.

hope helps you. if issue still exists, please let me know.

thanks,
sharp wang

technet subscriber support in forum

if have feedback on our support, please contact us.

---

please remember mark replies answers if , unmark them if provide no help.

SQL Server  >  SQL Server Reporting Services, Power View