Biml and SSIS Frameworks - SQL Server Integration Services Design Patterns - page 567

This allows the query builder to locate the columns list returned from the stored
procedure (which is what the Report Wizard needs to continue). Once the report is
built, remember to first update the dataset, then the report parameter, as you did for the
Application Instance report. One cool thing about this particular design is that we can
reuse the expression for BackgroundColor on the data rows. Once complete, the
Package Instance report appears, as shown in Figure A-26 .
Figure A-26 . The Package Instance report
Package instances are “children” of application instances. To reflect that relation-
ship, return to the Application Instance report and add a column to the table to contain
Packages links. Enter Packages in the column header and as text in the data cell.
Right-click the data cell and click Text Box Properties. On the Font page, change the
font color to Blue and set the Effects property to Underline. On the Action page, select
the Go to Report option for the Enable as an Action property and set the Specify a Re-
port property to Package Instance. In the Use These Parameters to Run the Report grid,
click the Add button and map the AppInstanceID parameter to the [Appin-
stanceID] value. Click the OK button to close the Text Box Properties Editor.
Click the Preview tab to display the Application Instance report. Select one of the
Packages” links to navigate to the Package Instance report that will contain only the
package instances related to that particular application instance. The Package Instance
report should appear similar to the Package Instance report displayed in Figure A-27 .
Figure A-27 . Package instances for a single application instance