Two groups in a report

I need to have a report with 2 groups (or more) but with only one query.

Example : my query is
select * from customer, orders where orders.CustNo = customer.CustNo
And I need to group by SaleDate or by CustNo
So I need to 'Order by' before grouping. Is it possible in Fastreport to change the 'order' before grouping ?
Thx
Phil

Comments

  • gpigpi
    edited 5:11PM
    wrote:
    Is it possible in Fastreport to change the 'order' before grouping ?
    This is not FR task, FR use dataset. You should close query, change query text and open query again
  • edited 5:11PM
    gpi wrote: »
    This is not FR task, FR use dataset. You should close query, change query text and open query again
    thx !

Leave a Comment