How to use dataset as Crystal report's source

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • faisalmushtaq
    New Member
    • Dec 2007
    • 7

    How to use dataset as Crystal report's source

    Hello to all brains,
    i am relativly new to this programming world and i need tons of favor from u guys.My problem i want to use a dataset's table as my report source.Report also takes some other parameters.Now my first question is how do i set datatable as my report source and my 2nd question is how to pass parameters.Alth ough i have attempted to do this by the below mentioned code.

    // Making report instance
    [code=vbnet]
    Reports.RptNewM odifiedInsuranc es objRptNewModifi edInsurances = new Reports.RptNewM odifiedInsuranc es();

    //Making and passing parameter to report

    objParameterFie ld = new ParameterField( );
    objParameterFie ld.Name = "@FromDate" ;
    objParameterDis creteValue = new ParameterDiscre teValue();
    objParameterDis creteValue.Valu e = dtpFrom.Value;
    objParameterFie ld.CurrentValue s.Add(objParame terDiscreteValu e);
    objParameterFie lds.Add(objPara meterField);

    objParameterFie ld = new ParameterField( );
    objParameterFie ld.Name = "@ToDate";
    objParameterDis creteValue = new ParameterDiscre teValue();
    objParameterDis creteValue.Valu e = dtpTo.Value;
    objParameterFie ld.CurrentValue s.Add(objParame terDiscreteValu e);
    objParameterFie lds.Add(objPara meterField);


    ReportViewer objReportViewer = new ReportViewer();
    objReportViewer .MdiParent = this.MdiParent;

    objReportViewer .crViewer.Param eterFieldInfo = objParameterFie lds;

    // Assigning datatable as report source,here it throws exception

    objRptNewModifi edInsurances.Se tDataSource(Bus inessLayer.BusG eneral.ds.Table s["usp_rp_new_mod _insurance"]);
    [/code]
    The error message is "The report has no tables."

    Please help me this time :-( I am waiting for your kind response.
    Last edited by debasisdas; Dec 11 '07, 08:54 AM. Reason: formatted using code tags
Working...