Home DADE
New Blog Posts: Merging Reports - Part 1 and Part 2

Multiple Values (Selection) in one AutoSearch Field

edited January 2008 in DADE

Hello,
I want to use one autosearch field (Shopnummer) to select multiple shops
programmatically. Like:

for liIndex := 0 to ppReport1.AutoSearchFieldCount - 1 do
begin
if ppReport1.AutoSearchFields[liIndex].FieldAlias = 'Shopnummer' then
begin
ppReport1.AutoSearchFields[liIndex].SearchExpression := '0020';
end;
end;

To archive that I need to pass a regular expression or kind of list. Is that
possible ?
What would you suggest ? Programmatically adding new AutoSearchFields to a
report
might work too but is kinda nasty :)

Thanks
Philip

Comments

  • edited January 2008

    - For the query search condition, use the "In List" operator rather than the
    '=' operator. (You can use the Query Designer to add/modify search
    conditions, for each search condition you can selelct the operator from a
    drop down list).

    - Then for the SearchExpression you can specify a comma delimited list like
    this..

    ppReport1.AutoSearchFields[liIndex].SearchExpression := '0020, 0021, 0099';


    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.