Telerik Forums
Reporting Forum
0 answers
211 views
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

Deva
Top achievements
Rank 1
 asked on 26 Jul 2011
8 answers
372 views
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
fabiopand
Top achievements
Rank 1
 answered on 26 Jul 2011
2 answers
439 views
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.
Mayank Tyagi
Top achievements
Rank 1
 answered on 26 Jul 2011
1 answer
137 views
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
Justin Lee
Top achievements
Rank 1
 answered on 26 Jul 2011
1 answer
374 views
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.
Peter
Telerik team
 answered on 26 Jul 2011
7 answers
162 views
********** 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

Rayne
Top achievements
Rank 1
 answered on 26 Jul 2011
3 answers
904 views
Hi,
 I am trying to exec function to refer another datascope. I have a list 'list1' which is bound to sqlDataSource1 and another list in this list 'list2' which is bound to sqlDataSource2, I am trying to refer to a field in datascope of list1 using exec but it is complaining invalid scope list1.
the exec function is used to display the value in the textbox:
=CDbl(Exec("list1", Sum(Fields.Id)))

I am also wondering if i can just refer to Fields.Id, which is what I actually need but for now i am just trying to get the exec function work with typical aggregate function.

Please help, Thank you
IvanDT
Telerik team
 answered on 26 Jul 2011
2 answers
534 views
Hello.
I have a table in a report that is bound to a list of objects.  I would like to add a filter to only display rows where a certain property is not null.  The property is a nullable decimal (C#: Decimal?)

How would I set this filter up?  (is it possible?)

I tried:
    Expression:    =Fields.Property
    Operator:        <>
    Value:            =Null
And
    Expression:    =CStr(=Fields.Property)
    Operator:        <>
    Value:            <left the value blank>

but neither worked.

Thanks,
Justin
Justin Lee
Top achievements
Rank 1
 answered on 26 Jul 2011
11 answers
272 views
LightSwitch is going to be a great development tool for LoB apps based on Silverlight 4 technology. It saves a lot of time by automating many steps. However, any LoB apps ends up requiring lots of reports, printings and etc. But the unfortunate part is, LS V1 (due to time constraints and others), will not have reporting and I see more and more developers voicing their frustration and disappointment over this issue. I think Telerik has a great Reporting service and with the new SL viewer, it can perhaps solve this problem and offer a solution.

My question, is the team looking at having a custom solution for LightSwitch? If yes, please let us know, so we can spread the word and bring you business.

Thanks!
..Ben
Vassil Petev
Telerik team
 answered on 26 Jul 2011
4 answers
177 views
Hi there.

I have a need to capture the filtering criteria that a user selects and save it as an item in their "My Reports" section. I think how this would work is you would create a canned report that a user can run and select the criteria that makes sense for them, then executes the report. When the report gets created, the user would be able to save the criteria so they can run the report quickly the next time.

Also, is there anyway to have the user select which columns of data they want to see as well?

Just seeing if it can be done with Telerik.

Thanks, Mike
Paul
Top achievements
Rank 1
 answered on 26 Jul 2011
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?