Identify if the "Select All" option has been selected for an Input Control

[Former Member]

I'm creating a report which uses a document input control. I would like to include the selected items from the input control in the report heading, but only if the user has made a selection (ie Select All is not checked). I can use the report filter function to return the filter values (which is fab is only one or two items have been selected). However, I don't want to display all the available (checked items) if Select All has been selected. Hope this makes sense

[former_member977904]

Not sure if this was answered. I came across the same issue and the work around was to check if the ";" was included in the filtered list, which means that it was going to put all options in a list. If there was a ; then All values selected custom text otherwise what ever option selected. Code as below

If (Match(ReportFilter([Variable]);"*;*")>0) Then "Custom text" Else ReportFilter([Variable])

[former_member198519]

Can you try:

=if(IsPromptAnswered("prompt text"))then ReportFilter([object]) else "All Values Selected"

See if this helps

[Former Member]

Hi Durga

Thanks so much my response seems to have gone into outer space. Yes I did try

if count(ReportFilter([object])) = count(NoFilter([object])) then "All Values Selected" else ReportFilter([object])

however, the count(reportfilter(object)) retuned a count of 1 regardless of the number of objects checked in the input control. count(NoFilter()) appears to return the expected result.

So I'm a little confused why reportfilter is not returned expected results, I also tried

count(ReportFilter([object];All) (and distinct) without success.

I would appreciate your further advice. Thanks Marea

,

Hi Durga Thanks so much for your response - my apologies for a tardy response. I tried

if count(ReportFilter([object])) = count(NoFilter([object])) then "All Values Selected" else ReportFilter([object])

however it didn't seem to work. count(ReportFilter([object])) returned a value of 1 regardless of the number of items checked in the input control (either 1 or all). The count(NoFilter([object])) appears to work as expected.

I tried - count all and count distinct for count report filter object without success. Have I missed something? The solution appears to be very simple and elegant, but alas........

I look forward to your advice.

Regards

[former_member309630]

Hi Marea,

Did you try to work around this link?

http://www.forumtopics.com/busobj/viewtopic.php?t=175206

Thanks,

Durga