Telerik Forums
Reporting Forum
11 answers
760 views
Hello,
 
I've tried everything, but Telerik Reporting Service doesn't work via HTTPS (SSL) protocol! Did anybody tried this configuration in practice? I'm not the only one, read discusion about this problem here: Silverlight forums
 
Our company is in decision phase which reporting system to use in Silverlight LOB applications and this problems may affect our choice ...

Best regards
 
 
 
Kenneth
Top achievements
Rank 1
 answered on 09 Apr 2014
13 answers
1.1K+ views
Hello,

The application that I am developing has a set of standard reports which are designed in Visual Studio as .cs classes. Now there is a new requirement that the users should be able to modify these standard reports and upload them back to the application as  a custom report. I use the 'Telerik.Reporting.XmlSerialization.ReportXmlSerializer' class to serialize the report and save it as .trdx file. Users then make the necessary changes to the report using the stand alone designer and then upload it back to the application which will be saved in the database as xml text. When that custom report is run, I deserialize it to a report object. But I get an error during deserialization as follows
<<ERROR START
Telerik.Reporting.Xml.XmlSerializerExcepion was unhandled by user code
  Message=An error has occurred during xml serialization. The xml serializer cannot resolve type with name:
  Source=Telerik.Reporting
  StackTrace:
       at Telerik.Reporting.Xml.ObjectXmlReader.ReadXmlElement(String name)
       at Telerik.Reporting.Xml.ObjectXmlReader.ReadCollection(Object collection)
       at Telerik.Reporting.Xml.ObjectXmlReader.ReadProperties(Object obj)
       at Telerik.Reporting.Xml.ObjectXmlReader.ReadObject(Type type)
       at Telerik.Reporting.Xml.ObjectXmlReader.ReadXmlElement(String name)
       at Telerik.Reporting.Xml.ObjectXmlReader.Deserialize()
       at Telerik.Reporting.XmlSerialization.ReportXmlSerializer.Deserialize(XmlReader reader)      
       at MS.Internal.Commands.CommandHelpers.CriticalExecuteCommandSource(ICommandSource commandSource, Boolean userInitiated)
       at System.Windows.Controls.Primitives.ButtonBase.OnClick()
       at System.Windows.Controls.Button.OnClick()
       at System.Windows.Controls.Primitives.ButtonBase.OnMouseLeftButtonUp(MouseButtonEventArgs e)
       at System.Windows.UIElement.OnMouseLeftButtonUpThunk(Object sender, MouseButtonEventArgs e)
       at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)
       at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
       at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
       at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
       at System.Windows.UIElement.ReRaiseEventAs(DependencyObject sender, RoutedEventArgs args, RoutedEvent newEvent)
       at System.Windows.UIElement.OnMouseUpThunk(Object sender, MouseButtonEventArgs e)
       at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)
       at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
       at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
       at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
       at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
       at System.Windows.UIElement.RaiseTrustedEvent(RoutedEventArgs args)
       at System.Windows.UIElement.RaiseEvent(RoutedEventArgs args, Boolean trusted)
       at System.Windows.Input.InputManager.ProcessStagingArea()
       at System.Windows.Input.InputManager.ProcessInput(InputEventArgs input)
       at System.Windows.Input.InputProviderSite.ReportInput(InputReport inputReport)
       at System.Windows.Interop.HwndMouseInputProvider.ReportInput(IntPtr hwnd, InputMode mode, Int32 timestamp, RawMouseActions actions, Int32 x, Int32 y, Int32 wheel)
       at System.Windows.Interop.HwndMouseInputProvider.FilterMessage(IntPtr hwnd, WindowMessage msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
       at System.Windows.Interop.HwndSource.InputFilterMessage(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
       at MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
       at MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o)
       at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
       at MS.Internal.Threading.ExceptionFilterHelper.TryCatchWhen(Object source, Delegate method, Object args, Int32 numArgs, Delegate catchHandler)
  InnerException:
ERROR END>>

The error does not occur when the report is uploaded without making any changes, but that is not of any use to me. The change that I made in the stand alone designer was adding a textbox to the report. I am using the 'Reporting Q2 2013' assemblies. Any help would be highly appreciated.

Thanks in advance
Shameer

Kerem
Top achievements
Rank 1
 answered on 09 Apr 2014
5 answers
167 views
  Hi,
     I have created a report in my VS2008 development solution. 
     My website project was within a solution, so all I had to do was add an existing project, add to the references, build, etc. 
     The problem is that I need to put this report on my dnn production website. It is only a website so it has no VS2008 solution to add an existing project.
      Since I am new to telerik reporting (and C#/.NET) , I have no idea how to get that going on my dnn site. Well, I do have ideas, but, I am wondering if you could point me in the right direction so that I can do it correctly ? 
      Would the concept be that I create a dll of the project and then add that dll to my dnn website references ?  (Told you I had ideas). 
      thanks for your advice ....
     
Divya
Top achievements
Rank 1
 answered on 09 Apr 2014
2 answers
96 views
Hello,

I have a label, which has numeric values on the telerik report - dynamically generated, but when the value is negative the minus sign in the preview appears as a box, is there any way to fix this, please lt me know if any other details are required.

Regards
Deepika


Nasko
Telerik team
 answered on 09 Apr 2014
1 answer
90 views
Hi Everyone;

Suppose our application needs to provide user a way for them to create an email template that some content are static and some content come from database and sort of creates a email-marge. Like:

Dear <<Customer.FirstName>>;
We would like to notify that your balance amount of <Customer.Balance>> is over due.


The content is not created by developer like a regular report where developer designs the report and binds database fields in the report. In this case the user enters the content and anything in << >> (I only used this as a sample) comes from database at runtime and produces an email to be sent out.

What's the best way to offer end user an email mailmerge?

Thanks!
Stef
Telerik team
 answered on 08 Apr 2014
3 answers
153 views
When I create a report in VS2012 I am using background colors for a couple fields.  The color I am using is RGB (39, 39, 88).  When I run the program and look at the output excel report, the colors are different RGB (51,51,51).  See attached screen shots for example.  the first image labeled DesignTime.png is what I see in VS2012.  The second image labeled Output.png is the output excel report.

Any help would be appreciated.
Thanks
-Matt
KS
Top achievements
Rank 1
 answered on 08 Apr 2014
1 answer
83 views
I designed a report using an ObjectDataSource, usually placed contrloles TextBox and HtmlTeextBox kind in panes in the section header and footer, and when rendering the report, it disappears the entire panel without displaying any errors or displayed message, why is this happening? 

As I correct? 

I include a picture with the preview in the designer and another to the already generated report. I hope I can help identify whats wrong whit my report.

My Unique Customer ID is: YQ544656

Thanks is advance
Nasko
Telerik team
 answered on 08 Apr 2014
1 answer
207 views
Hi all,
I have been trying different things to try and get this to work but keep running into walls.
My setup is:

Visual Studio 2012 - Winforms - Telerik Reporting 2013 Q3
SQL Server 2008R2 backend.

Master table
name: JSA1
Key Field: JSAID
Field1
Field2
Field3
Field4

Detail Table
name: tblSteps
Key Field: STEPID
FK Field: JSAID
Field1
Field2
Field3
Field4

Foreign key is setup properly in SQL Server.
I have 2 stored procedures that select records from each of the tables.
I can preview the reports individually with an entered parameter value and they both work fine.
What I want to accomplish is to be able to pass the parameter to BOTH the main report and the subreport.
I followed the Master Detail guide, and that works ok, but it is slow since it has to return ALL of the detail table before it filters then down to the records I want.

I call the master report using a form with a reportviewer on it and pass the parameter to the main report as follows
 Dim instanceReportSource As New Telerik.Reporting.InstanceReportSource()
                instanceReportSource.ReportDocument = New Reporting.VWIDetail()
                instanceReportSource.Parameters.Add(New Telerik.Reporting.Parameter("JSAID", GlobalVariables.VWILinkDetail))
                ReportViewer2.ReportSource = instanceReportSource
               ReportViewer2.RefreshReport()

How can I pass that parameter to the sub report in the same way?




Nasko
Telerik team
 answered on 08 Apr 2014
1 answer
90 views
Hi,

We are using Q1 2014 version of telerik for reporting.
We have a scenario where the user can select the export option before he creates a report.

Suppose, if he selects pdf and  clicks on create report, the report should be displayed in new window in pdf format.
same for all the other output types( tiff,excel..etc.)

How can we acheive that? Any help would be appreciated.


Many thanks,
Manognya.K
Stef
Telerik team
 answered on 08 Apr 2014
2 answers
544 views
Hello,

i set a filter to check if my value (from Database) is a String. I don't know how to do it properly. So i use my own Function:

Public Shared Function CheckForAlphaCharacters(ByVal StringToCheck As String) As Boolean
 
    Try
        Dim i As Integer = 0
        For i = 0 To StringToCheck.Length - 1
            If Char.IsLetter(StringToCheck.Chars(i)) Then
                Return True
            End If
        Next
        Return False
    Catch ex As Exception
        Return False
    End Try
 
End Function

An this is how i define the filter. (I also added a screenshot)

= MIR.Web.ZinsCheck.Hilfsfunktion.CheckForAlphaCharacters(CStr(Fields.Beschäftigungsverhältnis2)) = True = = True

What I want is, if the Value is Empty the row not visible.

So this wont work. What i'm doing wrong?

But I am also open to other solutions!

Thank you,
Daniel
Daniel
Top achievements
Rank 1
 answered on 07 Apr 2014
Top users last month
Edmond
Top achievements
Rank 1
Iron
fabrizio
Top achievements
Rank 2
Iron
Veteran
RobMarz
Top achievements
Rank 2
Iron
Fakhrul
Top achievements
Rank 1
Iron
Tejas
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?