Layout - Do you show errors in red?

Errors on reports should not occur but when they do it is best to make it clear to the reader that they have just experienced an error.
How evident are the error messages on the 1st report below?

<imageEmbed
  alt="Image"
  size="large"
  showBorder={false}
  figureEmbed={{
    preset: "badExample",
    figure: 'Bad example - Using the default NoRows property of the table control - error message is not clear enough',
    shouldDisplay: true
  }}
  src="/uploads/rules/show-errors-in-red/RSErrorMessageT1.jpg"
/>

<imageEmbed
  alt="Image"
  size="large"
  showBorder={false}
  figureEmbed={{
    preset: "goodExample",
    figure: 'Good example - Use a customized textbox and icon to show the error message in red',
    shouldDisplay: true
  }}
  src="/uploads/rules/show-errors-in-red/RSErrorMessageT2.jpg"
/>

Reporting Services allows you to set the 'NoRows' property of a table control to warn your user when there is no data available. This is similar to handle the 'NoData event' in Access report but there is no advanced control on this message, not even a Color property - this has not been improved in RS2005, see our [Better Software Suggestions page](https://www.ssw.com.au/archive/standards/rules/rules-to-better-sql-reporting-services.html#Subscription).


<imageEmbed
  alt="Image"
  size="large"
  showBorder={false}
  figureEmbed={{
    preset: "default",
    figure: 'NoRow property of Table control only allow simple string',
    shouldDisplay: true
  }}
  src="/uploads/rules/show-errors-in-red/RSErrorMessageT3.jpg"
/>

Here's how to add a custom "NoData" textbox with a red icon to your report:

1. Add a rectangle to the top of your report, above any report items in the body. Set its **BorderColor** to **Red**.

2. Drop a textbox into the rectangle and give it the value **No records were found matching your criteria. Please modify your parameters and try again.**

3. Add an Image control to it. This opens in a New Window as the Image (add an error icon ❌ to your Images folder in your solution and reference it like **Images/fatal_error_info.gif**). Your report will now look similar to the one below.

   
<imageEmbed
  alt="Image"
  size="large"
  showBorder={false}
  figureEmbed={{
    preset: "default",
    figure: 'Adding a custom error message to your report',
    shouldDisplay: true
  }}
  src="/uploads/rules/show-errors-in-red/RSErrorMessageT4.gif"
/>

4. In the **Hidden** property of the **Rectangle**, add an expression to show/hide it depending on whether any rows were returned. Use the following expression, substituting the bold for your own values (e.g. checking if the sum of all orders is < 0)

   ```sql
   --Expression to set the visibility of the error message controls

   = iif( Sum(Fields!SaleTotal.Value, "MyDataSet")>0, True, False)
   ```

   
<imageEmbed
  alt="Image"
  size="large"
  showBorder={false}
  figureEmbed={{
    preset: "default",
    figure: 'The Hidden property of the rectangle',
    shouldDisplay: true
  }}
  src="/uploads/rules/show-errors-in-red/RSErrorMessageT5.gif"
/>

5. Group all other report items into a rectangle - you want to be able to show and hide them dynamically.

6. In the **Hidden** property of this **Rectangle**, add an expression to show/hide it depending on whether any rows were returned. Switch the True and False values around, so that it shows if it does have records, and hides if it does not have records (the opposite behaviour to the error box). So, in the example above, the expression would be:

   ```sql
   --Expression to set the visibility of the main report items

   = iif( Sum(Fields!SaleTotal.Value, "MyDataSet")>0, **False**, **True**)
   ```