Filter CrystalReport DataSet and binding to the report asp.net
I want to filter dataset taken to bind report. my code is something like this
Mohan.Reports.DataSet1 ds1 = DataAccess.TNA_APPROVAL_DATA_FOR_PRINTING_STYLEWISE(DateTi开发者_开发技巧me.Now.Date, ddlStyle.SelectedValue);
ds1.Tables[0].Select("StyleNO='" + ddlStyle.SelectedValue + "'");
Reports.CrystalReport1 rp = new Mohan.Reports.CrystalReport1();
//DataRow dt =(DataRow) ds1.Tables[0].Select("StyleNO='" + ddlStyle.SelectedValue + "'");
reportTnaApprovalbyUser.SetDataSource(ds1.Tables[0].DefaultView.RowFilter = "StyleNO='" + ddlStyle.SelectedValue + "'");
CrystalReportViewer1.ReportSource = reportTnaApprovalbyUser;
But Data is not displaying on report. I think filteration is not working.... Please Help
精彩评论