Steven,
I did try that but it doesn't work. It looks like what I need to do is set the type of cursor that Crystal uses.
So far this seems to be impossible unless I use a record set to establish the connection for me.
I've got a stored procedure that is intended for use with a crystal report. The procedure is quite complex,
building up a temporary table and then updating it with denormalised data, eg alias's for multiple people
associated with the base record.
The SP runs well enough from query analyser...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.