>>>>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.

That would be great! Thank you Kevin. Is there another/better approach?