Error in exporting a Data Dynamics report in Excel

Posted by: rahulpatil017 on 3 August 2017, 3:23 pm EST

  • Posted 3 August 2017, 3:23 pm EST

    Dear Team,

    We receive below error when export the report in excel.

    Data Dynamic report version using: 1.6.1871.45

    Please suggest any possible cause for this.

    Please let me know any additional information required.

    ===================================

    TITLE: DataDynamics.Reports
    ------------------------------

    An unexpected error occured. Additional information: 'Range for report item ReportTable.grouping_Patient_Name must be within the range for report item ReportTable'

    ------------------------------
    ADDITIONAL INFORMATION:

    Range for report item ReportTable.grouping_Patient_Name must be within the range for report item ReportTable (DataDynamics.Reports.Rendering.Excel)

    ------------------------------
    BUTTONS:

    OK
    ------------------------------


    An unexpected error occured. Additional information: 'Range for report item ReportTable.grouping_Patient_Name must be within the range for report item ReportTable' (DataDynamics.Reports)

    ------------------------------
    Program Location:

    at DataDynamics.Reports.ReportRuntime.Render(IRenderingExtension renderingExtension, StreamProvider streams, NameValueCollection settings, Boolean forceDataRefresh)
    at DataDynamics.Reports.ReportRuntime.Render(IRenderingExtension renderingExtension, StreamProvider streams, NameValueCollection settings)
    at #bPf.#UPf.Export(RenderingExtensionInfo renderingInfo)
    at #bPf.#UPf.#OVf(Object sender, EventArgs e)
    at DataDynamics.Reports.Windows.Forms.CommandBars.CommandBarControl.OnClick(EventArgs e)
    at DataDynamics.Reports.Windows.Forms.CommandBars.CommandBarControl.PerformClick(EventArgs e)
    at DataDynamics.Reports.Windows.Forms.CommandBars.CommandBarContextMenu.MenuBarItem.OnClick(EventArgs e)
    at System.Windows.Forms.Command.Invoke()
    at System.Windows.Forms.Control.WmCommand(Message& m)
    at System.Windows.Forms.Control.WndProc(Message& m)
    at DataDynamics.Reports.Windows.Forms.CommandBars.CommandBar.WndProc(Message& message)
    at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
    at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
    at MS.Win32.UnsafeNativeMethods.DispatchMessage(MSG& msg)
    at System.Windows.Threading.Dispatcher.TranslateAndDispatchMessage(MSG& msg)
    at System.Windows.Threading.Dispatcher.PushFrameImpl(DispatcherFrame frame)
    at System.Windows.Window.ShowHelper(Object booleanBox)
    at System.Windows.Window.Show()
    at System.Windows.Window.ShowDialog()
    at ...View.ViewBase.DataContext_RequestOpenWindow(Object sender, RequestOpenWindowEventArgs e) in ...\View\ViewBase.cs:line
    .ViewModel.CommandViewModel.OnRequestOpenWindow(WizardHostViewModel viewModel, Boolean showModal) in ...\ViewModel\CommandViewModel.cs:line
    at ...ViewModel.AllReportsViewModel.OnRunReport() in ...\ViewModel\Reporting\AllReportsViewModel.cs:line
    at...ViewModel.AllReportsViewModel.<get_RunReport>b__1(Object param) in ...\ViewModel\Reporting\AllReportsViewModel.cs:line 180
    ...ViewModel.RelayCommand.Execute(Object parameter) in ...\ViewModel\Command\RelayCommand.cs:line 100
    at MS.Internal.Commands.CommandHelpers.CriticalExecuteCommandSource(ICommandSource commandSource, Boolean userInitiated)
    at System.Windows.Controls.Button.OnClick()
    at System.Windows.Controls.Primitives.ButtonBase.OnMouseLeftButtonUp(MouseButtonEventArgs e)
    at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
    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.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
    at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
    at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, 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, Int32 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, Boolean isSingleParameter)
    at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Boolean isSingleParameter, Delegate catchHandler)

    ===================================

    Range for report item ReportTable.grouping_Patient_Name must be within the range for report item ReportTable (DataDynamics.Reports.Rendering.Excel)

    ------------------------------
    Program Location:

    at #rUg.#vUg.#kYb(#sUg containerRenderingArea)
    at #rUg.#vUg.#kYb()
    at #GUg.#LUg.#W6g(ReportDefinition reportDefinition)
    at #GUg.#LUg..ctor(#EYg worksheet, IServiceProvider serviceProvider, #W4g workbook)
    at DataDynamics.Reports.Rendering.Excel.ExcelTransformationDevice.#pvh(IReport report, Stream template, StreamProvider streamProvider, #x5g settings)
    at DataDynamics.Reports.Rendering.Excel.ExcelTransformationDevice.Render(IReport report, StreamProvider streams, NameValueCollection settings)
    at DataDynamics.Reports.ReportRuntime.Render(IRenderingExtension renderingExtension, StreamProvider streams, NameValueCollection settings, Boolean forceDataRefresh)
  • Replied 3 August 2017, 3:23 pm EST

    Hello,

    We regret to mention that the official support DataDynamics 1.x has been officially withdrawn.
    Apologies for the inconvenience hence caused.

    If you wish to continue with ActiveX platform, please upgrade to Ar2 :
    http://www.datadynamics.com/Forums/64/ShowForum.aspx

    Else, you may try downloading the latest build of AR (.Net platform) from the following link and see if it meets your requirement:
    http://arhelp.grapecity.com/groups/topic/activereports-7-service-pack-1-maintenance-release-now-available-2/

    Regards,
    Mohita
  • Replied 3 August 2017, 3:23 pm EST

    Thanks Mohita. I have downloaded the msi and installed.

    I have received a dlls for the active reports 7.0.

    My first question is data dynamics reports renamed to active reports? I am sorry about my not knowing this.

    If yes, Hows its compatible our existing wpf windows reporting to new active reports.

    Any code changes required or just replacement of dll will work out?

    e.g: DataDynamics.Reports.Design,DataDynamics.Reports.Diagnostics,DataDynamics.Reports,DataDynamics.Reports.Extensibility etc are mapped to which dll in active report?
  • Replied 3 August 2017, 3:23 pm EST

    Rahul,

    You can make use of the converter tool to convert your existing DataDynamicsReports project to ActiveReports 7. Here is some information on using it:
    http://helpcentral.componentone.com/nethelp/AR7Help/OnlineEn/index.html?BreakingChanges.html

    However you might still need to make modifications to the classes and the namespaces in the code manually. To get some idea on what has changed please check the "Classes in Different Namespaces" section at the following link:
    http://helpcentral.componentone.com/nethelp/AR7Help/OnlineEn/index.html?BreakingChanges.html

    The page based reports available in ActiveReports 7 are the RDLX reports which are same as DataDynamics Reports. The only difference is the namespace and classes which they now use. Here is the list of dll's available in ActiveReports 7. The names should be similar to what you were having in DataDynamics Reports so you should be easily able to identify the ones you require:
    http://helpcentral.componentone.com/nethelp/AR7Help/OnlineEn/index.html?BreakingChanges.html

    Regards,
    Sankalp
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels