Telerik Forums
Reporting Forum
2 answers
45 views

SL Q2 2014 Reporting, VS2010, VB.net

 newbie chart question

I've created many table style charts and now I am trying to create a simple pie chart.  I have a class that is used by an ObjectDataSource to provide report data that I copied form another report, it returns a list of objects.  Using the chart report wizard I get to the point where I create the datasource and I select my class but the wizard does not allow me to select it so the only option is to cancel the wizard.  I'm thinking this is because the data class I selected does not return whatever the pie chart is looking for...what type of data do I need my data class to return to be used is a report chart? (assuming that is the problem).

Nasko
Telerik team
 answered on 29 Apr 2015
2 answers
453 views

Hi,

I am using Q2 2014 SP1 of Telerik Reporting.  My report contains a single Graph in the detail section, but my datasource contains alot of items that will be graphed (so I'll get one of my graphs for every item in the data source I'm binding it to).  Each of the graphs that are created, may have wildly different values.

In the cases where the values of a single graph are both very small and very large, I will want to set the Y-Axis Scale to "Logarithmic".  But the challenge is that I'll need to do that at run-time since I can't set that property in the designer (since most of the time it will be a Numeric Scale, not Logarithmic).

It doesn't seem like any of the events (ItemDataBinding, ItemDataBound, or NeedDataSource) can be used to help me do this?

So, can I change the Graph's Y-Axis Scale anywhere in the report's code behind?

Thanks,
Brent

Ivan Hristov
Telerik team
 answered on 29 Apr 2015
2 answers
1.1K+ views
I am trying to print directly to a printer using the code listed here. However I need to pass parameters to my report. Is there a way to do that when trying to print directly?
Jonah
Top achievements
Rank 1
 answered on 28 Apr 2015
4 answers
1.0K+ views

Hi,

When I export a Telerik Reporting table to CSV the column header are rendered left beside each detail field. That is not very useful for me.

Telerik Demo Product Sales per Period exported to CSV:

textBox1,textBox5,textBox6,textBox3,textBoxCategory,textBox9,textBox2,textBoxYear,textBoxFact,textBoxGrandTotalYearLabel,textBoxGrandTotalSubCategoryYear,textBoxGrandTotalCategoryLabel,textBoxGrandTotalCategoryQtr,textBoxGrandTotal
Sales by Product Line per Period,,,(USD IN THOUSANDS),Accessories,,,2001,20.2,GRAND TOTAL,"1,272.1",GRAND TOTAL,"11,331.8","109,846.4"
Sales by Product Line per Period,,,(USD IN THOUSANDS),Accessories,,,2002,92.7,GRAND TOTAL,"1,272.1",GRAND TOTAL,"30,674.8","109,846.4"
Sales by Product Line per Period,,,(USD IN THOUSANDS),Accessories,,,2003,590.3,GRAND TOTAL,"1,272.1",GRAND TOTAL,"42,011.0","109,846.4"
Sales by Product Line per Period,,,(USD IN THOUSANDS),Accessories,,,2004,568.8,GRAND TOTAL,"1,272.1",GRAND TOTAL,"25,828.8","109,846.4"
Sales by Product Line per Period,,,(USD IN THOUSANDS),Bikes,,,2001,"10,661.7",GRAND TOTAL,"94,651.2",GRAND TOTAL,"11,331.8","109,846.4"
Sales by Product Line per Period,,,(USD IN THOUSANDS),Bikes,,,2002,"26,486.4",GRAND TOTAL,"94,651.2",GRAND TOTAL,"30,674.8","109,846.4"
Sales by Product Line per Period,,,(USD IN THOUSANDS),Bikes,,,2003,"34,923.3",GRAND TOTAL,"94,651.2",GRAND TOTAL,"42,011.0","109,846.4"
Sales by Product Line per Period,,,(USD IN THOUSANDS),Bikes,,,2004,"22,579.8",GRAND TOTAL,"94,651.2",GRAND TOTAL,"25,828.8","109,846.4"
Sales by Product Line per Period,,,(USD IN THOUSANDS),Clothing,,,2001,34.4,GRAND TOTAL,"2,120.5",GRAND TOTAL,"11,331.8","109,846.4"
Sales by Product Line per Period,,,(USD IN THOUSANDS),Clothing,,,2002,485.6,GRAND TOTAL,"2,120.5",GRAND TOTAL,"30,674.8","109,846.4"
Sales by Product Line per Period,,,(USD IN THOUSANDS),Clothing,,,2003,"1,012.0",GRAND TOTAL,"2,120.5",GRAND TOTAL,"42,011.0","109,846.4"
Sales by Product Line per Period,,,(USD IN THOUSANDS),Clothing,,,2004,588.6,GRAND TOTAL,"2,120.5",GRAND TOTAL,"25,828.8","109,846.4"
Sales by Product Line per Period,,,(USD IN THOUSANDS),Components,,,2001,615.5,GRAND TOTAL,"11,802.6",GRAND TOTAL,"11,331.8","109,846.4"
Sales by Product Line per Period,,,(USD IN THOUSANDS),Components,,,2002,"3,610.1",GRAND TOTAL,"11,802.6",GRAND TOTAL,"30,674.8","109,846.4"
Sales by Product Line per Period,,,(USD IN THOUSANDS),Components,,,2003,"5,485.5",GRAND TOTAL,"11,802.6",GRAND TOTAL,"42,011.0","109,846.4"
Sales by Product Line per Period,,,(USD IN THOUSANDS),Components,,,2004,"2,091.5",GRAND TOTAL,"11,802.6",GRAND TOTAL,"25,828.8","109,846.4"

 

