Wrong sorting data when grouping
Dear sir,
i use this sql command to retrieve data into datatable and pass it to report
Select col1, col2, col3, col4, col5, col6
From MyTable
Order by col1, col2, col3, col4
if not GROUPING data in report the output is sorting right .
But when GROUPING by col1 and col2 like this
Group header1 condition = col1
Group header2 condition = col2
Data (display col3, col4)
col3 and col4 is not sorting correctly
PLEASE HELP ME
i use this sql command to retrieve data into datatable and pass it to report
Select col1, col2, col3, col4, col5, col6
From MyTable
Order by col1, col2, col3, col4
if not GROUPING data in report the output is sorting right .
But when GROUPING by col1 and col2 like this
Group header1 condition = col1
Group header2 condition = col2
Data (display col3, col4)
col3 and col4 is not sorting correctly
PLEASE HELP ME
Comments
Please turn off the sorting in the group header's editor (set to "None").
Thank you very much.