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

SearchOperator Parameters.

edited June 2003 in RAP
Hi

I have checked through the RAP help in ReportBuilder searching on
SearchOperator to set my search criteria and I found the following
parameters for it :-

soEqual
soNotEqual
soLessThan
soLessThanOrEqualTo
soGreaterThan
soGreaterThanOrEqualTo
soLike
soNotLike
soBetween
soNotBetween
soInList
soNotInList
soBlank
soNotBlank

I could not find a parameter that was equivalent to soAll (show all
records). Is there one so that in my report I can set this value to this
parameter?

Allan Ryan

Comments

  • edited June 2003
    In order to show all, there is a checkbox in the autosearch dialog for each
    field that allows you to show all values. If you aren't showing the
    autosearch dialog, but want to show all values, then you simply have to
    leave the criteria blank. For example, try modifying the end user autosearch
    example in the autosearch demos directory to be coded such that when you
    click the 'A' speedbutton:

    procedure TForm1.ppReport1GetAutoSearchValues(Sender: TObject);
    begin
    if (ppReport1.AutoSearchFieldCount = 0) then Exit;

    if (ppReport1.AutoSearchFields[0].FieldName = 'Company') then
    begin
    if FRolodexLetter = 'A' then
    ppReport1.AutoSearchFields[0].SearchExpression := ''
    else
    ppReport1.AutoSearchFields[0].SearchExpression := FRolodexLetter;
    end;
    end;


    Cheers,

    Jim Bennett
    Digital Metaphors


  • edited June 2003
    What I really wanted to know, was there a search operator for selecting all
    records so that I could force the report do do so.


  • edited June 2003
    The way to do it was in my last post. There is no 'search on all'
    enumeration in that type.


    Cheers,

    Jim Bennett
    Digital Metaphors


This discussion has been closed.