Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can CRXI execute a sql script?

Status
Not open for further replies.

jaburke

Programmer
May 20, 2002
156
US
Hi,
I want to create a crystal report that kicks off a sql script on my unix server. Can this be done??? Thanks...
 
I haven't used XI yet, but I've seen it done in 9, with a custom function. I was able to perform individual SELECTs for each field on the report. Of course I had to check to see if non-SELECTs worked as well... they did. This was on a Labware LIMs system.

~Thadeus
 
I don't think it is going to do what I need, so I am going to turn the sql script into a stored procedure. Thanks...
 
Crystal can run a SQL sp, but for obvious reasons you need to be very careful. What exactly are you trying to do?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top