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).
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
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
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
<
add verb="*" path="Telerik.ReportViewer.axd" type = "Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=x.x.x.xxx, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" />
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 |
<?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> |
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.
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.
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?