You can mix tabular data and reformatted text within blocks of text.
To mix tabular and detail block text:
For this example, run the following SQL query:
SELECT ACCTNO, COMPANY, NOTES FROM Q.SUPPLIER
SHOW FORM.COLUMNS
For this example, make the following changes on the FORM.COLUMNS panel:
SHOW FORM.DETAIL
You do not have to specify a form variable for the tabular data; the data will follow the last line of detail block text.
For more information on specifying detail block text, see Refining the format of your report with detail blocks.
FORM.DETAIL MODIFIED Var 1 of 1 Include Column Headings with Detail Heading? ===> NO LINE ALIGN DETAIL HEADING TEXT ---- ------ ----+----1----+----2----+----3----+----4----+----5----+ 1 LEFT 2 LEFT *** END *** New Page for Detail Block? ===> NO Repeat Detail Heading? ===> NO Keep Block on Page? ===> NO Blank Lines after Block ===> 6 Put Tabular Data at Line (Enter 1-999 or NONE) ===> 4 LINE ALIGN DETAIL BLOCK TEXT ---- ------ ----+----1----+----2----+----3----+----4----+----5----+ 1 LEFT COMPANY: &2; 2 LEFT ACCOUNT NUMBER: &1; 3 LEFT NOTES: Select Panel Variation? ===> NO
COMPANY: WESTCO, INC. ACCOUNT NUMBER: 1100P NOTES: THIS COMPANY HAS A STRONG HISTORY OF ON-TIME DELIVERY. WESTCO IS GROWING QUICKLY.
When you omit some columns from the report, as in this example, you reduce the automatic total width of the report. Make sure that your report is wide enough to include all of the detail block text. Change the width of your report by changing the Report text line width field on the FORM.OPTIONS panel.