Report Parameters and 'In List'

rbuser

Hi,

RB 11.08, D2010.

I've set up a report parameter to use in an autosearch for a report. There
are LookupSettings defined. If I set the parameter SearchOperator to
soEqual, it shows in the auto search dialog and displays a list to choose
from as expected. However, if it's set to soInList, no lookup appears, just
a regular edit box and listbox.

Do I need to do something else to get it to work with InList?

This is so that the user can select records with one or more values in an
integer status field by adding their status descriptions to a list. We have
9 or 10 status values to choose from.

As an example, sales orders and order status [1 = Awaiting Stock, 2 =
Packing, 3 = Sent, 4 = On Hold]

Select orders where order status in (1,2,4)

Using the report they see:

Show orders where the status is in the list
Awaiting Stock
Packing
On Hold

Regards, Paul.

nicocizik

Hi Paul,

When using the InList operator, you need to define the list to be used
either as the SearchExpression (comma delimited text) or as the parameter
name/value list.

Use the Parameter.LookupList property or LookupListSettings if you would
like to obtain the list from data.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

"Nico Cizik (Digital Metaphors)" wrote in