Hi. I have a custom user-defined report that I want to schedule to run monthly. In my crystal report I have a formula that is set for Begin and End date in order to pick up the previous months data.
@startdate = :datevar LastDateOfPenultimateMonth := dateserial(year(currentdate),month(currentdate) - 1,1 );
@enddate = datevar LastDateOfPenultimateMonth := dateserial(year(currentdate),month(currentdate) - 0,1 );
If I run the report in crystal it is picking up the correct data range but when I schedule the report to run nothing happens.
Does anyone have any advice.
Thanks so much in advance!
@startdate = :datevar LastDateOfPenultimateMonth := dateserial(year(currentdate),month(currentdate) - 1,1 );
@enddate = datevar LastDateOfPenultimateMonth := dateserial(year(currentdate),month(currentdate) - 0,1 );
If I run the report in crystal it is picking up the correct data range but when I schedule the report to run nothing happens.
Does anyone have any advice.
Thanks so much in advance!