Scheduler?

[Johnsf]

Hi,

Can anyone recommend a good Scheduler that works with reports done in Crystal 8.5 which have their datasource as Crystal SQL Designer qry files, which in turn use an ODBC data source?

I cant seem to get reports that use .qry files as datasources to work with any of the schedulers available on the net.

Cheers,

John

 

[rhinok]

For a list of schedulers/viewers, check out

http://www.kenhamady.com/bookmarks.html.

I've successfully scheduled query-based reports from Crystal Enterprise, so I know its possible. Remember, the scheduling server has to have rights to the directory in which the queries are stored (if the queries are stored external to the server). I'd recommend full UNC path mapping rather than shares. This might resolve your issue, too.


~Kurt

 

[Johnsf]

Ive got Crystal Enterprise 8.5. Is it possible to schedule a report to run and export to a text file at a certian time in Crystal Enterprise 8.5?

Thanks,

John

 

[rhinok]

If you have CE 8.5 Professional, then you can schedule reports to run at specific times and in specific formats (text being one of them). In fact, Crystal Enterprise has some really nice scheduling options.

It sounds like you're not too familiar with Crystal Enterpise. You might want to attend a course or pick up the book Special Edition Using Crystal Enterprise 8.5.

If you have the option, it may be a better idea to upgrade to Crystal Reports 9/10 with Crystal Enterprise 9/10. The newer versions of Crystal Reports allow you to create a SQL Command object, which would let you embed your query's sql directly in the report instead of an external object. The downside is that you'd have to design the report from scratch and then paste the SQL in.


~Kurt

 

[Johnsf]

Oh well Ive got Crystal Enterprise 8.5 Standard so I cant schedule using it and need to use an external scheduling software. But I cant find any that will work with reports that are based on qry files.