Hi Nouran,

Instead of creating a group datawindow you can simply add groups to your existing datawindow. Use the menu item Rows->Create Group in PowerBuilder. I think there should be also such a menu item in Informaker.

Instead of adding a column with orderno you can also do the same in the datawindow sort dialog: Add a column to sort and doubleclick on it. So you can set an expression for sort like Mark have done it in SQL.

HTH,

René

Hi Nouran,

It is very simple.

It is suggested you create a Group DataWindow and modify the syntax content for its Select statement, adding a column to make the grouping sort on Monday through Sunday to implement it.

(Set both the grouping and sorting of this datawindow to this newly added column.datawindow, such as the orderno in the attachment.)

Related code:

Select 
dayname( "sales_order"."order_date") as "daynames", 
case dayname( "sales_order"."order_date") when 'Monday' then 1                                                                                                                                                                                                        when 'Tuesday' then 2                                                                                                                                                                                                               when 'Wednesday' then 3                                                                                                                                                                                                             when 'Thursday' then 4                                                                                                                                                                                                              when 'Friday' then 5                                                                                                                                                                                                              when 'Saturday' then 6                                                                                                                                                                                                              when 'Sunday' then 7 
end  as "orderno"
From "sales_order" 

Or see the attachment for reference.

Regards,