Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Excerpt

The View Parameters dialog appears if you try to view a report with OfficeWriter Designer .NET > View and the report contains parameters. The dialog will prompt you to enter values for the parameters.

IMAGEImage Added

A parameter is a value that filters the data displayed in your report. For example, if you have a sales report that lists each sales group and each sales rep within that group and you want to see one particular sales group at a time, you would use the Sales Group field as the parameter. Parameters are defined wherever report data sources and data sets are defined.

...

Note

The OfficeWriter Designer .NET will not validate parameter values selected by the end user: if an invalid parameter value is provided, the Report Server will return an error.

...

Cascading Parameters

...

In the event of cascading parameters, or parameters that depend on other parameters, the View Parameters dialog will leave all the first dependent parameters blank until all parameters that it depends on have been filled. For example, there are parameters: region (North America, Europe, Pacific), country (USA, Canada, France, England, Germany, Australia), and territories (areas in the countries). The territory parameter cannot be defined, and will remain blank, until a region and country have been selected. If a preceding parameter value is changed, all dependent parameters will be cleared. parameter blank and disable the rest of the cascading parameters. In the example below, Category is an independent parameter. The Subcategory value depends on Category and the Product value depends on Subcategory. Initially, Subcategory is enabled, but Product is disabled. 

Image Added

Once a value has been selected for a parameter, the immediate subsequent dependent parameters will be enabled.

Image Added

In this example, once a value for Subcategory has been selected, the Product field becomes enabled. If there were any parameters that depended on Product, they would remain disabled. 

Image Added

Once a value for Product is selected, any parameters that were immediately dependent on Product would be enabled. However, in this example, there are no additional parameters. 

Image Added

If a parameter value is changed, any dependent parameters will be reset. This means the first dependent parameter will be cleared. All other cascading parameters that depend on the changed value will be disabled. 

Image Added