1. Nouran Hashimi
  2. InfoMaker
  3. Wednesday, 4 November 2020 21:53 PM UTC

I'm currently updating a report that one of my colleagues had built. This person has since left the organization. Currently, my report looks like this:

 

 

However, I need to group the header of my report by day of the week. For example like this: 

 

Does anyone know how to group headers in infomaker?

René Ullrich Accepted Answer Pending Moderation
  1. Thursday, 5 November 2020 07:11 AM UTC
  2. InfoMaker
  3. # 1

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é

Comment
There are no comments made yet.
Mark Lee @Appeon Accepted Answer Pending Moderation
  1. Thursday, 5 November 2020 05:45 AM UTC
  2. InfoMaker
  3. # 2

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,

Attachments (1)
Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.