Environment versions
Network:
Windows 2000 Server
>>>>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?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only