SSRS Copy and change existing report RRS feed

  • Question

  • I have a report that I am trying to create from an existing report.  ReportA does not include Nulls, ReportB needs nulls included.

    I copy the stored procedure for ReportA (pcrA), paste it and rename it (prcB), and make the small change and save it.

    I then copy and paste (using Ctrl+v) ReportA in Visual Studio and rename it ReportB.

    I then delete the existing Data Source, then add one by clicking on the "...", select the data source, stored procedure and type in the name of the stored procedure (prcB)...just like it is in ReportA, except changed to B.

    No fields shows up when I click the "+" in the data at the left, where fields can be dragged and dropped onto the report.

    What am I doing wrong?

    It seems I should be hooking it up to the data source somehow and am missing it.

    I'm very new at this and any help would be greatly appreciated.

    Thank you in advance for any assistance,



    • Edited by GretaF Thursday, August 9, 2012 2:42 PM
    Thursday, August 9, 2012 2:41 PM