Home› General
ReportBuilder 22.06 now available including Delphi 12.2 support!
New Blog Posts: Merging Reports - Part 1 and Part 2

CreateAutoSearchCriteria Question

rbuserrbuser
edited October 2004 in General
I've been using the CreateAutoSearchCriteria function to modify the report
criteria at runtime. For most every situation it works as expected, but
I've run into one that I just can't figure out. I need to be able to
specify a report criteria by range on a char field where one of the range
boundary values include an embedded comma.

Is there any way to create use the CreateAutoSearchCriteria function and
specify 'HR10' as the beginning value and 'HR19,5' as the ending value?

--

---------------------------------------
Terry Swiers
Millennium Software, LLC
http://www.1000years.com
http://www.atrex.com

Atrex Inventory Control/POS -
Big business features without spending big business bucks!

Atrex Electronic Support Options:
Atrex Knowledgebase: http://www.atrex.com/atrexkb.cfm
Email: mailto:support@atrex.com

Comments

  • nicociziknicocizik
    edited November 2004
    Hi Terry,

    This appears to be a limitation of the AutoSearch feature. ReportBuilder
    searches through your entered criteria for commas representing the
    separation of two Between values. You may be able to use the
    TdaQueryDataView.BeforeGenerate event to access the TdaSQL object which in
    turn gives you access to the TdaCriteria.Value property.

    Another option would be to alter the ppParseString method of the ppUtils.pas
    file so it takes commas in the field value into account. I will look at
    changing this for the next release.

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • rbuserrbuser
    edited November 2004
    Nico,


    Thanks. I'll look into these and see if they will allow me to handle this
    situation.


    That would be great. I'll look into changing this, but I'm a bit concerned
    about changing something where I don't know the full impact of the change.

    --

    ---------------------------------------
    Terry Swiers
    Millennium Software, LLC
    http://www.1000years.com
    http://www.atrex.com

    Atrex Inventory Control/POS -
    Big business features without spending big business bucks!

    Atrex Electronic Support Options:
    Atrex Knowledgebase: http://www.atrex.com/atrexkb.cfm
    Email: mailto:support@atrex.com
This discussion has been closed.