Design tips for parameters and filters

Contents[Hide]

1. Overview

A collection of design tips and brief how-tos for using parameters and adding filters in Dundas BI.

2. Edit Label Text

Single and range filter controls display a label which you can edit in-place via the toolbar or context menu instead of using the Properties window. Just select the filter control on the canvas, go to the toolbar, and click Edit Label Text to begin editing the text in-place.

Click Edit Label Text for this member filter
Click Edit Label Text for this member filter

For range filters, click Edit Start Label Text or Edit End Label Text to change the From/To text, respectively.

Change label text for a calendar range filter
Change label text for a calendar range filter

This option is not available for Cascading Member or Time Lag filters because these controls do not have options for changing label text to begin with.

3. Vertical Layout

By default, all filter controls except the Checkbox List are displayed with a horizontal layout.

But for some filters such as a Calendar Range, you may want to display its From and To boxes vertically instead of horizontally. You can do this using the Vertical Layout property under Layout Properties.

When using a vertical layout, the filter control will not expand vertically to fit its container (whereas it will expand horizontally when using a horizontal layout).

Calendar Range filter with vertical layout
Calendar Range filter with vertical layout

Other filters that have this vertical layout option include: Range Date, Member Range, Cascading Member, Range Number, and Checkbox List.

4. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri