private void textBox1_ItemDataBound(object sender, EventArgs e){ Telerik.Reporting.Processing.TextBox textBox = (Telerik.Reporting.Processing.TextBox)sender; Telerik.Reporting.Processing.Report report = textBox.Report; Telerik.Reporting.Processing.DetailSection detailSection = Telerik.Reporting.Processing.DetailSection)Telerik.Reporting.Processing.ElementTreeHelper.GetChildByName(report, "detail"); Telerik.Reporting.Processing.SubReport subReportFuel = (Telerik.Reporting.Processing.SubReport)Telerik.Reporting.Processing.ElementTreeHelper.GetChildByName(detailSection, "subReportFuel"); Telerik.Reporting.Processing.TextBox subReportTextboxFuelVolume = (Telerik.Reporting.Processing.TextBox)Telerik.Reporting.Processing.ElementTreeHelper.GetChildByName(subReportFuel, "volumeSumFunctionTextBox"); textBox.Value = subReportTextboxFuelVolume.Value;}54001 C C C C
52768 C NC C N/A
Reach (Y-82) NC due to 431-145-2 Purchased from Futuristics Components Inc (Supplier #191100) non-compliant
101-4030 C C C C
3190-278 C C C C
RoHS NC Purchased from Santron Inc (Supplier #XXXXX) non-compliant
101-0032 C C C C
Please notice the 2 red detail lines. Can I achieve this with crosstab ? If so, how? I think I'm stuck with crosstab because the last 4 columns are dynamic and I need crosstab's column group feature to display them.
foreach (string filter in _rptFilters) { Telerik.Reporting.Filter newfilter = new Telerik.Reporting.Filter(); newfilter.Expression = "= StringToUpper(Fields." + filter + ")" ; newfilter.Operator = Telerik.Reporting.FilterOperator.Equal; newfilter.Value = filter.Substring(filter.IndexOf("_") + 1).ToUpper(); table1.Filters.Add(newfilter); }