Datasheet

You can use the parameter field to suppress the text objects conditionally. While it has the same effect
as changing the font color to the background color, conditionally-suppressed text also allows you to
use the parameter field to specify other formatting options such as font size and style.
To display the text objects only when the user chooses Yes for the ?Access parameter field, the following
report uses a simple conditional formula to enable the Suppress option on the Common tab of the
Format Editor.
{?Access}="No"
The formula must be added for each text object you want to suppress.
When the user chooses Yes for the ?Access parameter field, the text objects are not suppressed; the
data table displays text descriptions.
Note:
The report shown also uses the ?Access parameter field to enable the Can Grow option (also on the
Common tab of the Format Editor) and increase the font size for people with visual impairments.
When the user chooses No for the ?Access parameter field, the conditional formula suppresses the
text objects, leaving spaces in the report in place of the text objects.
27.4.1.3 Labeling data tables with formulas
Another method for adding explanatory text to a data table is to create formulas that combine text,
database fields, and conditional formatting. By adding the text and the database fields together in a
conditional formula based on the ?Access parameter, you can provide optional text for values in a table
without leaving blank spaces in the report. Using formulas also reduces the number of objects on the
report, making it easier to maintain the proper placement order.
Note:
Do not use this method if the report has summary fields or calculated fields. Although formulas provide
the best display of data, they can interfere with calculations because the data is converted to text.
2011-05-16685
Creating Accessible Reports