I am trying to create an interactive filter for a report which is on HR Workforce Administration Case table.
Requirement: To create an interactive filter on "State" field which is a record producer field. We built a report on HR Workforce Administration Cases with HR Service "X" which is generated when we submit record producer "Y". This "State" field is part of "Y".
So this "State" field is populated in question_answer table and I am unable to create an interactive filter such that when I change the "State" field on the filter the report should reflect all the Cases with variables.state = "Chosen value in the filter".
Can anyone help me in this case?
