Record Selection

[dawtes]

Hi all,
I have a parameter in my report and users can select multiple values. Can someone explain to me how I need to assign the values to the table field in the record selection?

Thanks

 

[dgillz]

{YourField} in {?YourMultiValueParameter}

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[synapsevampire]

You might want to read my FAQs as well:

Record selection:
faq767-3825

Displaying selections made:
faq767-5684

Please include basic technical information in future posts to allow for better information:

Crystal version
Database/connectivity used

-k

 

[dawtes]

I have this record selection formula, but when I check it, it gives me an error message. I am giving the users a multiple selection option.
(if {?month} in [1,2,3,4,5,6,7,8,9,10,11,12] then
Month ({WMS_MBP_PERMITS.DATE_OF_ISSUE}) in [{?month}]
else
if {?month} <= 0
then
True )
The error message is

The array must be subscripted, for example Array

 

[lbass]

If you want the users to enter "0" for all records, then use:

(if {?month} <> 0 then
Month ({WMS_MBP_PERMITS.DATE_OF_ISSUE}) in {?month}
else
if {?month} = 0
then
True )

-LB