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 \)]

Re: C# Crystal Reports Question

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,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Ed Crowley" <curspice@pacbe ll.net> wrote in message
news:OrxO6IpsDH A.3656@TK2MSFTN GP11.phx.gbl...[color=blue]
> How do you use a stored procedure as the datasource for a report in[/color]
Crystal[color=blue]
> Reports .NET for C#?
>
>[/color]

[Ed Crowley]

Re: C# Crystal Reports Question


"Ignacio Machin ( .NET/ C# MVP )" <ignacio.mach in AT dot.state.fl.us > wrote
in message news:OdCk9QpsDH A.1740@TK2MSFTN GP12.phx.gbl...[color=blue]
> 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.[/color]

Cheers. That checkbox should be checked by default IMO!