Passing parameters to Crystal reports

[Dan Aldean]

Hi,

To create a Crystal Reports I use a ReportViewer.
How can I pass parameters to the report which is based on a stored
procedure.
Please provide some code.

Thanks

[sloan]

I would recommend using the "Push" model instead.

Create a strong dataset.
Build the report based on the dataset or xsd schema.
populate an instance of the dataset.
Use the SetDataSource method.

Google
"Crystal Reports" push pull
for more info.


"Dan Aldean" <do*******@rogers.comwrote in message
news:ey**************@TK2MSFTNGP06.phx.gbl...

Hi,

To create a Crystal Reports I use a ReportViewer.
How can I pass parameters to the report which is based on a stored
procedure.
Please provide some code.

Thanks

[Cor Ligthert [MVP]]

Dan,

Very simple as you know it. (only the essential part for which I have too
searched very long)

foreach (CrystalDecisions.CrystalReports.Engine.Table table in
TheDoc.Database.Tables)
{
table.Location = "TheDataBase.TheStoredProcedure;1";
}

Cor

[Dan Aldean]

Thank you!