Newbie Stored Proc Question

[OldestChild]

This is probably trivial, but I'm not finding the info, so... help?

I have a database driven Crystal Report (XI rel 2). I need a detail field to come from a stored procedure, with parameters passed into it. Those paramaters are other vaules in the detail list. (ex: detail includes two database fields which I want to pass into a stored proc, which returns a value I want included in the detail line). The database is SQL Server.

Help?

Thanks,
Larry

[rahulvasanth]

If you have a OUTPUT paramemter in youe stored procedure, then it will not work with crystal reports.

This is a known issue with crystal reports.

If you are using a stored procedure for your crystal reports, then make sure that the stored procedure does not have any output parameters.