Query/400 and Multiple Detail Lines
June 2, 2004 Hey, Ted
Help! I need to add more fields to the detail line in Query/400, but the line is already full. Do I have to get another query tool?
I’d recommend it. There are some good non-IBM query products on the market that have strong formatting abilities. But you can get through this crisis while you’re evaluating them.
Go ahead and select the additional fields on the “select and sequence fields” display. Select the fields in order by line and position. That is, select all of the fields that go on the first line, from left to right. Then select all the fields that go on the second line, again from left to right. Continue until all desired fields have been selected.
Next, select the “select output type and output form” display. Fill in the following options:
|Wrapping width||Enter the width of the report|
|Record on one page||Y|
|Form size width||Enter the width of the report|
Next, go to the “select report column formatting” display. This is where you’ll do the bulk of the work. As you work in this area, keep in mind that you can press F13 at any time to see the format of the finished report.
First, set the column spacing for each field in the first line to an appropriate value. Second, enter column headings for the fields on the first row, and set column headings for fields on second and subsequent rows to *NONE. (The value *NONE must be in uppercase.) Third, specify any editing you wish to apply to numeric fields. Fourth, enter any column widths you wish to change for first-line fields. Press F13 frequently to check on your progress. Your goal at this point is to get the first line the way you want it.
Once the first line is formatted appropriately, increase or decrease the column spacing value for the fields of the second line until they are aligned properly. Once the second line is aligned properly, format the third line. Continue until all lines are the way you want them to look. Here’s an example of what you might see when you press F13.
In the example, there are three lines for each input record. The resulting report looks like this.
Customer Listing Cmp Acct Name/Address Limit Type Rep 1 44 Joe's Shoes $.01 A 105 11 Main St Duluthe GA 30096 1 30003 Snowman Heat & Air 2,500.00 A 101 999 S. Main St Lexington OH 44904 2 1 Xolomon Solutions $7,500.00 A 104 Box 999 Tulsa OK 74146 2 3 Donaldson Electric $3,500.00 A 112 901 S. Rose Dr Whittier CA 90601 3 56 Jak's Liver Emporium $1.23 101 11 Filet Mignon Dr Mexico OH 40404
Although I’ve never done it, I have heard of using this technique to generate mailing labels.