Filter block based on variable / UserResponse()

building reports webintelligence
1

I have a report a prompt. The enters in their prompt and a list of user IDs is retrieved. The IDs are retrieved via a user’s hierarchy and excessive rows are often returned.

Because of the table data, I’m forced to use 15 optional prompts to allow the user to use the prompt that they feel is best suited for their situation. In the report, I want to filter a table based on the user’s input.

If my column data showed the following, and the user’s input was “WB410”, I would only want the two rows where the field = WB410 to be displayed.

DC410
DM410
DT410
GV584
GV584
WB410
WB410

[b]I have a variable named v_UserResponse that finds the optional prompt that was used and retains that value.

How can I achieve this through report filters?[/b] I can’t seem to filter on UserId = v_UserResponse.

Thanks in advance

bss (BOB member since 2009-09-10)

2

Solved.

I was able to fix this by creating a variable with a formula of:

=If([UserId]=[v_UserResponse];1;0)

and filtering for the 1s generated from that variable.

[Moderator Edit: Added code formatting - Jansi]

bss (BOB member since 2009-09-10)

3

Welcome to B:bob:B!

Jansi :india: (BOB member since 2008-05-12)