How can I load Crystalreport with StoredProcedure in C#.

[anoopgopal007]

Hi friends...

I have one problem...
I am using C#, and CrystalReport9.
In my project I used StoredProcedure with one input parameter.

My Problem:

I would like to load my report.
But It seems lot of errors....

Please help me... "How can I load Crystalreport with Stored Procedure."
If u can give sample code also....

Thanking u....

[kenobewan]

Yes you can use a stored procedure. What are the errors?

[luwina]

Hi,

Load a crystalreportvi ewer in your form. Put the code at Page_Load().


here's the code:
OdbcCommand com = new OdbcCommand("CA LL sp_name(?)", con);
com.CommandType = CommandType.Sto redProcedure;

com.Parameters. Add(new OdbcParameter(" ?param1", OdbcType.Int, 3));
com.Parameters["?periodid"].Direction = ParameterDirect ion.Input;
com.Parameters["?periodid"].Value = 41;

OdbcDataAdapter da = new OdbcDataAdapter ();
DataSet ds = new DataSet();

da.SelectComman d = com;
da.Fill(ds, "tablename" );

CrystalDecision s.CrystalReport s.Engine.Report Document myReportDocumen t;
myReportDocumen t = new CrystalDecision s.CrystalReport s.Engine.Report Document();
myReportDocumen t.Load(@"C:\ASP .NET\Reports\Re portName.rpt");
myReportDocumen t.SetDataSource (ds);
CrystalReportVi ewer1.ReportSou rce = myReportDocumen t;
CrystalReportVi ewer1.DataBind( );


Hope it helps :)

Luwina