Is there a way to force single selection on Report filter?

jim fuller shared this question 21 months ago
Answered

in my particular case it makes no sense in combining the results of two or more items in a filter, therefore, I'd liket he ability to limit the filter selection to a single item.

Comments (5)

photo
1

Hi Jim,

I would recommend either using a custom SQL query for the filter, or creating a calculated field specifically for this single value, and then filtering on that.

Let me know if that makes sense/ sounds like it will work.

Regards,

Nathan

photo
1

Let's say I had 3 items in a list. Those items were Metric Type, for example Tonnes, Pounds, and Cubic Yards. It wouldn't help a user to see the combination of Pounds and Tonnes if they inadvertently selected both. In this case, I'd want to prevent a selection of more than 1.

photo
1

Hi Jim,

Sorry I might have misunderstood what you are going for here. It sounds like you want the filter "Equals" logic rather than "In list".

ad33a5de80ef58c1e9845d912d0e8f27

Regards,

Nathan

photo
1

Hi Jim,

I am going to set this ticket to closed for now, but if there is anything else I can do to help here, please just let me know and the case will be re-opened!

Regards,

Nathan

photo
1

No problem. Thank you.