Is there a way to Combine 2 Date Fields From a DataSource into 1 Field on Report and sort on it ? I'm aware of Sql Query Method, but this is based on Epicor XML Data File.

Thanks for reply. Let me explain it better. I have a Customer Statement with Invoice Date and Transaction Date  on  Statment one is on Group header and one on detail line underneath, but user wants them sorted as 1 column(see example) Do you know if this is possible The data is in an XML Epicor File which we don't really have control over to query . When I concatenate fields and sort it only sorts on first field , so they aren't really sorted on all fields