Date Selected by User when report is run

edited January 2013 in End User
My user wants to be able to select a date, and have the report choose only
the information that falls within the 2 week period starting with that date,
without the user having to select the end date. They are using a datetime
field, and we want to only consider the date - not the time.

How can I make that happen?

Helga Smith


  • edited January 2013

    1. Create a Report.Parameters[ ] item

    From the Design workspace find that Parameters node in the report tree,
    press the right mouse button and select New.. from the context menu.

    2. Use Object Inspector to set Parameter properties:

    Name := myParamName
    DataType = dtDate
    AutoSettings.Enabled = True

    3. Use Query Designer to bind query search condition to Parameter

    Nard Moseley
    Digital Metaphors

    Best regards,

    Nard Moseley
    Digital Metaphors
This discussion has been closed.