static string GetTableColumns(ReportBuilder reportBuilder, ReportTable table) { ReportColumns[] columns = table.ReportDataColumns; ReportTextBoxControl ColumnCell = new ReportTextBoxControl(); if (columns == null) { return(""); } string strColumnHeirarchy = ""; strColumnHeirarchy = @" <TablixColumns>"; for (int i = 0; i < columns.Length; i++) { ColumnCell = columns[i].ColumnCell; strColumnHeirarchy += @" <TablixColumn> <Width>" + ColumnCell.Size.Width.ToString() + @"cm</Width> </TablixColumn>"; } strColumnHeirarchy += @"</TablixColumns>"; return(strColumnHeirarchy); }
static string GenerateTableHeaderRow(ReportBuilder reportBuilder, ReportTable table) { ReportColumns[] columns = table.ReportDataColumns; ReportTextBoxControl ColumnCell = new ReportTextBoxControl(); ReportDimensions padding = new ReportDimensions(); if (columns == null) { return(""); } string strTableRow = ""; strTableRow = @"<TablixRow> <Height>0.6cm</Height> <TablixCells>"; for (int i = 0; i < columns.Length; i++) { ColumnCell = columns[i].ColumnCell; padding = columns[i].HeaderColumnPadding; strTableRow += @"<TablixCell> <CellContents> " + GenerateHeaderTableTextBox("txtHeader_" + table.ReportName + "_", ColumnCell.Name, columns[i].HeaderText == null || columns[i].HeaderText.Trim() == "" ? ColumnCell.Name : columns[i].HeaderText, false, padding) + @" </CellContents> </TablixCell>"; } strTableRow += @"</TablixCells></TablixRow>"; return(strTableRow); }
static string GetSortingDetails(ReportBuilder reportBuilder) { return(""); ReportTable[] tables = reportBuilder.Body.ReportControlItems.ReportTable; ReportColumns[] columns = reportBuilder.Body.ReportControlItems.ReportTable[0].ReportDataColumns; ReportTextBoxControl sortColumn = new ReportTextBoxControl(); if (columns == null) { return(""); } string strSorting = ""; strSorting = @" <SortExpressions>"; for (int i = 0; i < columns.Length; i++) { sortColumn = columns[i].ColumnCell; strSorting += "<SortExpression><Value>=Fields!" + sortColumn.Name + @".Value</Value>"; if (columns[i].SortDirection == ReportSort.Descending) { strSorting += "<Direction>Descending</Direction>"; } strSorting += @"</SortExpression>"; } strSorting += "</SortExpressions>"; return(strSorting); }
static string GenerateTableRow(ReportBuilder reportBuilder, ReportTable table) { ReportColumns[] columns = table.ReportDataColumns; ReportTextBoxControl ColumnCell = new ReportTextBoxControl(); ReportScale colHeight = ColumnCell.Size; ReportDimensions padding = new ReportDimensions(); if (columns == null) { return(""); } string strTableRow = ""; strTableRow = @"<TablixRow> <Height>0.6cm</Height> <TablixCells>"; for (int i = 0; i < columns.Length; i++) { ColumnCell = columns[i].ColumnCell; padding = ColumnCell.Padding; strTableRow += @"<TablixCell> <CellContents> " + GenerateTextBox("txtCell_" + table.ReportName + "_", ColumnCell.Name, "", true, padding) + @" </CellContents> </TablixCell>"; } strTableRow += @"</TablixCells></TablixRow>"; return(strTableRow); }
public void DataBind(DataSet ds) { int count = 0; foreach (DataTable dt in ds.Tables) { count++; var report_name = "Report" + count; DataTable dt1 = new DataTable(report_name.ToString()); dt1 = ds.Tables[count - 1]; dt1.TableName = report_name.ToString(); } ReportViewerMaster.Reset(); for (int i = 0; i < ds.Tables.Count; i++) { ReportViewerMaster.LocalReport.DataSources.Add(new ReportDataSource(ds.Tables[i].TableName, ds.Tables[i])); } ReportViewerMaster.LocalReport.EnableHyperlinks = true; ReportBuilder reportBuilder = new ReportBuilder(); reportBuilder.DataSource = ds; reportBuilder.Page = new ReportPage(); ReportSections reportFooter = new ReportSections(); ReportItems reportFooterItems = new ReportItems(); ReportTextBoxControl[] footerTxt = new ReportTextBoxControl[3]; //string footer = string.Format("Copyright {0} Report Generated On {1} Page {2}", DateTime.Now.Year, DateTime.Now, ReportGlobalParameters.CurrentPageNumber); string footer = string.Format("Copyright {0} Report Generated On {1} Page {2} of {3} ", DateTime.Now.Year, DateTime.Now, ReportGlobalParameters.CurrentPageNumber, ReportGlobalParameters.TotalPages); footerTxt[0] = new ReportTextBoxControl() { Name = "txtCopyright", ValueOrExpression = new string[] { footer } }; reportFooterItems.TextBoxControls = footerTxt; reportFooter.ReportControlItems = reportFooterItems; reportBuilder.Page.ReportFooter = reportFooter; ReportSections reportHeader = new ReportSections(); reportHeader.Size = new ReportScale(); // reportHeader.Size.Height = 0.56849; reportHeader.Size.Height = 0.7; ReportItems reportHeaderItems = new ReportItems(); ReportTextBoxControl[] headerTxt = new ReportTextBoxControl[1]; headerTxt[0] = new ReportTextBoxControl() { Name = "txtReportTitle", ValueOrExpression = new string[] { ReportTitle } }; reportHeaderItems.TextBoxControls = headerTxt; reportHeader.ReportControlItems = reportHeaderItems; reportBuilder.Page.ReportHeader = reportHeader; ReportViewerMaster.LocalReport.LoadReportDefinition(ReportEngine.GenerateReport(reportBuilder)); ReportViewerMaster.LocalReport.DisplayName = ReportName; ReportViewerMaster.LocalReport.EnableHyperlinks = true; }