Passing Query Sort Fields from Workflow

Zack Robison

May 22, 2024 17:41

I have a form where users are able to select sorting fields for a query used to generate a report.  I'd hoped that the order of the features in the report would match that query's results, but I lose that order when executing the secondary query in the Report using the input feature IDs.

Has anyone scripted a solution to this?  I'm sure it's doable but am having trouble digging through the DevExpress API documentation to fish this out.  Or is there a better way for me to pass features to the report?

0

• 

  Nico Burgerhart

  May 22, 2024 19:17

  In the report there you can define Sort Fields on a Detail Band, but I do not know if you can change this dynamically.

  https://docs.vertigisstudio.com/reporting/latest/help/Default.htm#shr/help/detail-band.htm

   

  1
• 

  Nico Burgerhart

  May 22, 2024 19:20

  I think it should be possible

  https://docs.devexpress.com/XtraReports/8822/detailed-guide-to-devexpress-reporting/shape-report-data/group-and-sort/sort-data-runtime-sample

   

  1
• 

  Zack Robison

  May 17, 2026 19:59

  For future users (of which I am now one): I got this working but got tripped up on trying to set the sorting using the Detail_Discrepancy_BeforePrint() function; do not do this.  Use Report_BeforePrint().

  Something like:

  private void Report_BeforePrint(object sender, System.ComponentModel.CancelEventArgs e) {
  	var detailBand = Report.Bands[BandKind.Detail] as DetailBand;
  	var inputSortFields = Report.Parameters["sortField"].Value.ToString();
  	var sortField = new GroupField(inputSortField, XRColumnSortOrder.Ascending);
  	detailBand.SortFields.Add(sortField);
  }

  0

Please sign in to leave a comment.