x

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,

Gee

--------------------------------------------------------------------------------
more ▼

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

Gee gravatar image

Gee
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

Valentino Vranken gravatar image

Valentino Vranken
1.5k 1 2 7

(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

swirl80 gravatar image

swirl80
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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x547

asked: Aug 09, 2012 at 06:14 PM

Seen: 881 times

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