| Author |
Message |
SDas
Newbie
Joined: 04 Jan 2010
Location: India
Online Status: Offline
Posts: 3
|
  
Topic: Scheduling from batch
Posted: 04 Jan 2010 at 1:09am |
Hi Experts,
Can anyone advice how to schedule a crystal report from batch file? Here is the scenario –
1. A report (Rpt1) developed in Crystal Report 10. Now we want to schedule that report with parameter Report Date = Sys Date only when a particular excel file (i.e Excl1.xls) is available in specific folder on E Drive (E:\KeyFold).
2. To automate the entire process we have introduced a batch file and schedule it with windows scheduler. Now, I want to include above activity mentioned against point 1 in that batch.
Any idea how to do that? Any suggestion will be appreciated.
|
|
Regards,
Das, Sumanta Kumar
|
 IP Logged |
|
|
|
hilfy
Admin Group
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
|
Posted: 04 Jan 2010 at 6:58am |
You can't schedule from a batch file - there's no way to access the properties that you need from a command prompt.
However, you could write a small .NET or Java program using the Crystal SDK that would set the login and parameters, run the report, and export it to whatever format you need. Your .bat file could then run that program to generate the report.
-Dell
|
|
|
| IP Logged |
|
AdamField
Groupie
Joined: 04 Jun 2009
Online Status: Offline
Posts: 88
|
Posted: 04 Jan 2010 at 9:19am |
Anybody knows a free and good working sheduler then ?
i tried some program's but or they don't work (for me) or there very expensive
Adam
|
| IP Logged |
|
hilfy
Admin Group
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
|
Posted: 04 Jan 2010 at 9:31am |
Have you checked here:
This is a good list of what's available. I haven't used any of them, so I can't recommend anything specific, though.
Also, if you have the Developer version of Crystal, I believe it includes a 5 concurrent user license for Crystal Server which you can use to schedule reports.
-Dell
|
|
|
| IP Logged |
|
AdamField
Groupie
Joined: 04 Jun 2009
Online Status: Offline
Posts: 88
|
Posted: 04 Jan 2010 at 9:39am |
Hey Hilfy,
It did check that link before but seems like there are some new ones,
will check it out again so tnx for it !!
Adam
|
| IP Logged |
|
SDas
Newbie
Joined: 04 Jan 2010
Location: India
Online Status: Offline
Posts: 3
|
Posted: 05 Jan 2010 at 3:07am |
Hilfy,
Thanks for your reply. Well, as per policy we can't use any freeware  ..seems need to introduce a Windows service using Crystal SDK which will take care of scheduling requirement.
One more query. Is Crystal SDK come with standard installation pkg or need to get it seperately?
Regards,
Das.
|
|
Regards,
Das, Sumanta Kumar
|
| IP Logged |
|
hilfy
Admin Group
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
|
Posted: 05 Jan 2010 at 6:15am |
I'm not exactly sure, but I think that it only comes with the Developer version. However, it comes with Visual Studio. So if you're going to write the service using .NET, you don't need anything else. If you're going to write it in Java, Delphi, or regular VB (not VB.Net), I believe you'll have to upgrade your license.
-Dell
|
|
|
| IP Logged |
|
SDas
Newbie
Joined: 04 Jan 2010
Location: India
Online Status: Offline
Posts: 3
|
Posted: 05 Jan 2010 at 6:25am |
Will check it. Thanks for your help 
|
|
Regards,
Das, Sumanta Kumar
|
| IP Logged |
|
|
|
