Hi All,
We had an existing query studio report with user prompt on the department column. The report used to show value prompt when we ran the report
Recently we added a framework filter prompt for the department column which requires the user to select the office values.
So now when the user tries to run the report he is now prompted to select the office name(FM filter) once he selects the office he should be prompted to select the departments for the office he selected instead the report just displays a text box. Is there any way we can have the prompt control to be a value prompt?
I guess query studio is failing to cascade the values after it takes the input for framework prompt..
Thanks in advance