Use input control to filter report based on a variable

building reports webintelligence
1

I have a report that uses a variable to determine if the user has:

  • met a requirement
  • not met a requirement
  • not started a requirement

I have a variable that determines this, based on the user’s number of hours doing something. The report uses conditional formatting to highlight the user’s status toward this requirement.

I thought I could use an input control to filter the report to see only the users who met the requirement, or have not met the requirement, or have not started.

Instead, the input control seems to update the value of the variable. Also, when creating the input control, only one of the three statuses appears in the list of values.

Any suggestions?

jack1618 (BOB member since 2019-08-08)