Telerik Forums
Reporting Forum
3 answers
426 views

Hello everyone,
I have to create a report with in total 4 nested tables. We'll do the example with only 2 tables for easier comprehension. 
Assume we have an array with Orders, and in this table is an array with Products. So for each Order we have several Products. 

I made a TelerikTable which is bound on the Orders. The first line is the table headers. Each Order has 3 lines:
- 1: specific information about the Order (id Order, ...)
- 2: A merged line with another table in it, bound on the Products array.
- 3: The total of all Products of that Order.
For better / clear comprehension, look at the NestedTable.jpg (attached file).

Let’s export that list in PDF format:
Now the problem is that some Orders have a lot of Products: for example 200 Products. An order doesn't necessarily begin at the beginning of the A4 page (it can be in the middle). So the array of Products of the second Order doesn’t fit on the first page, and it makes automatically a page break (because its 1 merged line of the main table?).

For better / clear comprehension, look at the ProblemNestedTable.jpg (attached file).

KeepTogether parameter is everywhere to false.

I don’t want that page break, but fragment the nested table (Products).

Is there a way that there is a “Keep Table Line Together = False”? Or I may be completely wrong with my table structure? Maybe there is another option instead of nested tables?

Thanks a lot :)

Raphael
Elian
Telerik team
 answered on 02 Mar 2012
1 answer
139 views
Hi,

I created a line chart in my report. Using the Wizard, I set the skin to Deep Green. Then based on the website documentation, I went to the Properties of the Chart to create ChartAxisItems for my X-Axis. I changed the Text value to "00:00" etc. In the Designer mode, all the axis item labels showed as expected. However when I switch to Preview mode, I still see my X-Axis items labelled as 0, 1, 2, 3 etc... I have tried compiling again, but din make a difference. Hope you can advise me on what I have not done or have done wrongly. Thank you for your time.
Elian
Telerik team
 answered on 02 Mar 2012
5 answers
191 views
Hi,

1. How do I set ChartSeriesItem.Label.Appearance.Visible = false
after binding a stackedbar-chart's datasource to a DataTable in the NeedDataSource method?

2. If this cannot be accomplished, I assume I would have to build the ChartSeries programmatically.  Can you direct me to code specifically geared towards programmatically building stackedbar charts? (The goal is an X-Axis with a date-label and stacked values representing different count-values. The legend should be the DataTable column-names.) 

The DataTable looks like this (the column-names are actually error-numbers from an external system):

MDate     10230     13456     23432
2011-01       4         1         1
2011-02       0         2         2
2011-03       2         0         0

The chart should look like this:
6|-G--|
5|----|  |----|           ¤ 10230(red)
4| B  |  | G  |           ¤ 13456(blue)
3|----|  |----|           ¤ 23432(green)
2| R  |  | B  |  |----|
1|____|__|____|__|__R_|_____
  2011    2011    2011
   -01     -02     -03

Hope you understand my question. The chart works fine with databinding but I would really like to take away the text on the bars and just leave the color with a legend instead.

Thanks for any assistance you can offer.
Elian
Telerik team
 answered on 02 Mar 2012
1 answer
191 views
I have a report in which I want to use a different sub-report for each detail item depending on a value in the item data. For example:

If type=1, Use sub-report Sub1
If type=2, Use sub-report Sub2
etc.

Is this possible? If so, how? I've tried putting a SubReport in the detail, and in the detail_ItemDataBound set the SubReport.ReportSource, but it doesn't seem to work. Any ideas gratefully received.

Thanks

Ross Crawford
Lucania
Top achievements
Rank 1
 answered on 02 Mar 2012
7 answers
311 views
My report was working fine using a SqlDataSource that used a SELECT without any WHERE clause.  Then I changed it to use an ObjectDataSource method that uses parameters to generate a WHERE clause, and my report now fails.  The ObjectDataSource method works fine when invoked by my WebForms, and I tried putting a breakpoint in my business object's Select method, and I never got there, so I'm pretty sure it's not a problem within my object.

When I try to "preview" the report, the designer shows me this error message:
    An error has occurred while processing Report 'MyReport':
    Exception has been thrown by the target of an invocation.
    --------------------- InnerException ----------------------
    Object reference not set to an instance of an object.

I based my implementation upon this tutorial: http://tv.telerik.com/watch/reporting/objectdatasource/using-parameters-with-objectdatasource-component

I'm a Reporting newbie, and I need to learn how to debug reports.  (Apparently you can't simply step through them using the debugger.)  So any tips on how to investigate report bugs would be gratefully accepted.
Steve
Telerik team
 answered on 01 Mar 2012
1 answer
319 views
Good afternoon,

After my initial problem here: http://www.telerik.com/community/forums/reporting/telerik-reporting/error-adding-new-telerik-report-to-solution.aspx I have finally gotten around to trying to add a new Telerik report to an existing WPF .NET 4 application I have written.

