SSRS Create new report from old report

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,


more ▼

asked Aug 09, 2012 at 06:14 PM in Default

avatar image

10 2 2 2

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

You don't need to create a copy of the report at all. Two reports means more maintenance.

You could just implement a report parameter (type Boolean) that indicates if the NULLs should be included, for instance @includeNulls.

Same for the stored procedure, you don't need to create two versions. Just implement a parameter and use it inside the stored proc to return the data as expected. The report dataset can then pass the value of the @includeNulls into the stored proc.

more ▼

answered Sep 28, 2012 at 12:21 PM

avatar image

Valentino Vranken
1.5k 2 4 12

(comments are locked)
10|1200 characters needed characters left

May sound daft but try reloading the solution.....

more ▼

answered Aug 14, 2012 at 04:26 PM

avatar image

60 1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Aug 09, 2012 at 06:14 PM

Seen: 1072 times

Last Updated: Sep 28, 2012 at 12:21 PM

Copyright 2018 Redgate Software. Privacy Policy