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

  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 ....
     

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

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!

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

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

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?

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

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:


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


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

Hello,

I'm migrating a set of reports from InProc session state to SQL Server sessions state (and have read the design considerations document at least 40 times.)  I'm using an object data source in a report and was wondering if someone could clarify if I understand correctly

1)  ObjectDataSource parameters must be primitive types.  i.e., I can not assign a "ReportCriteria" object as a parameter, but must assign ReportCriteria.StartDate, ReportCriteria.EndDate, ReportCriteria.ZipCode, etc as individual parameters?

2)  If I add a sorting binding to a column header and click it, the DataObjectMethod that my ObjectDataSource is assigned to will be called again and I have to take the database hit two times?   If this is the case and not a misunderstanding on my part, is there a reccommended approach to not hit the database multiple times?

3)  Are there any real world examples available anywhere in the documentation or videos?  I feel like everything I see works against the "best case" scenarios of clean data and no weird customer requirements?

Many thanks!

Joe