Alright - if people don't mind I might doing this type of thing all weekend long and - that is Asking a question and Answering it in another post.
One answer to that question can be to use an alias for the two parameters. So, in the report query ( in the SQL command in the report definition ) I would enter this: SELECT *, DateField AS StartDate, DateField AS EndDate FROM TABLE WHERE StartDate >= :StartDate AND EndDate <= :EndDate Then in the report I can reference the fields StartDate and EndDate On 5/18/07, Andrew Jensen <[EMAIL PROTECTED]> wrote:
To clarify a question I posed earlier. What I want to know is how to find the parameters that where used to generate the report, from within the report. I have a report that prints out sales orders. It is based on a query that takes two parameters: :StartDate and :EndDate The user runs the report and enters the values 01/01/07 and 01/31/07 On the report I want to print in the report header SALES REPORT FOR PERIOD 01/01/07 TO 01/31/07 The question is how do I get to that information? Drew
