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