Showing/not showing data (band) based on a condition in the report designer

By default, we ensure that the band is not visible. The band is displayed when:

1. No customer is specified

2. It is a customer from Germany

3. The language is not specified for the specified customer.

Select the band and adjust the 'Visible' option to 'No' in the menu on the right side of the screen (property grid). (This way, the band will not be displayed by default).

Click on the '>' icon while the desired band is selected. Then open the formatting rules option. (see image)

Choose 'Edit rule sheet' and then add.

Change the 'Visible' field to 'Yes'. After all, we want the band to be displayed if the specified condition is met. Click on the condition field to specify the condition.

Enter the condition, in this case:

[CustomerInfo] == null Or [CustomerInfo.LanguageId] == 26 Or [CustomerInfo.LanguageId] == -1

NOTE: the languageID may vary per RetailVista environment. You can look up the desired languageID in RetailVista. Go to administration -> countries, open the country, and open the mutation history. The displayed primary key is the languageID (in this example, 26).

The newly created condition still needs to be activated by moving it to 'Rules applied to a control' of the desired band.