Report Parameters

There is a parameter that users can build into reports that Lucity will recognize and perform a special function for. There are more available in the web.

Hiding Secured Fields

Some fields in the Work program are considered "secured fields," meaning that only users with "View Secured Fields" permission in Security can view the data in those fields. Users who do not have the "View Secured Fields" permission will only see asterisks (*) in the secured field.

To make secured fields "hidden" in a reports, add a Number parameter with the name "ViewSecureFields."  Lucity will then pass a 1(true) or 0 (false) to the parameter. Use this parameter to mask or suppress secured fields. Then only users with "View Secured Fields" permission will be able to view that field data in the reports.

To do this, add the following format formula to the suppress option in the secured field:

{?ViewSecuredFields} = 0

Parameter Requirements

There are several restrictions that are placed on parameters forreports

See Also

Advanced Reports

Reporting with Advanced Filters

Creating Custom Reports

Tables

ODBC Connection

Date and Time Fields

Displaying Images