Hi,
I have a crosstab and would like to hide a Row Group depending on a Parameter value. I need to hide the complete Row, is this possible? And second I have the same problem with a column, depending on a parameter value I would like to collapse a column. I’ve tried setting the visibility’s which works everywhere on the report except in the crosstab. Can this be accomplished with a crosstab?
Thank you very much.
Wayne
string
reportPath = Server.MapPath(
"./reports"
) + @
"\reportClients.trdx"
;
using
(System.Xml.XmlReader xmlReader = System.Xml.XmlReader.Create(reportPath))
{
System.Xml.Serialization.XmlSerializer xmlSerializer =
new
System.Xml.Serialization.XmlSerializer(
typeof
(Telerik.Reporting.Report));
Telerik.Reporting.Report clientReport = (Telerik.Reporting.Report)xmlSerializer.Deserialize(xmlReader);
Report report =
new
Report();
clientReport.DataSource = report.GetClientReportData(businessTypeID, siteID);
uxClientReport.Report = clientReport;
uxClientReport.RefreshReport();
}
System.Xml.XmlReaderSettings settings =
new
System.Xml.XmlReaderSettings();
settings.IgnoreWhitespace =
true
;
using
(System.Xml.XmlReader xmlReader = System.Xml.XmlReader.Create(reportPath, settings))
{
Telerik.Reporting.XmlSerialization.ReportXmlSerializer xmlSerializer =
new
Telerik.Reporting.XmlSerialization.ReportXmlSerializer();
Telerik.Reporting.Report clientReport = (Telerik.Reporting.Report)xmlSerializer.Deserialize(xmlReader);
Report report =
new
Report();
clientReport.DataSource = report.GetClientReportData(businessTypeID, siteID);
uxClientReport.ReportSource = clientReport;
uxClientReport.RefreshReport();
}
string fileName = @"D:\text\jccantera\jccantera\jcc.xml";
var reader = new StreamReader(fileName);
XmlSerializer serializer = new XmlSerializer(typeof(NewDataSet));
var report = (NewDataSet)serializer.Deserialize(reader);
Telerik.Reporting.Processing.
Chart procChart = (Telerik.Reporting.Processing.Chart)sender;
DataSet ds = report;
procChart.DataSource = ds.Tables[
"BillItemLine"];
ChartSeries series = new ChartSeries();
series.Appearance.LegendDisplayMode = Telerik.Reporting.Charting.ChartSeriesLegendDisplayMode.ItemLabels;
series.DataYColumn =
"ItemLineAmount";
series.Appearance.ShowLabelConnectors =
true;
series.DefaultLabelValue =
"#%";
series.Appearance.LabelAppearance.Distance =10;
series.Appearance.LabelAppearance.LabelConnectorStyle.Color = System.Drawing.
Color.CadetBlue;
series.Appearance.TextAppearance.TextProperties.Color = System.Drawing.
Color.Brown;
JCChart.Legend.Add(d);
JCChart.Series.Add(series);
procChart.DataSource = ds.Tables["BillItemLine"].DefaultView;
JCChart.DefaultType = Telerik.Reporting.Charting.
ChartSeriesType.Pie;