1
Sorting data in a groupband
Question asked by Kellen Weissenbach - March 15 at 4:42 AM
Unanswered
I am trying to sort a groupBand's data to be by FullName + ShiftDate and it's NOT working!  The actual data returned from the db is already pre-sorted in this fashion, but the resulting report sorts part A-Z, then continues with another set A-Z, etc... and the entire "UnitDescription column is the same for the entire result set.
 
I may be doing something wrong... but I have tried everything and it still sorts incorrectly.
 
Example below......
 
dataBand1 Datasource = dtCompanyData
  groupBand1 Grouping = dataBand1["CompanyName"]
     groupBand2 = Grouping = groupBand1["UnitDescription"], SortExpression =  groupBand1["FullName"].ToString().Trim() + groupBand1["ShiftDate"].ToString().Trim()
     End groupBand2
  End groupBand1
 
End dataBand1
 
 
 

Reply to Thread