C# Crystal Reports Question

[Ed Crowley]

How do you use a stored procedure as the datasource for a report in Crystal
Reports .NET for C#?

 

[Ignacio Machin \( .NET/ C# MVP \)]

Hi Ed,

You should see a list of SP in the datasource dialog of the database
expert, here is a fragment from
http://www.crystalreportsbook.com/Chapter14.asp

To select the data source from the Database Expert dialog, click on the
proper category node to expand it. This automatically pops up a dialog box
asking you for information about the data source. The dialog changes to
match what is needed for each data source. This information could be
anything from a simple file path to a database server name and the
appropriate logon credentials. After you enter the information the dialog
box closes and the data source name is shown in the Database Expert and?
listed under its category. Under the data source name is the list of
available tables, views and stored procedures.[1] Click on the plus sign
next to each one to expand the list.

Hope this help,

 

[Ed Crowley]

Hi Ed,

You should see a list of SP in the datasource dialog of the database
expert, here is a fragment from
http://www.crystalreportsbook.com/Chapter14.asp

To select the data source from the Database Expert dialog, click on the
proper category node to expand it. This automatically pops up a dialog box
asking you for information about the data source. The dialog changes to
match what is needed for each data source. This information could be
anything from a simple file path to a database server name and the
appropriate logon credentials. After you enter the information the dialog
box closes and the data source name is shown in the Database Expert and?
listed under its category. Under the data source name is the list of
available tables, views and stored procedures.[1] Click on the plus sign
next to each one to expand the list.

Cheers. That checkbox should be checked by default IMO!