The problem I now have is that the DataSource wizard doesn't seem to pick up any of my datasets or entity models. If I tell the report wizard to create a new one, it doesn't even pick up my connection string from the project settings and I have to manually add it. 

Once the connection string is added, the next screen does not show any of the objects in my SQL database.

Am I way off here with what I should be doing or do I perhaps have a problem that is / isn't related to my original problem?

I'm really disappointed that I can't get this working yet but I'm afraid I will not be purchasing this Telerik reporting option until I am up and running correctly despite I think that it looks like the best reporting option available for my WPF applications.

Thank you,

Paul Pitchford.
Steve
Telerik team
 answered on 01 Mar 2012
3 answers
656 views
hello

I put a red line atravies lines and also the name of the columns with a name and not a number as can be done from the source code, is a report.

attached image
Steve
Telerik team
 answered on 01 Mar 2012
0 answers
167 views
Hi,

I am using telerik repotrviewer for reports and here is my code that dynamically accessing report and assigning to reportviewer.
When I run the application I am getting the following error message.

"Exception has been thrown by the target of an invocation."

Here is my code:
            Type reportManagerType = typeof(ReportClass);
            _reportAssembly = reportManagerType.Assembly;
            string assemblyName = _reportAssembly.GetName().Name;
            _reportName = String.Concat(assemblyName,".", _currentReportInfo.Name);
            _reportType = _reportAssembly.GetType(_reportName);
            _report = (IReportDocument)Activator.CreateInstance(_reportType);
               
            IReportDocument report = (IReportDocument)Activator.CreateInstance(_reportType);
            this.DefaultReportViewer.Report = report;

Please help me...
Sri
Top achievements
Rank 1
 asked on 01 Mar 2012
16 answers
317 views
I have the wpf report viewer in a user control which is on a tab (Telerik RadTabControl). When I close the tab I get
the following exception:


System.NullReferenceException was unhandled
  Message=Object reference not set to an instance of an object.
  Source=Telerik.ReportViewer.Wpf
  StackTrace:
       at Telerik.ReportViewer.Wpf.ReportViewer.ReportViewerUnloaded(Object sender, RoutedEventArgs e)
       at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
       at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
       at MS.Internal.FrameworkObject.OnUnloaded(RoutedEventArgs args)
       at System.Windows.BroadcastEventHelper.BroadcastEvent(DependencyObject root, RoutedEvent routedEvent)
       at System.Windows.BroadcastEventHelper.BroadcastUnloadedEvent(Object root)
       at System.Windows.Media.MediaContext.FireLoadedPendingCallbacks()
       at System.Windows.Media.MediaContext.FireInvokeOnRenderCallbacks()
       at System.Windows.Media.MediaContext.RenderMessageHandlerCore(Object resizedCompositionTarget)
       at System.Windows.Media.MediaContext.RenderMessageHandler(Object resizedCompositionTarget)
       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)
       at System.Windows.Threading.Dispatcher.WrappedInvoke(Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)
       at System.Windows.Threading.DispatcherOperation.InvokeImpl()
       at System.Threading.ExecutionContext.runTryCode(Object userData)
       at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean ignoreSyncCtx)
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       at System.Windows.Threading.DispatcherOperation.Invoke()
       at System.Windows.Threading.Dispatcher.ProcessQueue()
       at System.Windows.Threading.Dispatcher.WndProcHook(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)
       at System.Windows.Threading.Dispatcher.WrappedInvoke(Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)
       at System.Windows.Threading.Dispatcher.InvokeImpl(DispatcherPriority priority, TimeSpan timeout, Delegate method, Object args, Int32 numArgs)
       at MS.Win32.HwndSubclass.SubclassWndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam)
       at MS.Win32.UnsafeNativeMethods.DispatchMessage(MSG& msg)
       at System.Windows.Threading.Dispatcher.PushFrameImpl(DispatcherFrame frame)
       at System.Windows.Application.RunInternal(Window window)
       at ...Controller.Main(String[] args) in ...\Controller.cs:line 537
       at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args)
       at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean ignoreSyncCtx)
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       at System.Threading.ThreadHelper.ThreadStart()
  InnerException:


This exception did not occur in Reporting version 5.3.11.1116
Steve
Telerik team
 answered on 01 Mar 2012
2 answers
179 views
Hi,I installed version Q1 2012, the components do not appear in the toolbox, I installed the toolbox manually from the Telerik.Reporting.dll, but the component TableWizard & CrossTableWizard not appear, could you help me ?
OS = Windows7 ultimate & VisualStudio 2010, i have reset the toolbox and reinstalled many time the components, but the components not appears

thanks

Aurelio
Aurelio Righetti
Top achievements
Rank 1
 answered on 29 Feb 2012
Top users last month
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?