Not able to add stored procedure to the crystal Report 8.5

[rahulvasanth]

Hi

I have a stored procedure which I want to add to the crystal report. But I m not able to add this stored procedure to the report. But I m able to add other stored procedures to the report.

I want to know if there is any restrinctions in adding stored procedures to the crystal reports.

Thanks in advance

[Silly Star]

i hope there is no restriction like that

u r using VB6 or .Net?
nd does ur stored procedure have parameters?

[rahulvasanth]

I m using VB 6.0

and I m using both input and output parameters

I m also creating temp table inside the stored procedure

and I m also using truncate statement in the stored procedure

and I m also calling another stored procedure inside this stored procedure which populates the values of temp table.

Hope the above details are enough

I m looking forward to getting some positive solution ugernt

thanks in advance

[rahulvasanth]

TO be more specific,

I m able to add the stored procedure to the crystal report, if I remove the output parameters.

So how do I add a stored procedure with output parameters to the crystal reports or what value can I assign to a output parameter while passing the values to the parameters in the stored procedure.

[rahulvasanth]

I got the solution, FINALLY !

Crystal Reports do not handle Output parmeters, so if you have an output paramenter in your stored procedure, then yoou cannot add it into the crystal reports, and also in case if u are using temp (#) table, then you need to create and populate the temp tables in the stored procedure itself because crystal reports will run in a new connection.

[request]

hi
i am trying to add stored procedure which creates temperory table , while adding i couldn't see the fields which are in this temp table. i have written select * from # temp in that stored procedure , even then i didn't get those fields ....is there any way to do this
if u have any idea do help me.
Request.

[rahulvasanth]

If your stored procedure has output parameters, then forget it, your report will not work, because crystal reports will not work with stored procedures having output parameters.

But if you don't have any output parameters, then you should be able to use the stored procedure along with the crystal report. But haveing temp table should not be a problem. Even I was using temp table. when you set the stored procedure for the crystal reports, crystal report prompts you for the parameter values, you have to enter values which will return some records, then you will be able to see the fields of your stored procedure and add it into the crystal report.