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.
dataBand1 Datasource = dtCompanyData
groupBand1 Grouping = dataBand1["CompanyName"]
groupBand2 = Grouping = groupBand1["UnitDescription"], SortExpression = groupBand1["FullName"].ToString().Trim() + groupBand1["ShiftDate"].ToString().Trim()