cancel
Showing results for 
Search instead for 
Did you mean: 

Adding Prompt to the report

Former Member
0 Kudos

Hello Everyone,

I want to add a prompt to my report. when it is left blank then it should return all the values.

Can anyone please help me to resolve this issue?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

You can add a prompt in the "Edit Query" area, choose field, added it to "Query filters" area and then select option prompt, finally select this prompt as optional so it can be left blank if user wants.

Former Member
0 Kudos

I am using XI R2 version. is it possible in this to make Prompt optional. if yes can you please guide me how to do this?

Former Member
0 Kudos

writetofaiz,

in BOXIR2 you cannot create an optional promopt through GUI. use the below sample code to create a filter object at the universe level. the user will be prompted for a * along with the LOV list. when he selects the * as the input value then the propmt is disabled pulling all the values.

(@Select(Sales Geography\Country Group) IN @Prompt('Select Country Group or

enter * for all groups','a','Sales Geography\Country Group',multi,free) ) OR

('*' in @Prompt('Select Country Group or enter * for all groups','a','Sales

Geography\Country Group',multi,free))