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


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 )

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

%d bloggers like this: