Crystal Report with Stored Procedure

[Rick]

I have created a Crystal Report in VS2005 using a Stored Procedure in SQL
Server 2005..
I added a report and set the Datasource to my Stored Procedure.
Why can't I expand the Stored Procedure to view field names in teh 'Standard
Report Creation Wizard' dialog box under 'Available fFields:'?
I see a plus sign in front of the Stored Procedure name but it won't expand.

 

[Lloyd Sheen]

I have created a Crystal Report in VS2005 using a Stored Procedure in SQL
Server 2005..
I added a report and set the Datasource to my Stored Procedure.
Why can't I expand the Stored Procedure to view field names in teh
'Standard
Report Creation Wizard' dialog box under 'Available fFields:'?
I see a plus sign in front of the Stored Procedure name but it won't
expand.

I can only imagine it is because to get a list of columns it would have to
execute the procedure. Tables and view have meta data which describes the
columns so no execution on the server is required other than extracting the
meta data.

Another possible reason is that a stored procedure can return multiple
return sets and can return data with different columns depending on
parameters / data etc.

I know this doesn't help but it might explain.

LS