Format the Report

We'll now add some formatting to our report.

Right-click in the indicated area (see the screenshot below) and choose Row Visibility.

In the Row Visibility dialog, select the Show or hide based on an expressions option and then click the Fx button (on the right). In the Expression dialog that opens, enter the following expression:

=If(IsNothing(Fields!Machine_Name.Value <> Fields!Machine_Type.Value, false, true)

The expression will hide the empty machine names.

Right-click on the image and select Image Properties. In the Image Properties dialog, set padding to position the image in the center:

In the Visibility tab, select Show or hide based on an expression and click the Fx button. Enter the expression as shown below:

Right-click on Parameters and choose Add Parameter:

Set the parameter name and the prompt:

In the Available Values tab, select Specify values and add the required labels:

In the Default Values tab, set a default value from the previous list:

On the main report screen, right-click on the pie chart and select Chart Properties. In the Chart Properties dialog, select Show or hide based on an expression and click the Fx button. In the Expression dialog, enter the following:

On the main report screen, right-click on the bar chart and select Chart Properties. In the Chart Properties dialog, select Show or hide based on an expression and click the Fx button. In the Expression dialog, enter the following:

Save the report. You can now run it in the Parallels RAS Console: