>>>I've been asked to create some reports from a SQL database using Crystal. I have no idea where to start. Can printing be automated through SSIS or SQL Agent using Crystal?
>>
>>Greg
>>
>>Will these reports run from the desktop?
>
>They could, although I would prefer automation via a SQL job or task scheduler.
Greg, I haven't used Crystal in years, but when I had to do this, I'd create an EXE in .NET that would access the Crystal reports engine (with a reference to a CR RPT file that accessed SQL Server) via API calls. Once I knew the EXE was working, it could be used as a step in a SQL Agent job
If that's the general direction you'd like to go, I can post some samples.