protected void Page_Load(object sender, EventArgs e) { DataSet1 dsOrder = new DataSet1(); DataTable dtOrder = dsOrder.Tables[0]; dtOrder.Rows.Add("lideng", "125", "M", "1"); dtOrder.Rows.Add("lideng1", "13", "M", "1"); dtOrder.Rows.Add("lideng2", "14", "M", "2"); dtOrder.Rows.Add("lideng3", "15", "M", "2"); DataSetLine dsOrderLine = new DataSetLine(); DataTable dtOrderLine = dsOrderLine.Tables[0]; dtOrderLine.Rows.Add("11", "Desc", "33", "GST1", "1"); dtOrderLine.Rows.Add("11", "Desc", "33", "GST1", "1"); dtOrderLine.Rows.Add("22", "Desc", "44", "GST2", "2"); dtOrderLine.Rows.Add("22", "Desc", "44", "GST2", "2"); ReportDataSource rds = new ReportDataSource("DataSet1", dtOrder); ReportDataSource reportDataSource = new ReportDataSource("DataSet2", dtOrderLine); ReportViewer1.LocalReport.DataSources.Clear(); ReportViewer1.LocalReport.DataSources.Add(rds); ReportViewer1.LocalReport.DataSources.Add(reportDataSource); ReportViewer1.LocalReport.Refresh(); }
protected void btnPrintReport_Click(object sender, EventArgs e) { //DataTable dt = new DataTable(); //dt.Columns.Add(new DataColumn("Name")); //dt.Columns.Add(new DataColumn("Age")); //dt.Columns.Add(new DataColumn("Sex")); //dt.Rows.Add("lideng", "12", "M"); //dt.Rows.Add("lideng1", "13", "M"); //dt.Rows.Add("lideng2", "14", "M"); //dt.Rows.Add("lideng3", "15", "M"); DataSet1 dsOrder = new DataSet1(); DataTable dtOrder = dsOrder.Tables[0]; dtOrder.Rows.Add("lideng", "125", "M","1"); dtOrder.Rows.Add("lideng1", "13", "M","1"); dtOrder.Rows.Add("lideng2", "14", "M","2"); dtOrder.Rows.Add("lideng3", "15", "M","2"); DataSetLine dsOrderLine = new DataSetLine(); DataTable dtOrderLine = dsOrderLine.Tables[0]; dtOrderLine.Rows.Add("11", "Desc", "33","GST1","1"); dtOrderLine.Rows.Add("11", "Desc", "33", "GST1", "1"); dtOrderLine.Rows.Add("22", "Desc", "44", "GST2", "2"); dtOrderLine.Rows.Add("22", "Desc", "44", "GST2", "2"); LocalReport localReport = new LocalReport(); localReport.ReportPath = Server.MapPath("Report.rdlc"); ReportDataSource reportDataSource; reportDataSource = new ReportDataSource("DataSet1", dtOrder); localReport.DataSources.Add(reportDataSource); reportDataSource = new ReportDataSource("DataSet2", dtOrderLine); localReport.DataSources.Add(reportDataSource); string reportType = "PDF"; string mimeType; string encoding; string fileNameExtension; string deviceInfo = "<DeviceInfo>" + " <OutputFormat>PDF</OutputFormat>" + " <PageWidth>21cm</PageWidth>" + " <PageHeight>29.5cm</PageHeight>" + " <MarginTop>0.5in</MarginTop>" + //" <MarginLeft>1in</MarginLeft>" + //" <MarginRight>1in</MarginRight>" + " <MarginBottom>0.5in</MarginBottom>" + "</DeviceInfo>"; Warning[] warnings; string[] streams; byte[] renderedBytes; //Render the report renderedBytes = localReport.Render( reportType, deviceInfo, out mimeType, out encoding, out fileNameExtension, out streams, out warnings); Response.Clear(); Response.ContentType = mimeType; Response.AddHeader("content-disposition", "attachment; filename=TRANSACTIONDETAILS." + fileNameExtension); Response.BinaryWrite(renderedBytes); Response.End(); }