February 6, 2004 at 12:28 pm
Greetings!
I want to create reports upone certain triggers and email them to users. To keep things flexible, I was going to use Crystal Reports to generate the result to be mailed, and then use xp_sendmail to send the message on its way.
Is there a Crystal Reports procedure?
If not, would the best way be:
- Create/use a command line interface and use xp_cmdshell to execute it
- Create an xp_ExecCrystalReport(rptimage, outfmt, xtraparms) as outimage
- Use the sp_OA OLE automation Objects
Any thoughts?
TIA,
Thor Johnson
February 7, 2004 at 8:11 am
I dont use Crystal much so can't tell you if they have some other support for what you're doing. For stuff like this I often build a small executable to do the processing. That way I stay away from sp_oa and I don't have to use xp_sendmail either.
February 9, 2004 at 6:12 pm
I agree with Andy, buld a small exe and have it do the processing. Just have your trigger put a record into a table that the exe looks at for items it needs to process.
I would stay away from sp_OA as much as possible. If the com component fails it could take down your server. Not something I want to happen on my servers!
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply