I need to be able to produce reports with mulitiple lines of data in WebFocus.

Example:

Name/Address........Phone/Fax...Website/Email
---------------------------------------------
Detail 1 = Name......Phone.........Website
Detail 2 = Addr.......Fax............Email

Detail 1 = Name......Phone.........Website
Detail 2 = Addr.......Fax............Email

Detail 1 = Name......Phone.........Website
Detail 2 = Addr.......Fax............Email


I have not been able to do this or find an approprate topic in the help.

Thanks,

Dale Walker

Dale,

One option is to use the 'OVER' command in your report procedure. Here is an example using the CAR file:



TABLE FILE CAR
HEADING
"Dealer/Retail Cost <0+> Width/Height"
PRINT DEALER_COST AS ''
WIDTH AS ''
OVER
RETAIL_COST AS ''
HEIGHT AS ''
OVER
COMPUTE EMPTYLINE/A1 = ' '; AS ''
ON TABLE SET PAGE-NUM OFF
ON TABLE SET STYLESHEET *
TYPE=REPORT, GRID=OFF,$
TYPE=HEADING, HEADALIGN=BODY,$
END

This will produce a report formatted something like the following:



Dealer/Retail Cost Width/Height
7,427 66
8,878 48

11,194 70
13,491 54

14,940 69
17,850 53

4,292 66
5,100 50

2,626 61
3,139 54
etc...

I used the HEADING's contents (in combination with the HEADALIGN stylesheet command) to produce the column titles. I did not use the default column titles because in a simple report like this the OVER command causes them to appear as a separate column to the left of the data columns. This technique works well with HTML format reports.

I used a COMPUTE instead of a SKIP-LINE to produce the blank line because SKIP-LINE does not work with HTML formatted reports.

You can find out more about the OVER and HEADALIGN commands as follows:

Creating Reports with WebFOCUS Language v4.3 (DN4500323.1001)

• Page 12-23 - Aligning Headings and Footings
  
• Page 9-32 - Reducing a Report�s Width: FOLD-LINE and OVER
  

or

Creating Reports with WebFOCUS Language v5.2 (DN4500513.0303)

• Page 26-26 - Stacking Columns
  
• Page 27-98 - Aligning a Heading or Footing Element in an HTML Report
  

Hope this helps,

This message has been edited. Last edited by: <Mabel>,

The way to do what you want is to use
a combination of AND and OVER in the verb
phrase.
SUM RETAIL AND DEALER <-on same line
OVER <- next line
SEAT AND WIDTH

BY MODEL

This will appear as..

MODEL

xxxxx RETAIL nnn DEALER nnn
SEATS bbb WIDTH ccc
yyyyy