Crystal Report with Stored Procedure


R

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.
 
Ad

Advertisements

L

Lloyd Sheen

Rick said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top