SQL Server Performance

display on report

Discussion in 'SQL Server 2008 Reporting Services' started by arkiboys, Sep 15, 2011.

  1. arkiboys Member

    I have finally got two stored procedures sp1 and sp2 which return results.
    1- sp1 returns a 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 a dataset which is a 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 is it possible to place onto a report an exact copy of the resultset that sp2 stored procedure returns?
    Note that I do have the result of sp1 if it is required for my purpose.
    I have tried using a table or a matrix but I still can not get the report to look like the result of sp2.
    Any thoughts please?
    Thanks
  2. satya Moderator

    You have to extract the results ot the variables in order to extract them to relevant section on report.

Share This Page