Telerik demo exported to Excel, then in Excel saved as CSV:

Sales by Product Line per Period;;;;;;
;;;;;;
;;;;;;
(USD IN THOUSANDS);2001;2002;2003;2004;;GRAND TOTAL
Accessories;20.2;92.7;590.3;568.8;;1,272.1
Bikes;10,661.7;26,486.4;34,923.3;22,579.8;;94,651.2
Clothing;34.4;485.6;1,012.0;588.6;;2,120.5
Components;615.5;3,610.1;5,485.5;2,091.5;;11,802.6
GRAND TOTAL;11,331.8;30,674.8;42,011.0;25,828.8;;109,846.4

 

Is there a chance to get a CSV file from Telerik reporting in the way that Excel exports?

Regards,

Rayko

Stef
Telerik team
 answered on 28 Apr 2015
1 answer
113 views

I'm testing your Telerik Reporting for one of my customers.

Telerik Reporting is just wonderful. 
I have some problem with the maps "Shapefile" 
For a reason I do not understand the shape files are not displayed correctly.

 Shapefiles are these you can download from Istat (Italian government institution)

Practically only appears the legend and the map is completely invisible The same shapefile work fine with SQL Server Reporting Services.

These shapefiles are in ED50 format

Is this format compatible with your telerik reporting map control?

Many thx in advance for your time spent here.

I attach zip file of shapefile

 

 

Ivan Hristov
Telerik team
 answered on 28 Apr 2015
13 answers
183 views
Hi

I'm new to Telerik.Reporting.
I installed the package and made a report with data from a db using DataSet, and DataSetTableAdapter.
Btw: Environment: Web-Application (Ajax enabled), Master- and Content-Pages.

The first calling of the page ended with an error: something is missing in web.config:

<

 

add verb="*" path="Telerik.ReportViewer.axd" type = "Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=x.x.x.xxx, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" />

 


