Hi,
I am working on a compound report and I need the Title Row {Columns: Car Type|Country|Car|Model|Bodytype|Seats|Sales|Retail_Cost} to repeat each time the Car Type ( TYPE) Changes.

Just to make a compound PDF report, I have added the first and last step. You can ignore those steps. Just look at the GRID titled "Sample Report"

I had actually created 2 samples ( One in word -- a Desired Format, and another in PDF the existing one). But I dont know how to upload those sample documents here.

  


TABLE FILE CAR
SUM SEATS 
BY CAR
ON TABLE PCHOLD FORMAT PDF OPEN NOBREAK
END

-* This is the step that I want help with
TABLE FILE CAR
HEADING
"SAMPLE REPORT"
PRINT 
COUNTRY 
CAR 
MODEL 
TYPE 
SEATS 
SALES 
RETAIL_COST
BY TYPE AS 'Car Type'
ON TYPE SUB-TOTAL 
ON TYPE SUBHEAD
"<TYPE"
ON  TYPE  NOSPLIT
ON TABLE SET PAGE-NUM OFF
ON TABLE SUBTOTAL SALES AS 'Total Sales'
ON TABLE SET STYLE *
TYPE=HEADING, HEADALIGN=INTERNAL,$
TYPE=HEADING, LINE=1, SIZE=12,FONT=TIMES NEW ROMAN,STYLE=BOLD+UNDERLINE,GRID=OFF,$
TYPE=HEADING, LINE=3, SIZE=9,FONT=ARIAL,STYLE=BOLD,OBJECT=TEXT,ITEM=1,$
TYPE=HEADING, LINE=3, SIZE=7,FONT=ARIAL,STYLE=BOLD,OBJECT=FIELD,ITEM=1,$
TYPE=HEADING, LINE=4, SIZE=9,FONT=ARIAL,STYLE=BOLD,OBJECT=TEXT,ITEM=1,$
TYPE=HEADING, LINE=4, SIZE=7,FONT=ARIAL,STYLE=BOLD,OBJECT=FIELD,ITEM=1,$
TYPE=HEADING, LINE=5, SIZE=9,FONT=ARIAL,STYLE=BOLD,OBJECT=TEXT,ITEM=1,$
TYPE=HEADING, LINE=5, SIZE=7,FONT=ARIAL,STYLE=BOLD,OBJECT=FIELD,ITEM=1,$
TYPE=TITLE,STYLE=BOLD,FONT=ARIAL,SIZE=6,GRID=ON,BACKCOLOR=WHEAT,$
TYPE=DATA,FONT=ARIAL,SIZE=7,GRID=ON,$
TYPE=REPORT,COLUMN=COUNTRY, JUSTIFY=CENTER, LEFTGAP=.01,RIGHTGAP=.01,WRAP=0.9, $
TYPE=REPORT,COLUMN=CAR,JUSTIFY=CENTER,SQUEEZE=0.8,LEFTGAP=.01,RIGHTGAP=.01,WRAP=0.9,  $
TYPE=REPORT,COLUMN=MODEL, JUSTIFY=CENTER,SQUEEZE=0.5,LEFTGAP=.01,RIGHTGAP=.01, WRAP=0.9, $
TYPE=REPORT,COLUMN=TYPE, JUSTIFY=CENTER,SQUEEZE=0.5,LEFTGAP=.01,RIGHTGAP=.01,WRAP=0.9,  $
TYPE=REPORT,COLUMN=SEATS, JUSTIFY=CENTER,SQUEEZE=.9,LEFTGAP=.01,RIGHTGAP=.01, $
TYPE=REPORT,COLUMN=SALES, JUSTIFY=CENTER,SQUEEZE=0.5,LEFTGAP=.01,RIGHTGAP=.01, $
TYPE=REPORT,COLUMN=RETAIL_COST, JUSTIFY=CENTER,SQUEEZE=0.6,LEFTGAP=.01,RIGHTGAP=.01, $
TYPE=GRANDTOTAL,STYLE=BOLD,FONT=ARIAL,SIZE=7,GRID=ON,$
TYPE=SUBTOTAL,STYLE=BOLD,FONT=ARIAL,SIZE=7,GRID=ON,$
TYPE=SUBHEAD,STYLE=BOLD,FONT=ARIAL,SIZE=7,GRID=ON,$
ENDSTYLE

ON TABLE PCHOLD PDF  HTML 
END

TABLE FILE CAR
SUM SEATS 
BY CAR
ON TABLE PCHOLD FORMAT PDF  CLOSE
END

Can this be done ?

-Saurabh
Solaris, WebFocus v716

This message has been edited. Last edited by: Kerry,

You have several options,

1. Create your own headings with a SUBHEAD on the appropriate sort field.
2. Use a COMPOUND PDF document, and you can create a loop for each TYPE, and use SET COMPOUND = NOBREAK.

The second options is more trick, as you may not know when the page will end and a TYPE may fall across two pages.

quote:

Create your own headings with a SUBHEAD on the appropriate sort field.

Can tell me what the code will be like ?

Here's an example:

TABLE FILE CAR
HEADING
"SAMPLE REPORT"
PRINT 
COUNTRY 
CAR 
MODEL 
TYPE 
SEATS 
SALES 
RETAIL_COST
BY TYPE AS 'CAR TYPE'
ON TYPE SUB-TOTAL 
ON TYPE SUBHEAD
"CAR TYPE <+0> COUNTRY <+0> CAR <+0> MODEL <+0> BODYTYPE <+0> SEATS <+0> SALES <+0> RETAIL COST"
"<TYPE"
ON  TYPE  NOSPLIT
ON TABLE SET PAGE-NUM OFF
ON TABLE SUBTOTAL SALES AS 'TOTAL SALES'

ON TABLE SET STYLE *
TYPE=REPORT, FONT=ARIAL, SIZE=8, ORIENTATION=LANDSCAPE, $

$ FOR HTML
TYPE=SUBHEAD, HEADALIGN=BODY, $

$ FOR PDF
TYPE=SUBHEAD, ITEM=1, POSITION=N1, COLOR=BLUE, $
TYPE=SUBHEAD, ITEM=2, POSITION=N2, COLOR=RED, $
TYPE=SUBHEAD, ITEM=3, POSITION=N3, $
TYPE=SUBHEAD, ITEM=4, POSITION=N4, $
TYPE=SUBHEAD, ITEM=5, POSITION=N5, $
TYPE=SUBHEAD, ITEM=6, POSITION=N6, $
TYPE=SUBHEAD, ITEM=7, POSITION=N7, $
TYPE=SUBHEAD, ITEM=7, POSITION=N8, $
ENDSTYLE
ON TABLE PCHOLD FORMAT PDF
END

Thank you very much --to both Waz and Francis for your responses.

The suggested code works ( I will add a grid and use it for my app)

This one is resolved.

-Saurabh