How do I pass parameters to a stored procedure? I have done this in the past with older versions of crystal but there doesnt seem to be anyway to pass parameters.
When I show Sql from the database menu I get the following
{call StoredProcedureName(?,?,?)}
That is the correct number of parameters but there is no way I can put in literals or crystal parameters in there.
I am using 8.5 and sql server 2000 and this is a sub report I am trying to get data into. BTW a version of the stored procedure that has no parameters works fine in crystal.
Thanks in advance.
When I show Sql from the database menu I get the following
{call StoredProcedureName(?,?,?)}
That is the correct number of parameters but there is no way I can put in literals or crystal parameters in there.
I am using 8.5 and sql server 2000 and this is a sub report I am trying to get data into. BTW a version of the stored procedure that has no parameters works fine in crystal.
Thanks in advance.