I want the sql query in the sqldatasource of my report to be executed in two different ways

if (parameter =1)
{

}

else
{

}

How can i do this programmatically....ThankYou in advance

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

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:
using the Telerik ReportXMLSerializer in Q2

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

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?

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;

 

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...    

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

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

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