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.

********** Sorry, subject was supposed to say "Trouble ..." **********

Good afternoon,

I'm having difficulty with my VB.net 3.5 WPF application where printing with your WPF Report Viewer is no longer working since I've upgraded from version 5_0_11_316 to version 5_0_11_510.

Printing does work fine when printing from the deveoplmet computer that has Visual Studios 2010 and the latest installation (5_0_11_510) of your reporting system installed on it.

I build the application and publish it with no problems or errors flagged. There are also no runtime errors that occur. When I run the published application on a machine other than the developent computer, I load up the report view, the report loads fine, I then hit the print button and the print dialog opens. It can see all of the printers available to it, so I select print. Sadly, nothing happens from that point on other than the print dialog window closes.

Do you think I'm missing some kind of prerequisite or library reference with my application?

It's funny how the exact same program works when installed on the development machine (and when ran in debug mode in VS2010), but not on any other PC. I've tried this on several machines in my companies network, with different types of available printers (network, local etc), and I have the same results each time. I would just like to state that printing worked fine on all machines when I was using Telerik Reporting version 5_0_11_316.

The current telerik references that I have in my project are as follows:

• Telerik.Reporting (v 5.0.11.510)
• Telerik.Reporting.OpenXmlRendering (v 5.0.11.510)
• Telerik.ReportViewer.WPF (v 5.0.11.510)
• Telerik.Windows.Controls (v 2011.1.419.35)
• Telerik.Windows.Controls.Date (v 2011.1.419.35)
• Telerik.Windows.Controls.Input (v 2011.1.419.35)
• Telerik.Window.Controls.Navigation (v 2011.1.419.35)

Any suggestions that you may have is greatly appreciated. I need to try and get this fixed ASAP.
Thank you very much for your time.

Rob