Susan,
I created something like this with VB.Net and the
ARS .Net API - reports are created at the server and emailed, either
on demand or scheduled. Since there are no parameters or qualifications
(outside the report file) the programming will be easier.
Using Visual Studio 2003 Professional or
higher:
Create a new .Net console application. Add the CR
report file to the application. This should automatically add the
necessary Crystal Reports references. Set the CR properties for the
report, including the output format (ie. pdf, Excel, Word, etc). Note: If
you haven't done this part before it may take a little while. Compile and
run.
Once the application runs fine all you need to do to
create this particular report is simply run the exe. Once the report
output file is created your scheduled process could then email it. You
could also build the email functionality within the .Net console application and
pass in the list of email addresses that need to receive the
report.
For phase II:
Pass in the filename of the CR report file instead of
embedding it within the exe. This allows you to reuse this one application
to generate any CR report.
I know this is a summary view of creating this type of
application; I hope this at least gets you started.
Stephen
Since we're on the topic, the OOB CR reports that come
with Help Desk 5.5 generate much faster when run at the server instead of the
client. When run from the User Tool reports usually take 1-2
minutes. When run at the server they take 1-5
seconds!
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer
Sent: Wednesday, May 03, 2006 10:17 AM
To: [email protected]
Subject: Automated Crystal Report on Win2003 Server
Hi everyone,
We have a need to automatically run a Crystal report at 4:00 am
everyday and have it sent via email to someone in England (from
U.S.). We do NOT have Crystal Server. Luckily there will not be any
parameters that need to be supplied to the report.
Is there a way to have the server's job scheduler do
this? Anyone doing this?
Thanks for your help,
Susan
OS: Windows NT 5.0
2CPU's 4G Memory
Database: Oracle 9i2
User: ARS 5.1.2
Patch 1316
User OS: XP, NT, Win 2000
Admin: ARS 5.1.2 Patch
1289
Crystal that created reports: 9
