Database Reference
In-Depth Information
Type
SSISApp1
in the textbox and click the View Report button in the upper-right
corner. We don't want the user to supply an SSIS application each time they use the re-
port, so let's configure the report parameter named
@ApplicationName
. Click the
Design tab and return to the Report Data sidebar. Expand the Parameters virtual folder.
Double-click
@ApplicationName
to open the Report Parameter Properties window.
On the General page, check the Allow Null Value checkbox and change the Select
Parameter Visibility option to Hidden. On the Default Values page, select the Specify
Values option and click the Add button. A
(Null)
row will be added to the Value
grid, which is what we want. Click the OK button to close the Report Parameter Prop-
erties window.
Test the changes by clicking the Preview tab. The report should display all applica-
tion instance rows stored in the database, as shown in
Figure A-23
.
Figure A-23
.
Displaying the application instance data
We do not want to see the
0
rows displayed in these reports. Modify the
rpt.ReturnAppinstanceHeader
stored procedure to eliminate these records
from the returned results by executing the T-SQL shown in
Listing A-22
.
Listing A-22
.
Updating the rpt.ReturnAppInstanceHeader Stored Procedure
Search WWH ::
Custom Search