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]

Thank you for the reply.

How can I bind the report to the dataset, thru the datasource or viewer
object?

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

 

[sloan]

http://www.google.com/search?hl=en&q="Crystal+Reports"+push+pull&btnG=Google+Search


CodeGuru.com link

about the 5th one down... at the time of writing..

 

[Dan Aldean]

Thank you!