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);
}