Date Selected by User when report is run
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
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
This discussion has been closed.
Comments
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
www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com