Report Filter & User Response

[former_member261309]

Hello,

Need your suggestion with the possibility of using userresponse function for prompt & Input control selection using reportfilter function simultaneously.

We have a requirement where user will run the report by giving prompt values for e.g prompt says :

Choose Sales Manage  : and user chooses three names Rebecca , Smith & Jack

This names will be displayed in the header of the report in a table using UserResponse function.

Later the same variable we have used in Input Control with checkbox, so the user would be having this three names in Input Control for selection again, so if user chooses to see the sales report for Rebecca & Smith only then he will do the selection at input control.

Our requirement is that the selection should be displayed in the header again, currently this both functions works well independently.

Is it possible?

Please advise.

Thank you

Piyush

[mhmohammed · Accepted solution]

Hi Piyush,

It's possible. You just have to check if the Userresponse() value is equal to Reportfilter() value, if yes, that means Input controls haven't been touched yet, in that case the header needs to show Userresponse() value, else if the input controls were touched, then the header needs to show the reportfilter() value. Make sense?

This is what I did to recreate your scenario and resolve the issue, you can try too:

1. Create a report using eFashion universe, just pull State, Sales Revenue and create a prompt on State
2. Select California, New York, Texas in prompt and run the report
3. Create a variable p_State = Userresponse("Enter State(s):") and put it in the report header, header will display California;New York;Texas
4. Create multi select Input control on State (object from the query, not a variable)
5. Select California and Texas only in the Input Control
6. Create a variable rf_State =Reportfilter([State])
7. Create a variable State_Header =If([p_State]=[rf_State]) Then [p_State] Else [rf_State]
8. Update the header with formula for State_Header and you'll see California;Texas only as you wanted.

Check out these snaps before and after making selection in Input Controls:

Before

After

Hope that helps, let me know if you have any questions or concerns.

Thanks,
Mahboob Mohammed

[former_member261309 · Accepted solution]

Thank you Mahboob for your response with this.

But in my pstate will not always be equal to rt state, when I tried this at my end with my scenario it only shows input coming from input control not from user response.

Will try again and update you

Piyush

[Former Member · Accepted solution]

Could you return sales manager as a result and display it in the report? This way the result is filtered by both the prompt and the input control.