h1

REPORT PROPERTIES – FILTERS & PARAMETERS

August 24, 2010

Filters and Parameters both serve the same purpose – limit the records delivered to the Excel template to those that meet the logical condition applied by the user.

Both have 3 steps for a basic setup from the filters/parameters tab – Click ‘Add’ -> select a field from the field list -> select the logical condition from the list -> type a value (in the case of a filter) and a default value (in the case of a parameter) for the logical condition to use (this value may be typed, selected (by hitting the ‘…’ button) or a system variable added (by hitting the ‘@’ button).

The difference is that the filter always uses the user-defined filter value and the parameter requests a value from the user each time the report runs.

Craig Juta

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: