Sorting within a sub report

I have added a subreport to another report. The subreport has a sortable column. This works fine to sort with when running the report by itself but when run as a subreport and clicking on the sorting I get this error.




Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing.
   at Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatReader.Initialize(Stream stream)
   at Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatReader..ctor(Stream stream)
   at Microsoft.ReportingServices.ReportProcessing.ChunkManager.DataChunkReader..ctor(DataSet dataSet, Int32 reportUniqueName, UInt32 subreportLevel, GetReportChunk getChunkCallback)
   at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit()
   at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
   at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
   at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
   --- End of inner exception stack trace ---
   at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessingContext.AbortHelper.ThrowAbortException()
   at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.Merge.Process(ParameterInfoCollection parameters, Boolean mergeTran)
   at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report report, ProcessingContext pc, ProcessingContext context)
   at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessUserSortEvent(String reportItem, SortOptions sortOption, Boolean clearOldSorts, EventInformation userSortInformation, ProcessingContext pc, GetReportChunk getReportChunk, String& newReportItem, EventInformation& newUserSortInformation, Int32& page)
   at Microsoft.Reporting.WinForms.LocalReport.ProcessUserSortEvent(String sortId, SortOptions sortDirection, Boolean clearSort, String& uniqueName)
   at Microsoft.Reporting.WinForms.LocalReport.PerformSort(String sortId, SortOrder sortDirection, Boolean clearSort, String& uniqueName)
   at Microsoft.Reporting.WinForms.ReportViewer.FireAnAction(Action action, Boolean shiftKeyDown)
   at Microsoft.Reporting.WinForms.WinRSviewer.SelectAction(ArrayList actionsList, Point location, Boolean shifKeyDown)
   at Microsoft.Reporting.WinForms.WinRSviewer.OnMouseUp(MouseEventArgs e)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.ContainerControl.WndProc(Message& m)
   at System.Windows.Forms.UserControl.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


Answer this question

Sorting within a sub report

  • richj

    I am still waiting on a answer for this.

    Thanks

  • Ultraman76

    This is a bug in beta 2.
  • Sorting within a sub report