Alicia Uhacz
Alicia Uhacz

Reputation: 77

Using Crystal Reports, we want to suppress a section based on user input in a parameter

The parameter has yet to be setup, but it will be to determine what jobs to pull (Open, Soft Closed, Closed, or All). So, if the user says they want Open jobs to print, we want the section to suppress if ContractStatus<>Open.

Any suggestions?

Upvotes: 0

Views: 8528

Answers (1)

campagnolo_1
campagnolo_1

Reputation: 2750

In the Section Expert, highlight the section you want to suppress. Next to Suppress click on the formula button (x-2). Do not check the Suppress box! Create a formula like:

{tableName.ContractStatus} <> {?ParameterName} 

This will suppress the section if the field name value does not equal the parameter value.

Upvotes: 2

Related Questions