Create GroupExpression in table suppress my order by SQL command

[Stefano Ravagni]

Hello... i created a new table with a GroupExpression (during construction) on a ID field...

When i run report i pass a SQL with a personalized ORDER BY...sometimes by PRODUCT NAME, some others by a numeric code or datetime...

With the table who have a GroupExpression this ORDER BY command will be suppressed and i obtain every time a sorting by the field wrote on GROUPEXPRESSION...

Is there a way for group by on a specific field but maintain the order by command ?

Thanks

[Andrey Gankov]

I have same situation in one report. And it works for me.
Table on RDL level grouped by some field. But still i add ORDER BY in SQL to sort groups, before groups was random order.
If you need sort data in group, i think you need use rdl for sorting.

пятница, 2 октября 2020 г. в 17:26:13 UTC+3, stefano...@gmail.com:

[Stefano Ravagni]

If i use RDL sort function it run with the sort condition but it is a fixed condition, so it bypass my SQL order by instruction.... this happen only if i use GroupExpression and not in normal table.... is a natural  behavior or can i adjust this in somes ways ?