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

Pass two Dates to AutoSearch Fields?

edited February 2017 in End User
Hi Team,

In my report I have a Search criteria of Inv.Date Between dd/mm/yy, dd/mm/yy. AutoSearch is Yes.
In the App, Each of the dates is in a text string StartDate & EndDate.
How do I pass the two dates with 'ppR1.AutoSearchFields[0].SearchExpression :=' please?
Regards & TIA,
Ian

Comments

  • edited February 2017
    Hi Ian,

    If the search operator is BETWEEN, you can simply separate the two date
    values by a comma and they will be processed as the two dates to be used
    in the query.

    Another option is to use report paramters and assign the two dates to
    the Values property.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited February 2017
    Hi Nico,
    Thank you for your reply.
    Ah Ha! Done & Dusted.
    Thank you very much.

    Regards,
    Ian
This discussion has been closed.