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

If the status is " Failed ", then this expression will change the color of the Status
text to Blue . Click the f(x) button beside the Effects property drop-down. In the Set
Expression for: TextDecoration textbox, add the following expression:
=Iif(Fields!Status.Value="Failed", "Underline", "Default")
This expression will decorate a "Failed" status with an underline. This and the
previous property combine to make "Failed" status appear as a hyperlink. Where
does the hyperlink take us? Let's configure that property now. Navigate to the Action
page and select the Go to Report option for the Enable as an Action property. Click the
f(x) button beside the Specify a Report drop-down and add the following expression to
the Set Expression for: ReportName textbox:
=Iif(Fields!Status.Value="Failed", "Errors", Nothing)
Click the Add button and map the AppInstanceID parameter name to the [Ap-
pInstanceID] parameter value. Click the f(x) button in the Omit column of the
parameter mapping and add the following expression to the Set Expression for: Omit
textbox:
=Iif(Fields!Status.Value="Failed", False, True)
The two previous property settings configure the Action property of the Status
value. If the Status is "Failed" , clicking the word Failed , which will appear to be a
hyperlink, will cause the Errors report to display. When it displays, it will only show
those error rows associated with the application instance displayed in that row of data.
Let's test it! When I run the Application Instance report, it now appears as shown in
Figure A-28 .
Figure A-28 . The Application Instance report, including Status and Packages decoration
Clicking one of the Failed hyperlinks takes us to the Errors report for that applica-
tion instance. The report should appear similar to that shown in Figure A-29 .