CR 5.0 and MSSQL stored procs 1

[khug]

Hi all,
I am not a Crystal user/developer, so I hope my question isn't too stupid.......anyway, here goes:
I want to write a stored proc in MSSQL that simply
populates a table with data extracted and manipulated from other tables in the database. (Note: The proc expects one input parameter (a character date)). My user says that she gets an error
akin to "..no output data.." when she calls the stored
proc from her Crystal 5.0 report. I guess this may be
because I'm not returning a resultset. Is there a way to prevent
this error from occuring in her report? Can her report
(or is it subreport?) be set up to use the output table
instead of expecting a resultset from my proc? Thanks for
any help you can provide.......Karen
[sig][/sig]

 

[kenhamady]

I am not an expert in stored procedures, but can't you add a final step to the procedure that selects the fields from the table? In other words, end with a result set from your final table?

You could point the report to the table, but that won't launch the procedure.

[sig]<p>Ken Hamady-

http://www.kenhamady.com<br><a

href=

http://www.kenhamady.com/>Crystal

Reports Training by Ken Hamady</a><br>[/sig]

 

[MalcolmW]

If you want to call the sp from a report, it must have a result set. There can be zero rows in the result set, but there at least must be a result set.
So, if you want to get rid of the error, just finish off your sp with
SELECT *
FROM anytable
WHERE 0=1
This won't do anything meaningful, but it won't take too long, and will get rid of the error.

[sig][/sig]