Seeing multiple values of same name in the drop down in reporting

[Virender singh1]

Hey there, 

I am struggling with a reporting issue here. I would like to understand more if that is a known issue or if I am doing it incorrectly.

 I am trying to make a report on particular variable of a catalog item but since the variable is multiple choice (List Collector). In the filter I am seeing multiple values here with the same name.

For e.g 

There is a variable Request Type which is a List Collector type and referencing to Catalog Choice list Table and when I tried to select the correct option under request type, Lets say I tried to select File Review but in the drop down I am seeing several File Review options which were present on the Catalog Choices Table. It means it is looking for all the choices/which contains a File Review keyword in them instead of showing me the correct value.

This working perfectly fine for all other variable types: Having problems with Multi choices only:

Example below

 I am dot walking in given way: 

Questions>Catalog Item name>Variable name which is a Multi select

Any help/guidance will be much appreciated: 

Thanks, 

Viren

[palanikumar]

For List Collector use "Contains" operator in condition instead of "Is"

Thank you,

Palani

[Virender singh1]

It does not make any difference. I have already tried that too.

 but Many Thanks for your reply Palani

Best Regards

[Logan Poynter]

Hello Virender,

This happens because at the report level there is no filtering like on your list collector to only show the appropriate value, it will return all options that COULD exist for the list collector based on the table it's on (in this case sys_choice). What table are you building your report on that you see Questions instead of Variables? 

Please mark my answer as correct/helpful if it has helped you.

Thanks,
Logan