PCHOLD FORMAT PDF OPEN NOBREAK

August 05, 2004, 04:55 PM

<Vipul>

Has anyone seen this behave wierd. I have a program which is like this:

TABLE FILE XXX
SUM...

ON TABLE FORMAT PDF OPEN NOBREAK
ON TABLE SET STYLE *
-INCLUDE STYLEV02IR.FEX
ENDSTYLE
END
-RUN
-LOOP

TABLE FILE YYY
SUM...

ON TABLE FORMAT PDF NOBREAK
ON TABLE SET STYLE *
-INCLUDE STYLEV02IR.FEX
ENDSTYLE

END
-RUN
-GOTO LOOP
TABLE FILE ZZZ
SUM...

ON TABLE FORMAT PDF CLOSE
ON TABLE SET STYLE *
-INCLUDE STYLEV02IR.FEX
ENDSTYLE
END
-RUN
The NOBREAK give me problem. With nobreak I get that the file is damaged but if I remove the nobreak I get the report but...that's not what i want.

Any Ideas.

Vipul

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

August 05, 2004, 06:05 PM

<Pietro De Santis>

It's really weird. I had a demo program I created a while ago that used to work, it does not work now. Might be a bug since we've upgraded since I wrote the program.

Oddly enough, the sample program provided by IBI documentation works.

-* From: http://techsupport.informationbuilders.com/ibase/master..._pagelayout13.htm />
-* Report 1

SET PAGE-NUM=OFF
TABLE FILE CENTORD
HEADING
"Sales Report"
" "
SUM LINEPRICE
BY PRODCAT
ON TABLE SET STYLE *
TYPE=HEADING, SIZE=18, $
ENDSTYLE
ON TABLE PCHOLD FORMAT PDF OPEN NOBREAK
END

-* Report 2

TABLE FILE CENTORD
HEADING
"Inventory Report"
" "
SUM QUANTITY
BY PRODCAT
ON TABLE SET STYLE *
TYPE=HEADING, SIZE=18, $
ENDSTYLE
ON TABLE PCHOLD FORMAT PDF NOBREAK
END

-* Report 3

TABLE FILE CENTORD
HEADING
"Cost of Goods Sold Report"
" "
SUM LINE_COGS
BY PRODCAT
ON TABLE SET STYLE *
TYPE=HEADING, SIZE=18, $
ENDSTYLE
ON TABLE PCHOLD FORMAT PDF CLOSE
END

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

August 05, 2004, 06:11 PM

<Vipul>

Yes I did try the sample from IBI and it worked, but mine does not if I put the NOBREAK.

Vipul

August 05, 2004, 07:46 PM

Roland

I recall having played around with this in earlier release (i guess 436). I also recall having made the expierience, that it only worked properly, if the compound document was not more than ONE page. Otherwise it either resulted in nothing or a mess or having confusions about applying styles. And also you have to make sure that the ORIENTATION on every doc embedded in the compound one was the same, i.e. no mixing of LANDSCAPE and PORTRAIT.
For me it turned out to be a safer way not to use nobreak !
But I also never tried it again in the latest releases.

August 05, 2004, 07:54 PM

<Vipul>

Thanks Ronald,

This is what I use all thro the reports.
TYPE=REPORT, PAGESIZE=A4 , ORIENTATION=PORTRAIT , SQUEEZE=ON ,$

Vipul

August 05, 2004, 09:18 PM

<Pietro De Santis>

This works:

-SET &ECHO=ALL;

SET PAGE =
NOPAGE
-RUN

SET COMPOUND = OPEN NOBREAK
-RUN

TABLE FILE CAR
SUM SALES

BY CAR
ACROSS COUNTRY

HEADING
"Sales Report"

" "
ON TABLE PCHOLD FORMAT
PDF

ON TABLE SET STYLE *
UNITS=IN, PAGESIZE='Letter', SQUEEZE=ON, ORIENTATION=LANDSCAPE, $

TYPE=HEADING, SIZE=13, $
TYPE=REPORT, FONT='Arial', SIZE=11, COLOR=RED, $
ENDSTYLE
END
-RUN

SET COMPOUND = NOBREAK
-RUN

TABLE FILE CAR
SUM DEALER_COST
BY MODEL
ACROSS COUNTRY

HEADING
"Inventory Report"
" "
ON TABLE PCHOLD FORMAT PDF

ON TABLE SET STYLE *
UNITS=IN, PAGESIZE='Letter', SQUEEZE=ON, ORIENTATION=LANDSCAPE, $
TYPE=HEADING, SIZE=13, $
TYPE=REPORT,
FONT='Arial', SIZE=11, COLOR=GREEN, $

ENDSTYLE
END
-RUN<
-SET &TEMPDIR = 'C:\Temp\';
-SET &GIFFILE=&TEMPDIR || 'CARGR.GIF';
SET COMPOUND =
CLOSE
-RUN
TABLE FILE CAR
PRINT CAR
HEADING
"Car List"
" "
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET PAGE OFF<
ON TABLE SET STYLE *

UNITS=IN, PAGESIZE='Letter', SQUEEZE=ON, ORIENTATION=LANDSCAPE, $

TYPE=HEADING, SIZE=13, $
TYPE=REPORT, FONT='Arial', SIZE=11, COLOR=BLUE, $

ENDSTYLE
END
-RUN
I did notice that if the last (closing)
report does not create any output, the
compound PDF file does not get closed and hence the error.

I hope this helps.

Pietro.

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