Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Nov 28, 2016 at 09:30 PM

    Hi Marea,

    Did you try to work around this link?

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

    Thanks,

    Durga

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 18, 2016 at 10:53 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 19, 2016 at 03:15 PM

    Can you try:

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

    See if this helps

    Add comment
    10|10000 characters needed characters exceeded