[DataObjectMethod(DataObjectMethodType.Select)] public ReportOrderDetail GetReportOrderDetail(){.....Right now I have a working report with the data source set to a user object. However I would like to show this report multiple times inside one report with the datasource set to a dynamic collection of user objects. What would be the best solution for this?
Thanks
Chris
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>