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,
asked Aug 09, 2012 at 06:14 PM in Default
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.
answered Sep 28, 2012 at 12:21 PM
May sound daft but try reloading the solution.....
answered Aug 14, 2012 at 04:26 PM