HOWTO:Suppress Formatting Characters In Empty Report Records

Command Line Shortcut: ' User Permissions Level: All Product Level: All Describes the procedure modifying a report to hide formatting characters when padding a cable report with empty records.

---

Before You Start

This How To assumes that you are using a report that accesses the CablesCollection.

General Information

Without taking the following steps, if you pad a report with empty records you will see any formatting characters displayed in the padded records as follows:

Overview

We will need to create a formatting rule that can be applied to the various controls on the page that we want to hide when empty

1. Create our formatting rule.
2. Apply it to each control that we want to hide when empty
3. Set the detail area to Keep Together

Details

1. Open the report to modify and switch to the [Cable Data Selector] tab (at the top).
2. Enter a count of > 1 in the Pad With Empty Records control.
3. Switch to Preview and verify that your report is padded with empties (like above).
4. Switch to [Design] view tab (at the bottom left) and slide out the Properties window and pin it open.

Create the Formatting Rule

1. Open the Condition Editor by clicking the buttons shown above.
2. Enter the condition: IsNullOrEmpty([SRCSys]) Or IsNullOrEmpty([DestSys]) and dismiss the dialog.
3. If our condition is met we need to set the Visible property to False(no) and dismiss the dialog.
4. Dismiss the remaining dialog.

Applying the Formatting Rule

1. Select the control that we want to hide when empty