Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Scheduled report will not run

Status
Not open for further replies.

coolcin

Technical User
Mar 20, 2006
1
US
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!

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top