Telerik Forums
Reporting Forum
1 answer
95 views
I would glad if there is someone can make a video teaching us how to use sqldatasource in report chart and supporting parameters. It is too difficult for me to use dataset in 2009.
Peter
Telerik team
 answered on 18 Mar 2010
1 answer
146 views
Hi,

I am trying to get a pie chart to work similar to your sales dashboard demo. 
I am using the following sql:
"SELECT SUM(Value) AS [Sum], C.Name FROM (Category AS C INNER JOIN Subcategory AS SC ON C.Id=SC.Category_id) INNER JOIN [Data] AS D ON SC.ID=D.SubCategory_Id WHERE [Year]=@Year GROUP BY C.ID, C.Name ORDER BY C.ID"

For the series property I am using name as the DataLablesColumn and sum as the DataYColumn

However, when i run the report I see the name in both the legend as well as the pie chart section. What property do i need to set to see the sum on the chart and the name on the legend.

Also do you have a video of the pie chart design? The one on telerik tv is for bar charts and I see that pie charts are quite different in implemetation.

Thanks
Chavdar
Telerik team
 answered on 18 Mar 2010
2 answers
121 views
I have a report with a sub report on it. In order to set the data source of the sub report I use the SubReport_ItemDataBinding event as shown below.

 

private void SummarySubReport_ItemDataBinding(object sender, EventArgs e)

 

{

 

DataView dv = new DataView(m_data, "LetterBatchId = 491",

 

 

null, DataViewRowState.CurrentRows);

 

Telerik.Reporting.Processing.

SubReport subReport = (Telerik.Reporting.Processing.SubReport)sender;

 

subReport.InnerReport.DataSource = dv;

}

After updating to 2010 Q1 the innerReport of the subReport is null.
Why has this changed and how can I get this working again?

Steve
Telerik team
 answered on 18 Mar 2010
1 answer
89 views
I am doing reporting using a business object. The business object has sub-collections that I want to include in the report.

I used to do this to get to the raw data:

 

Private Sub Table1_NeedDataSource(ByVal sender As ObjectByVal e As System.EventArgs) Handles Table1.NeedDataSource  
    Dim tab1 As Telerik.Reporting.Processing.Table = DirectCast(sender, Telerik.Reporting.Processing.Table)  
    Dim idata1 As Telerik.Reporting.Processing.IDataObject = DirectCast(tab1.DataObject, Telerik.Reporting.Processing.IDataObject)  
    Dim obj1 As myobject = DirectCast(idata1.RawData, myobject)  
    '  
    tab1.DataSource = obj1  
End Sub 
 

 

 

 


This no longer works in Telerik Reporting 2010 Q1. What the best way to get to the raw data object?

Brad

UPDATE:  Looks like this is already reported as issue 1318 and I see a workaround another post on this same issue. I will try the workaround until there is a better method.

Steve
Telerik team
 answered on 18 Mar 2010
0 answers
112 views
step by step, your video cant watch
shane
Top achievements
Rank 1
 asked on 18 Mar 2010
2 answers
143 views
Hi,

I'm trying to configure Telerik Reporting to make the preview able to get datasource from WCF Webservice. In runtime mode, it works well, but in design mode it tells me that the endpoint is not found. I think the configuration file is not found and tried to copy it into some bin folders but nothing works. Here is my project organization :

-1) a Web project that launches the silverlight app
-2) a Silverlight application project that hosts a Silvelright Report Viewer
-3) a WCF Webservice project that gives the possibility to grab datas from the DB.
-4) a standard class library project that contains my reports

My reports make calls to webservice through WCF but the preview doesn't work.

Where do I have to copy a configuration file to make it works ? and how do I have to name it please ?
In fact, what I would like to know is : when you click preview in the report designer, in which folder is run the preview rendering ? 

Thanks, 

Regards
Steeve

LE DREAU Steeve
Top achievements
Rank 1
 answered on 17 Mar 2010
2 answers
80 views
Hi,

My client has to set his label sizes at runtime. I've made all the code to make this works, but I was wondering if I could get the same list of layouts as the reporting wizard to present it to my client and then initialize all values I need to create the report.
It would be a great functionality to avoid the user to write all values if he uses a standard labels layout and would make him free to modify or write all values if he uses a non standard one.
Is there any way to get the two lists presented in the wizard (constructor like AVERY and models like L7160) and then get their layout values ?

Thanks

Regards
Steeve
LE DREAU Steeve
Top achievements
Rank 1
 answered on 17 Mar 2010
1 answer
151 views
HI,

Im new to the Report Viewer control but very interested in implementing into our Silverlight Application. I have followed the Video tutorial and looked through the example project on how to create and view a simple report, however im getting the following error:

'Could not load type 'TenantsDetails' from Assembly 'Telerik.Reporting.Service' version=4.0.10.310, Culture = Neutral, PublicKeyToken=a9d798dfcc261be'

I have scoured your forums but there is no clear solution. I have made sure im using all the correct refereneces, have the latest versions of Reporting and RadControls and i cannot for the life of me figure out whats going wrong.

Here is my code to my report viewer

<controls:ChildWindow x:Class="ColonySL.ReportViewer" 
           xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"   
           xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"   
           xmlns:controls="clr-namespace:System.Windows.Controls;assembly=System.Windows.Controls" 
           xmlns:telerik="clr-namespace:Telerik.ReportViewer.Silverlight;assembly=Telerik.ReportViewer.Silverlight"               
           xmlns:telerikNav="clr-namespace:Telerik.Windows.Controls;assembly=Telerik.Windows.Controls.Navigation" 
           xmlns:telerikControls="clr-namespace:Telerik.Windows.Controls;assembly=Telerik.Windows.Controls" 
           xmlns:telerikPrimitives="clr-namespace:Telerik.Windows.Controls.Primitives;assembly=Telerik.Windows.Controls" 
           xmlns:telerikInput="clr-namespace:Telerik.Windows.Controls;assembly=Telerik.Windows.Controls.Input"     
           Width="1024" Height="700" 
           Title="ReportViewer">  
    <Canvas Name="Main">  
        <telerik:ReportViewer Grid.Row="1" x:Name="ReportViewer1"   
                                  Width="1008" 
                                  Height="660" 
                                  ReportServiceUri="../ReportService.svc" 
                                  Report="TenantsDetails"/>  
 
    </Canvas> 
</controls:ChildWindow> 

and attached is a snap shot of how my project looks.

I would be grateful if you could get back to me asap as we are very interested in getting this working with our project and would like to purchase if we can get this working.

Thanks,

Steve
Telerik team
 answered on 17 Mar 2010
0 answers
162 views
dear all

I made showexportgroup to true but still it is disable..i want to export report in different file format like pdf,excel etc.....
waiting for answere..........
Azeheruddin khan
Top achievements
Rank 1
 asked on 17 Mar 2010
1 answer
68 views
Hello,

I have a report that works find in PDF/report viewer, but when I export to RTF the detail section is all black background, along with the text being black..  I have looked at everything and there is nothing special I'm doing with the section or the textboxes on it...  Using reporting Q32009

Any idea what I can do to fix this?

Thanks

Matt

Steve
Telerik team
 answered on 17 Mar 2010
Top users last month
Edmond
Top achievements
Rank 1
Iron
fabrizio
Top achievements
Rank 2
Iron
Veteran
RobMarz
Top achievements
Rank 2
Iron
Fakhrul
Top achievements
Rank 1
Iron
Tejas
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?