A couple of older posts did briefly touch this subject, but did not help my case. So here goes......

Is there a way to wrap the same column of data multiple-times across each page, like a phone-directory ?

The column format should be as follows -

------------------------------------------
Fst-Name Last-Name
City........601-222-1111

Fst-Name Last-Name2
City........601-222-1112

Fst-Name Last-Name3
City........601-222-1113
------------------------------------------

And this column should repeat 6 times on each "portrait" page.
There should be a "Subhead" on County name whenever the County code changes across the data (pre-sorted that way).

This report will have to be a compound-PDF report, as there will have to be some standard Cover-pages and closing-pages on either side of the above report.

We do have Dev-Studio 764.

If there is not a straight forward option in WF that lets us "wrap" columns, please advise if we can bring in some external stylesheets or Word-templates to be able to fix up the report.

Thank you all so much for your input.
Sandeep Mamidenna

Without any further knowledge of your database and/or master file, I have pieced together some code that you may find useful.
The code is:

DEFINE FILE PHB
COL/I4 = IF COL EQ 4 THEN 1 ELSE COL+1;
ROW/I4 = IF COL EQ 1 THEN ROW+1 ELSE ROW;
EMP/A4 = ' ';
END

TABLE  FILE PHB
SUM    FNAME AS ''
       LNAME AS ''
OVER   CITY  AS ''
       PHONE AS ''
OVER   EMP   AS ''
BY     ROW   NOPRINT
ACROSS COL   NOPRINT
END

Hope this helps to get the job done ...

Do you want a true phone book per each page?

Yes Leah, we are really looking at building a phone directory listing rpt of a specific kind of business partners that we deal with. Data is available from a database and will be changing constantly.

The intention is to have this phone directory report on our website, so our customers always see the latest and greatest list.

GamP - Thank you for your suggestion too. Will try it out and keep you posted.

Sandeep Mamidenna

Below is some really old code where you create a true phone book by calculating page and number of records per column. Please forgive poor coding style, very old, mainframe. Just an example. This was a two column one, you can play with the columns. Data was presorted in order the information was wanted first before calculating the page, column and row.

 DEFINE FILE HOLD1XA                                                   
ALABEL/I2 WITH DETLINE = IF ALABEL EQ 16 THEN 1 ELSE LAST ALABEL + 1; 
END                                                                   
DEFINE FILE HOLD1XA ADD                                               
ACOLUMN/I1 WITH DETLINE = IF (LAST ALABEL EQ 16 AND LAST ACOLUMN EQ 2)
THEN 1 ELSE IF LAST ALABEL EQ 16 THEN LAST ACOLUMN + 1 ELSE IF LAST   
ALABEL EQ 0 THEN 1 ELSE LAST ACOLUMN;                                 
END                                                                   
DEFINE FILE HOLD1XA ADD                                               
PAGE/I5 WITH DETLINE = IF LAST ALABEL EQ 16 AND LAST ACOLUMN EQ 2 THEN
LAST PAGE + 1 ELSE LAST PAGE;                                         
H1/A40 WITH DETLINE = '          SCHOOL                  COUNT';      
END                                                                   
TABLE FILE HOLD1XA                                                    
HEADING                                                               
"<25 UNIVERSITY OF NEBRASKA AT OMAHA <70 &DATE"                       
"<22 NEW TRADITIONAL FRESHMAN APPLICATIONS"                           
"<16 (INCLUDING EARLY ENTRY AND INTERNATIONAL STUDENTS)"              
"<28 FOR THE <YEAR FALL SEMESTER </1"                                 
"<2 <H1 <46 <H1"                                                      
SUM DETLINE AS '' IN +0 OVER                                          
    DETLIN2 AS '' IN +3 OVER                                          
    DETLIN3 AS '' IN +0                                               
 BY PAGE PAGE-BREAK NOPRINT                                           
 BY ALABEL NOPRINT ACROSS ACOLUMN NOPRINT                             
ON TABLE SET NODATA ' '                                      
FOOTING BOTTOM                                                        
"PAGE <TABPAGENO <70 (AMHSRPT)"                                       
" "                                                                               
END