Hi there,
I'm using Crystal Reports XI with MS SQL 2005.
I have a fairly simple stored procedure which accepts three parameters, dynamically creates a table with variable columns. At the end of the stored procedure is a statement which reads...
SELECT *
FROM #temp_table
I can create the report and it connects to the stored procedure okay. It even prompts me for values for the parameters in my stored procedure. After doing that though I'm taken to a blank report template ready to drag my stored procedure fields onto my report.
However there are no fields listed under my stored procedure. When I run the report it just comes back with no data at all. I modified the stored procedure so that I set the variables inside the procedure so it no longer requires variables and it works fine.
For some reason when using parameters it just dies as I described above but the minute I remove the parameters and set them manually in the body of the stored procedure everything is fine. I would love some help with this one if you've come across this before.
Kind regards,
Chris