Telerik Forums
Reporting Forum
3 answers
458 views

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

Steve
Telerik team
 answered on 19 Jun 2012
0 answers
109 views
Hi

I have created my project using the Q1 Trial API's, but now that I have bought the Q2 2012 license, some of the code is not working.

EDIT: I have got it working, two things, you need to switch to the Telerik ReportXMLSerializer and use a IgnoreWhitespace setting in the XMLReader.

Example, before in Q1 2012:
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();
}
using the Telerik ReportXMLSerializer in Q2
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();
}

Jako
Top achievements
Rank 1
 asked on 19 Jun 2012
5 answers
261 views
hello,

I already passed using report but the template uses labels instead of tables.
I want to use tables in my report.

when i drop tables in design view but the table wizard don't fire.

i don't know why?

thanks for your help
PICKUP
Top achievements
Rank 2
 answered on 19 Jun 2012
1 answer
113 views
I have a subreport in my details section of my report and i am trying to hide the subreport when it does not contain any data 

Telerik.Reporting.Processing.SubReport subReport = (Telerik.Reporting.Processing.SubReport)sender;
            Telerik.Reporting.Processing.Report report = (Telerik.Reporting.Processing.Report)subReport.InnerReport;
            subReport.Visible = subReport.ChildElements.Find("detail", true).Length > 0;

But the above code just hides the subreport and the space occupied by it still persists and there is that gap between my main report rows.....How can i get the space removed  when the subreport is not showing up?
Steve
Telerik team
 answered on 19 Jun 2012
6 answers
247 views
hi!
      I have write below code in chart need datasource event for displaying pie chart..In pie chart I have get the data from xml...In pie chart each legend items  labels present in the format of item1, item2,item3...but I want description column  from xml as a label of each legend item...And also I want exploded a single slice from pie chart....can anyone help me? thanks....


 

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;

 

Branden
Top achievements
Rank 1
 answered on 18 Jun 2012
1 answer
58 views
Thanks  a  lot...

I   have  copyed   the    connection   string   from    the    "Report Project"    to    "WebSiteProject . The   code  as  following:

Web.Config:
   
     <connectionStrings>
    <add name="ReportingList.Properties.Settings.AdventureWorks"
            connectionString="Data Source=STARRYCHENG-PC\STARRYCHENG;Initial Catalog=AdventureWorks;User ID=sa;Password=123456"
            providerName="System.Data.SqlClient" />
  </connectionStrings>


App.Config:
 
<connectionStrings>
        <add name="ReportingList.Properties.Settings.AdventureWorks"
            connectionString="Data Source=STARRYCHENG-PC\STARRYCHENG;Initial Catalog=AdventureWorks;User ID=sa;Password=123456"
            providerName="System.Data.SqlClient" />
    </connectionStrings>

Question:
        Preview   in   the   "Report Project"    is  ok...

        
   
        Reporting  in  the   website  occurs  error...    
IvanY
Telerik team
 answered on 18 Jun 2012
1 answer
71 views
Hi.
I'm using the Report Service with SL.    How can Return specific reports to a combox.
I have STANDARD and ADHOC reports.   For one combo I want get the STANDARD for the other ADHOC.
Any ideas?
thanks in advance
Steve
Telerik team
 answered on 18 Jun 2012
1 answer
106 views
Hi,
VS 2010 show me this error when I insert telerik:ReportViewer control.

Errore 1 [Parser_SetValue_Exception]
Argomenti: 
Le stringhe di risorse per il debug non sono disponibili. Spesso la chiave e gli argomenti forniscono informazioni sufficienti alla diagnosi del problema. Vedere http://go.microsoft.com/fwlink/?linkid=106663&Version=4.1.10329.0&File=System.Windows.dll&Key=Parser_SetValue_Exception [Line: 515 Position: 93] C:\Sorgenti\TEST\ReportOlap\SilverlightApplication1\MainPage.xaml 11 9 SilverlightApplication1


  • Telerik.ReportViewer.Silverlight (6.1.12.611)
  • Telerik.Windows.Controls (2011.3.1116.1040)
  • Telerik.Windows.Controls.Input (2011.3.1116.1040) 
  • Telerik.Windows.Controls.Navigation (2011.3.1116.1040) 
  • System.Windows.Controls (2.0.5.0)
Steve
Telerik team
 answered on 18 Jun 2012
3 answers
177 views
Hello, im using Telerik Reporting Q2 2011 version and i can't find any information how to display telerik reporting books in mvc3 application. Would like to load reports dynamically in controller action or something. Thanks indeed for any help or code samples or links. Regards
IvanY
Telerik team
 answered on 18 Jun 2012
1 answer
409 views
I am having a report  along with a sub report for each row.....
The sub report basically increases the  height of each row and hence i would like to get the the column header of the table  repeated for each  row.
I have created the table  using the table wizard..

How can i achieve this...Thank you
Elian
Telerik team
 answered on 18 Jun 2012
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?