So I added this one line into the web.config (changed "Version" to: 3.0.9.430) and the report showed up. Even the passed parameter for the SQL-Query worked. (ContentPage: ReportViewer -> ReportLibrary: Report -> TableAdapter.fill(DataSetTable, ParameterValue)

Now the bad thing:
Just below the output of the correctly generated report (even the footer and the pagenumbers are displayed) appears always this error message:

Serverfehler in der Anwendung /.  
--------------------------------------------------------------------------------  
 
Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.   
Beschreibung: Unbehandelte Ausnahme beim Ausführen der aktuellen Webanforderung. Ãœberprüfen Sie die Stapelüberwachung, um weitere Informationen Ã¼ber diesen Fehler anzuzeigen und festzustellen, wo der Fehler im Code verursacht wurde.   
 
Ausnahmedetails: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.  
 
Quellfehler:   
 
Beim Ausführen der aktuellen Webanforderung wurde einen unbehandelte Ausnahme generiert. Informationen Ã¼ber den Ursprung und die Position der Ausnahme können mit der Ausnahmestapelüberwachung angezeigt werden.    
 
Stapelüberwachung:   
 
[NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.]  
   áœ£.ᜀ(HttpResponse A_0) +193  
   áœ£.ᜂ(Object A_0, EventArgs A_1) +550  
   System.EventHandler.Invoke(Object sender, EventArgs e) +0  
   System.Web.HttpApplication.RaiseOnPreSendRequestHeaders() +8804047 
I don't have any code that's been executed after the display of the report. 

My guess is, something else is missing in the web.config file.
These are the entries in the web.config I found for "Reporting" (and the whole httpHandlers Section):

<?xml version="1.0"?>  
<configuration> 
    ...  
    <system.web> 
        ...  
        <compilation defaultLanguage="c#" debug="true">  
            <assemblies> 
                ...  
                <add assembly="Telerik.ReportViewer.WebForms, Version=3.0.9.430, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>  
                <add assembly="Telerik.Reporting.Processing, Version=3.0.9.430, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>  
                <add assembly="Telerik.Reporting, Version=3.0.9.430, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>  
                <add assembly="Telerik.Reporting.Interfaces, Version=3.0.9.430, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>  
                <add assembly="Telerik.Reporting.Design, Version=3.0.9.430, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>  
                <add assembly="Telerik.Reporting.HtmlEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>  
                <add assembly="Telerik.ReportViewer.Design, Version=3.0.9.430, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/></assemblies> 
                ...  
        </compilation> 
        ...  
        <httpHandlers> 
            <remove verb="*" path="*.asmx"/>  
            <add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>  
            <add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>  
            <add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false"/>  
            <add verb="*" path="Telerik.ReportViewer.axd" type = "Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=3.0.9.430, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" /> 
            <add path="Telerik.Web.UI.WebResource.axd" type="Telerik.Web.UI.WebResource, Telerik.Web.UI, Culture=neutral, PublicKeyToken=121fae78165ba3d4" verb="*" validate="false"/>  
            <add path="Telerik.RadUploadProgressHandler.ashx" verb="*" type="Telerik.Web.UI.RadUploadProgressHandler, Telerik.Web.UI"/>  
            <add path="ChartImage.axd" type="Telerik.Web.UI.ChartHttpHandler" verb="*" validate="false"/>  
        </httpHandlers> 
        ...  
    </system.web> 
    ...  
</configuration> 
 

Does anyone have a clue or a good guess?

TIA
Markus
Fridli Jacober
Top achievements
Rank 1
 answered on 27 Apr 2015
1 answer
57 views

I have a stored procedure that return a recordset of html rows, such as the following: 

row1: <tr class='cr38ReportHeader'><th>WBS</th>
row2: <th align='center' colspan='1'>ABC<br/>XYZ<br/>07/01/12 - 12/31/12<br/>183</th>
row3: <th align='center' colspan='1'>ABC<br/>XYZ<br/>07/01/12 - 12/31/12<br/>183</th>
row4: <th align='center' colspan='1'>ABC<br/>XYZ<br/>07/01/12 - 12/31/12<br/>183</th>
...etc

So each row in the recordset holds some HTML. I'm wonder what is the best was to present this in a Telerik report. 

I've currently tried to concatenate all rows into a string set the value of an htmltextbox to concatenated string. This did not work. 

Any ideas?

Thanks.

Stef
Telerik team
 answered on 27 Apr 2015
3 answers
134 views

I'm trying to create a delimited string of values from the values selected via report multi-select parameter. How can I conduct a user function on a multi-select parameter, like the following:

Telerik.Reporting.Processing.Report rpt = (Telerik.Reporting.Processing.Report)sender;
string ids = Join(",", rpt.Parameters["IDs"].Value)

This does not work in the ItemDataBinding event handler. 

Thanks.

Stef
Telerik team
 answered on 27 Apr 2015
3 answers
47 views
I create a main report, created four sub report in the main report statements. In 2015 Q1 version can work normally, but in the 2015 Q1 SP1 version, the four sub report run-time anomalies, four sub report no longer use since the data sources, using only the first child report data sources. Due to the rest of the three sub report data showed abnormal.
Stef
Telerik team
 answered on 27 Apr 2015
5 answers
230 views

1)Create a .trdx file that requires one or more parameters / report won't run without specifying a parameter

2) Load that trdx file into the CSharp.MvcDemo sample that ships with Telerik Reporting

 3) You get a clunky error message:

Error creating report instance (Report = XXX.trdx):
Missing or invalid parameter value. Please input valid data for all parameters

4) You input the report parameters

5) The user thinks the preview button will make the report refresh, but it does not.  You have to hit the circle refresh button on the upper left to actually get the report.

Item 5. This seems like there has to be something gone awry here.  The preview button does not seem to actually do anything.  The clunky error message in item 3 seems bizarre as well.  How do I change that to something more sane?

Seems like I have to be missing something.  Seems like a straight forward use case to have people input report parameters before running the report.  Can I get some feedback / help?

Stef
Telerik team
 answered on 27 Apr 2015
Top users last month
Anislav
Top achievements
Rank 6
Silver
Bronze
Bronze
Jianxian
Top achievements
Rank 1
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Jim
Top achievements
Rank 2
Iron
Iron
Nurik
Top achievements
Rank 2
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?