How do I use a Stored Procedure with different return recordsets

[jogro]

I have a SP(stored procedure) that, depending on the input parameters, can output different fields.

So when I attempt to design the report in Crystal Reports 9 I specify the SP and the default parameters and it results in putting one subset of my recordsets on the report as per the parameters.

How do I insert fields onto the report that I know will be returned from my SP? I need to do this as I am calling the report dynamically from ASP and want to be able to design the report fields to be laid out as best as possible. Should I use many alias' of the same SP?

thanks

 

[synapsevampire]

You might use aliases in the SP for the columns, and then Crystal will have standardized column names to work with.

You would also have to return something from the SP stating what it had done to allow for naming the columns, etc.

Not a pretty way to work in CR.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com