Check box / Radio buttons; Multiple values required!

[sregmi]

Hi,

I am in Reportnet 1.1. Database is SQL Server.

The situation is: multiple values are displayed in the filter page in a prompt (say, check box group for Region). User want to choose either a single
value or more than one but not all or all values. In the report (say at the bottom), a 'Filtered By-' Clause is there which should be followed
by the values those are selected in that prompt.

There is no problem if the user selects one, or multiple but not all - the report will display whatever the values were choosen after the 'Filter by-' Clause. However,
if the user selects say "Select all", the users don't want to display all the values on the filter page after the 'Filter by-' clause. They want word "All" instead.

For that, I am trying to use the static choice function of a prompt such as:

Use Display
%% ALL

This way, when the user selects All, all the values are selected without having the 'Select all' link clicked, thus, having the report
display "All" after the "filtered by-" clause. Which is perfectly fine.

However, if I use
...[region] in [?region?] => the data does not show up in the report.
...[region] like [?region?] => the data will come up fine...but the check boxes will change to radio buttons. Means the user will be able to choose either
the static choice 'All' or any one of the multiple choices. Not (say) two or more multiple choices (if he is not interested on 'All' but multiple values)

I am trying to make the user able to select either 'All' or any other values (multiple at a time).

Any suggestion will be appreciated. Prompt suggestions will be highly appreciated.

Thanks in advance.
SR

 

[MacLeod72]

Hi-

What I have done in the past is set up a static choice:

Use Display
ALL ALL

Then, I've used the following filter:

[region] in ?region? or ?region? = 'ALL'

I've only used this approach on a multi-select listbox, but it may work in your case as well.

--Rob