Configuring a new print format for a window

This recipe describes how we can configure a print format for a window where we can display information from different tabs on that window.

How to do it...

1. 1. Create a view from the different tables, used in the window.

   CREATE VIEW adempiere.c_mom_v AS
   SELECT
   a.*,
   b.item_nbr,b.discussion_desc,b.ad_user_id AS actioned_by,b.c_momstatus_id,
   c.ad_user_id AS participant,c.company,
   d.name AS status
   FROM
   adempiere.c_mom a
   JOIN adempiere.c_mom_discussionline b ON a.c_mom_id=b.c_mom_id
   JOIN adempiere.c_mom_participantsline c ON c.c_mom_id=b.c_mom_id
   JOIN adempiere.c_momstatus d ON b.c_momstatus_id=d.c_momstatus_id;
   

2. 2. Go to the Table and Column windows and create table and columns from the c_mom_v view, as shown in the following screenshot:

1. 3. Go to the Menu | System Admin | General Rules | Printing | Print Format window and create a print format for, say, MOM Print Format, as shown in the following screenshot:

1. 4. Click on the Copy/Create button. When prompted...