Hi to all,
i started to test telerik report system. I made a really simple report (a simple grid from an sql table of about 100 rows... without images). I added webreportviewer to my project and connected it to my report. When i test my application i can see the report preview, i can export it in RTF or CSV but i cannot export it in PDF or XLS due an out of memory exception.
I'm using it on windows azure development enviroment. My system is an updated windows 7 64 bit with 4GB of ram and visual studio 2010 pro.

This is the exception stack trace

Some suggestion about to solve (or workaround) the problem?

Thanks

Sandro

Hi,

I have 2 sub reports in one main report. Each sub report has its own sub total, however I wish to add the total of these 2 sub reports and show it at the main report.

I am using Reporting in WPF and had built several reports that relied upon a class and methods for custom date manipulation. Previosuly this class was in the same assembly as the reports but was moved to a new assembly that is shared amongst other projects in the sln.
In the Edit Expression window I can see the new namespace ('Shared') in the treeview but the static class within it that I need is not visible, nor (of course) are any of it's static methods.

How can I add a reference to the User Funcitons on a Report? Or what am I doing wrong that is preventing me from seeing my class?

Thanks,
John

I have created a self hosted WCF service that contains a single report using the instructions from:  http://www.telerik.com/help/reporting/self-hosted-telerik-reporting-wcf-service.html.

When I test the service using the url http://localhost:54321/reportservice/resources/export?format=pdf&report=ConsoleApplication1.SampleReport,ConsoleApplication1&deviceInfo={}&parameterValues={}
it generates a PDF document of my report.

I created a separate silverlight project with a ReportView control that I would like to access the report from this service.  What settings does the ReportViewer control need to view the report hosted in this WCF service?

Thanks,
Tom

Hi Guys,

I'm evaluating Reporting 2011 Q2
Does anybody know if there is a way to pass table-valued parameter to a stored procedure?

When I'm trying to do that I'm getting the following exception thrown:

System.Data.SqlClient.SqlException (0x80131904): The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Table-valued parameter 7 ("@Hours"), row 0, column 0: Data type 0xF3 (user-defined table type) has a non-zero length database name specified.  Database name is not allowed with a table-valued parameter, only schema name and type name are valid.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
.. skipped..
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
   at Telerik.Reporting.Processing.Data.SqlDataEnumerable.<GetEnumerator>d__0.MoveNext()

According to comment in MSDN that could be caused by DeriveParameters method agains SqlCommandBuilder.

Indeed, the call exists in the reporting engine source code (SqlCommandProvider, ln.152):


Can you please confirm the bug or suggest a right approach for passing TVP?

Regards, Maxim Tebenev.
Mobile Systems International

We are trying to use the new app fabric cache as a out of proc session state provider in azure.  This seems to be the only one that microsoft recommends (the table storage one has issues w/ concurancy, and the sql azure one seems to be more of a hack - that some folks have gotten working, we were able to get the site up, but could not get telerik to render our reports with it), so we decided to spend our time on the method that microsoft recomends, app fabric cache... we were able to configure it, and the site that hosts our wcf ReportServer.svc comes up without throwing any exceptions - which indicates our session state is in play.  Yet when we go to render a 3 page report, we get the following error (seen in fiddler looking at the text reply (status 500)) :

<b> Description: </b>An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

<br><br>

<b> Exception Details: </b>System.InvalidCastException: Unable to cast object of type 'System.Text.CodePageEncoding' to type 'System.Text.Encoding'.<br><br>

<b>Source Error:</b> <br><br>

<table width=100% bgcolor="#ffffcc">

<tr>

<td>

<code>

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.</code>

</td>

</tr>

</table>

<br>

<b>Stack Trace:</b> <br><br>

<table width=100% bgcolor="#ffffcc">

<tr>

<td>

<code><pre>

[InvalidCastException: Unable to cast object of type &#39;System.Text.CodePageEncoding&#39; to type &#39;System.Text.Encoding&#39;.]

ReadInternalEncoderBestFitFallbackFromXml(XmlReaderDelegator , XmlObjectSerializerReadContext , XmlDictionaryString[] , XmlDictionaryString[] ) +648

System.Runtime.Serialization.ClassDataContract.ReadXmlValue(XmlReaderDelegator xmlReader, XmlObjectSerializerReadContext context) +106

System.Runtime.Serialization.XmlObjectSerializerReadContextComplex.InternalDeserializeInSharedTypeMode(XmlReaderDelegator xmlReader, Int32 declaredTypeID, Type declaredType, String name, String ns) +542

System.Runtime.Serialization.XmlObjectSerializerReadContextComplex.InternalDeserialize(XmlReaderDelegator xmlReader, Type declaredType, String name, String ns) +109

Any one have any ideas or can anyone suggest any alternatives... as at present we are not able to scale out our reports

Hi,
I am trying to connect to an Oracle Database using Devart dotConnect for Oracle.
I am able to configure the Data Source without any issues in the wizard and the Query Builder runs fine. The problem is when I  try to execute the query in the Wizard at the Preview Data Source Results I get an error dialog box only says Devart.Data.Oracle.

Thanks,
Yu

Hey there...I have a report that I'm working on and I have a field called AssetOwner and AssetValue....this owner has a possibility of having 3 different values (Self, Spouse, Joint)

I can bind a table and display the raw values without any problems, but at the bottom of the table I want to sum up the AssetValues based on the Asset Owners...like this.


Asset Owner               Asset Type               AssetValue
--------------------------------------------------------------------
Self                            Car                                  $5000
Self                            Boat                                $1000
Spouse                      Jewelry                            $1000
-------------------------------------------------------------------
Self Asset Total:                                                $6000
Spouse Asset Total:                                          $1000
Joint Asset Total:                                                     $0   


I was trying to just do a sum(AssetValue) but I can't find out how to filter that sum for a particular AssetType.


Any help would be really appreciated.



Thanks in advance.


John Scott.

Hello. I have added a Chart to my report that will be a Point chart. The axes both start at 0 and go to 6. For some reason, the 0 on the x-axis is indented about 1/3 inch from the origin. (and points with 0 for X are indented 1/3 inch) What property/setting can I change to make 0 be at the origin like it is with the Y origin?

Thanks,
Justin

Hello,

We have created one report in telerik reporting and provided facility to export report in PDF and Excel format.
Used Code :
byte[] buffer = Telerik.Reporting.Processing.ReportProcessor.Render(chkPDF.Checked ? "PDF" : "XLS", form, null, out mimType, out extension, out encoding);

PDF file and Excel file display data. But Excel file giving an error
File Error. Some number formats may have been lost

See screen shot of error.