Hi Gang,
Rather new to CR...
In CR X, I am using a SQL query (in DATABASE EXPERT>COMMAND) that uses the following to set the date parameter for the report:
**** snip****
DECLARE @BegDate datetime;
DECLARE @EndDate datetime;
SET @BegDate = '20090101'
SET @EndDate = '20091231'
***end snip****
later in the query I evaluate against the record.timestamp to gather the proper records within the date range.
****
SELECT blah, blah, blah FROM abc WHERE more stuff here and c.create_timestamp >= @BegDate
and c.create_timestamp < @EndDate + 1)
****
I don't like this setup (I inherited) and would like to know how to remove the hard-coded date range from the query and have the report user get a prompt from CR for a date range AND how to display the date range in the report page header.
Thx
-ChicagoPete