Scheduling a report with data parameters

[syncdba]

Hi,
I have created a report in CRXI with Start_date & End_date parameters as {Command.DATE} in {?Start_Date} to {?End_Date}

I have scheduled the report on BOXI in Excel format for EVERYDAY.
Is it posiible server can update the END_DATE automatically with "Today_Date" before sending report to user for everyday.

Any Help!!
Thanks.

 

[Turkbear]

Hi,
How are you scheduling this with those parameters?
How does it 'get' the Start Date, for instance?

Anyway, you can use CurrentDate instead of END_DATE in your selection formula...

In Fact, using something like

where Date in (CurrentDate - 7) to CurrentDate

will give a 1 week range for selection...





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[crsdev]

do END_DATE = currentdate

 

[syncdba]

Actually, I have a column as date which has set of dates and I'm taking the date range of that column which is dates between start_date and end_date. So that report will show data between start_date & End_date and now I want end_date to be the todays date.

I want scheduled object to be updated automatically with current date.

 

[Turkbear]

Hi,
So, whats the problem?

In {tabledata.start_date} to CurrentDate

should do that...





To Paraphrase:"The Help you get is proportional to the Help you give.."