Telerik Forums
Reporting Forum
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
131 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
188 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
62 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
144 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
53 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
247 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
3 answers
382 views

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.

 

 

Ivan Hristov
Telerik team
 answered on 27 Apr 2015
7 answers
143 views

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

Cliff McManus
Top achievements
Rank 1
 answered on 26 Apr 2015
Top users last month
Rob
Top achievements
Rank 3
Bronze
Iron
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?