Crystal Reports Reoccurring reports

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Reoccurring reports

Author	Message
pruef Newbie Joined: 04 Apr 2007 Location: United States Online Status: Offline Posts: 7	Topic: Reoccurring reports Posted: 02 Jul 2007 at 1:40pm
	Does crystal report have the ability to create reoccurring reports? I have a report that I want to run every morning with the date changing to the previous days date. I would also like this report to manually print out each morning whether I'm here or not. Edited by pruef - 03 Jul 2007 at 8:55am
	Patty Ruef Small Oregon Police Department
	IP Logged

jkwrpc Senior Member Joined: 19 Jun 2007 Location: United States Online Status: Offline Posts: 432	Posted: 02 Jul 2007 at 2:05pm
	Create a formula, call it want you want, perhaps datePrevDay In the place provided cut & paste this code, I tested it so it works (between the dashed lines). -------------------- CDate(DateAdd("d", -1, CurrentDate)) ----------------- This returns 7/1/2007 for the date which is yesterday. Then use the formula like you would any other report field. Regards, John W. www.CustomReportWriters.net
	IP Logged

hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3702	Posted: 02 Jul 2007 at 8:20pm
	John's suggestion for setting up the date is a good one. To actually get the report to run every day, you have a couple of options: 1. Create a program that will run your report. Set up a schedule in the Windows Scheduler to run that program. If you are a programmer, this is the least expensive option. 2. Install Crystal Server, publish the report to it and create a schedule to run it. 3. If you have the full BusinessObjects Enterprise, publish the report there and create a schedule to run it. This is the most expensive option if you don't already have BOE. -Dell
	Proviti, Data & Analytics Practice www.protiviti.com/US-en/data-management-advanced-analytics
	IP Logged

Kevinma Newbie Joined: 14 May 2007 Online Status: Offline Posts: 6	Posted: 18 Jul 2007 at 8:54pm
	patty I have a report with 2 parameters of start and end date for a generic report, and a formula giving the incident date from a date time record. When I schedulled the report I removed the part of the filter which said: @Incidentdate >={?StartDate} and @Incidentdate<={?EndDate} and replaced it with: @Incidentdate = Currentdate-1 It then works great. if I wanted it to show a week, then: @Incidentdate >Currentdate-7 and @Incidentdate<Currentdate-1 and schedulled every Mon morning. Kevin M
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.016 seconds.