Skip to Content
0

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

Nov 25, 2016 at 01:11 AM

159

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Sai P Nov 28, 2016 at 09:30 PM
0

Hi Marea,

Did you try to work around this link?

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

Thanks,

Durga

Share
10 |10000 characters needed characters left characters exceeded
Marea England Dec 18, 2016 at 10:53 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Kuldeep Ghosh Dec 19, 2016 at 03:15 PM
0

Can you try:

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

See if this helps

Share
10 |10000 characters needed characters left characters exceeded