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.
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.