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>
<
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 = instanceReportSource
End
If
public
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();
}
}