or
We need to set the group header and group footer as per the attached image.
We are having a 4 list objects (Q1 Sales Region,Q2 Sales Region...) inside the group section, there we are able to filter the records based on the group header information (EmployeeName) but not able to set the height of the group header section.If we specify the height as per the attached image and tried to generate report in PDF, the data is exported but with extra blank pages.
We tried with "tables,panels,Group header along with detail section" but nothing has worked out. Kindly please provide the solution as early as possible.
Regards
Sankar
for (DateTime date = startDate.AddDays(-1); date <= endDate ; date = date.AddDays(1)) { TableGroup tableGroupColumn = new TableGroup(); tblOccupancy.ColumnGroups.Add(tableGroupColumn); tblOccupancy.Body.Columns.Add(new TableBodyColumn(Unit.Inch(0.01))); Telerik.Reporting.TextBox textBoxGroup = new Telerik.Reporting.TextBox(); if (i == 1) { textBoxGroup.Value = "Medewerker"; textBoxGroup.Size = new SizeU(Unit.Inch(2), Unit.Inch(0.3)); } else { textBoxGroup.Value = date.ToString("ddd dd-MM"); textBoxGroup.Size = new SizeU(Unit.Inch(0.7), Unit.Inch(0.3)); } textBoxGroup.Style.BackgroundColor = Color.FromArgb(220, 231, 245); textBoxGroup.Style.Font.Bold = true; textBoxGroup.Style.VerticalAlign = VerticalAlign.Middle; textBoxGroup.Style.BorderColor.Default = Color.FromArgb(27, 149, 203); textBoxGroup.Style.BorderStyle.Default = BorderType.Solid; tableGroupColumn.ReportItem = textBoxGroup; Telerik.Reporting.TextBox textBoxTable = new Telerik.Reporting.TextBox(); if (i == 1) { textBoxTable.Value = "=Fields.EmployeeName"; } else { textBoxTable.ItemDataBinding += new EventHandler(textBoxTable_ItemDataBinding); if (date.DayOfWeek == DayOfWeek.Saturday || date.DayOfWeek == DayOfWeek.Sunday) { textBoxTable.Style.BackgroundColor = Color.FromArgb(255, 194, 194, 194); } textBoxTable.Name = i - 1 + ""; textBoxTable.Value = "a" + i;// "=Anton.Server.Reports.ReportGenerator.GetValueFromDictionaryById(Fields.ValueForDay," + (i - 1) + ")"; } textBoxTable.Style.BorderColor.Default = Color.FromArgb(27, 149, 203); textBoxTable.Style.BorderStyle.Default = BorderType.Solid; textBoxTable.Style.BorderWidth.Default = new Unit(0.5, UnitType.Point); textBoxTable.Style.VerticalAlign = VerticalAlign.Middle; textBoxTable.Size = new SizeU(Unit.Inch(0.01), Unit.Inch(0.2)); tblOccupancy.Body.SetCellContent(0, i - 1, textBoxTable); tblOccupancy.Items.AddRange(new ReportItemBase[] { textBoxTable, textBoxGroup }); i++; }<Telerik.Reporting> <Cache provider="File"> <Providers> <Provider name="File"> <Parameters> <Parameter name="BasePath" value="C:\MyDataCache" /> </Parameters> </Provider> </Providers> </Cache> </Telerik.Reporting>
<div style="text-align: center; min-height: 300px; margin-top:5px;"> <telerik:ReportViewer ID="ReportViewer" runat="server" Width="100%" Height="850" /></div>If currentReport IsNot Nothing Then Dim instanceReportSource As New Telerik.Reporting.InstanceReportSource() instanceReportSource.ReportDocument = currentReport ReportViewer.ReportSource = instanceReportSourceEnd Ifpublic partial class RiskDashboard : Telerik.Reporting.Report {public RiskDashboard() { // Required for telerik Reporting designer support // System.Threading.Thread.CurrentThread.CurrentUICulture = new CultureInfo("fr-CA"); System.Threading.Thread.CurrentThread.CurrentCulture = new CultureInfo("fr-CA"); InitializeComponent(); } }