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?
I've tried everything I can come up with to do this simple task:
Basic line graph with one category and 2 line series. One line shows a sales value and the other shows budgeted sales. Budgeted sales goes to the end of the year and the sales line becomes 0 after the current date. I've tried to use conditional formatting on the line series to hide the line on 0 values but it doesn't work. How do I make the line stop and hide the rest instead of showing a drop down to 0?
Thanks,
Chris.

I have followed the instructions on how to install Telerik Reports into Lightswitch.
http://blogs.telerik.com/blogs/posts/11-04-12/how-to-telerik-reporting-in-microsoft-lightswitch-beta-2.aspx
I am so frustrated I have been working at this in the evenings for two weeks and have not been able to get the darn thing to work.
I guess I do not understand how the magic works in getting the WCF service linked up to the Lightswitch application.
I have a LS app that I placed the WCF service project in. Is that all? Do I need to compile the WCF and install it somewhere?
I starts rendering the report then BOOM
Error: System.Reflection.TargetInvocationException : An exception occurred during the operation, making the result invalid. Check InnerException for exception details.
at System.ComponentModel.AsyncCompletedEventArgs.RaiseExceptionIfNecessary()
at Telerik.Reporting.Service.SilverlightClient.RenderAndCacheEventArgs.get_RenderingResult()
at Telerik.ReportViewer.Silverlight.ReportViewerModel.OnRenderAndCacheCompleted(Object sender, RenderAndCacheEventArgs e)
------------- InnerException: -------------
System.ServiceModel.CommunicationException : The remote server returned an error: NotFound.
at System.ServiceModel.Channels.Remoting.RealProxy.Invoke(Object[] args)
at proxy_3.EndRenderAndCache(IAsyncResult )
at Telerik.Reporting.Service.SilverlightClient.ReportServiceClient.OnEndRenderAndCache(IAsyncResult result)
at System.ServiceModel.ClientBase`1.OnAsyncCallCompleted(IAsyncResult result)
I have never worked with WCF and need a little hand holding to get this working.
Can someone from the community give me advice?
Thanks
Cliff