Report Parameter passed to Stored Procedure

[jimache]

Hi everyone,

Is there a way to pass a reports parameters to a SQL stored procedure that uses parameters?!!? I do not seem to find a way to do that... Any input is welcomed.

Thank you.

 

[MisterMo]

As soon as you add a Stored Proc the parameter of that Stored Proc will be automatically added to the report

What version of CR and Database


-Mo

 

[jimache]

I get the divide by zero error.. is there a way around that... i am using CR for VS.NET 2003 and SQL server 2000 SP 3a.
Thank you

 

[MisterMo]

The divide by zero is either within the SP or a Crystal formula.

either way you need to check the code to cover for such eventuality.


-Mo