Group by on two columns does not seem to order 2nd column

[fox_224]

Hi Vladimir,

I have a simple mysql script like:

select column1,column2 from table group by column1, column2

There are several column2 records for each column1.

However, in the report, it only sorts by column1 and the column2 is not in order. Any reason why?

Regards,

[Alex K.]

Hello,

Please send us your report with sample data for analysis.

Thank you.

[fox_224]

HI Alelsev,
Thank you for responding.
I have a group band which contains the column1 value and in the data band I have the column2 values under it. But I think I have found the solution. In the group band, I have the option sort (none, ascending, descending). By default it is ascending. But I have already grouped my data so there is no need to re-sort it again. I selected None and the 2nd column is ok now.
Regards,

[Ivan]

Hello,

Let us know if you need any additional help.

Thank you.