[SOLVED] Compound PDF error on Page <ibi-page-number/> of <ibi-total-pages/>
I am having some issue on compound PDF report on WF Server 8.1.05.
The problem is on: A)
OBJECT=STRING, NAME='Page', TEXT='Page <ibi-page-number/> of <ibi-total-pages/>', POSITION=(+545 50), MARKUP=OFF,
Result is:
Page <ibi-page-number
B) OBJECT=STRING, NAME='Prog', TEXT='Prog: advr0038', POSITION=(+545 750), MARKUP=OFF, Result is: Pr
It works fine on my APP Studio 8.1.05
SET CDN = ON
SET NODATA = 0
SET ASNAMES = ON
SET EMPTYCELLS = OFF
SET CENT-ZERO = ON
SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT PDF AS CAR
UNITS=PTS, $
SECTION=section1, LAYOUT=ON, METADATA='5^5^5^5^4', MERGE=OFF, ORIENTATION=PORTRAIT, PAGESIZE=LETTER, SHOW_GLOBALFILTER=OFF, $
PAGELAYOUT=ALL, $
COMPONENT=HEADER, TYPE=REPORT, POSITION=(7 7), DIMENSION=(* *), $
OBJECT=STRING, NAME='Page', TEXT='Page <ibi-page-number/> of <ibi-total-pages/>', POSITION=(+545 50), MARKUP=OFF,
WRAP=ON, DIMENSION=(6.0 0.9) FONT='FORD CE BLACK', COLOR=RGB(128 128 128), STYLE=BOLD, SIZE=6, $
OBJECT=STRING, NAME='Prog', TEXT='Prog: advr0038', POSITION=(+545 750), MARKUP=OFF,
WRAP=ON, DIMENSION=(6.0 0.9) FONT='FORD CE BLACK', COLOR=RGB(128 128 128), STYLE=BOLD, SIZE=6, $
PAGELAYOUT=1, NAME='advr0038', text='advr0038', TOC-LEVEL=1, TOPMARGIN=10, ORIENTATION=PORTRAIT, $
COMPONENT='report1', TEXT='report1', TOC-LEVEL=2, POSITION=(10 65), DIMENSION=(* *), $
COMPONENT='report2', TEXT='report2', TOC-LEVEL=2, POSITION=(+80.00 +45.00), DIMENSION=(* *), RELATIVE-TO='report1', RELATIVE-POINT=BOTTOM-LEFT, POSITION-POINT=TOP-LEFT, $
END
SET COMPONENT=HEADER
TABLE FILE CAR
HEADING
"PARTICIPACION & VOLUMEN"
""
"Empresa: FORD MOTOR DE VENEZUELA, S.A"
"&DATEDwMtrYY &TOD"
BY COUNTRY NOPRINT
IF READLIMIT EQ 1
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET STYLE *
$
TYPE=REPORT,
IMAGE=ford_logo.jpg,
SIZE=(1.000000 0.291667),
$
TYPE=HEADING, FONT="FORD CE BLACK", $
TYPE=HEADING, POSITION=1.05, $
TYPE=HEADING, LINE=1, SIZE=12, STYLE='BOLD', JUSTIFY=CENTER, $
TYPE=HEADING, LINE=3, SIZE=8, JUSTIFY=LEFT, $
TYPE=HEADING, LINE=4, SIZE=6, JUSTIFY=RIGHT, $
END
SET COMPONENT='report1'
TABLE FILE CAR
SUM SALES
BY COUNTRY
HEADING
"Period: TEST"
ON TABLE SUBFOOT
"testing"
"VALUE - I just want backcolor on ITEM=1 (VALUE)"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
TYPE=REPORT, SIZE=7, $
TYPE=TITLE, SIZE= 7, $
TYPE=DATA, SIZE=6, $
TYPE=ACROSSVALUE, SIZE=8, $
TYPE=HEADING, JUSTIFY=LEFT, SIZE=9, $
TYPE=HEADING, LINE=4, SIZE=8, JUSTIFY=RIGHT, $
TYPE=TABFOOTING, LINE=1, BORDER-TOP = LIGHT, $
TYPE=TABFOOTING, LINE=2, ITEM=1, COLOR='BLUE', BACKCOLOR='GREY', STYLE=BOLD, BORDER-TOP = LIGHT, $
ENDSTYLE
END
-RUN
SET COMPONENT='report2'
TABLE FILE CAR
SUM SALES
BY CAR
ON TABLE SUBFOOT
"Powered by VESIR"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
TYPE=REPORT, SIZE=8, $
TYPE=TITLE, SIZE= 8, $
TYPE=DATA, SIZE=8, $
TYPE=ACROSSVALUE, SIZE=8, $
TYPE=HEADING, JUSTIFY=LEFT, SIZE=9, $
TYPE=HEADING, LINE=4, SIZE=8, JUSTIFY=RIGHT, $
TYPE=TABFOOTING, LINE=1, SIZE=8, BORDER-TOP = LIGHT, $
END
SET COMPONENT='report1'
TABLE FILE CAR
SUM SALES
BY COUNTRY
HEADING
"Period: TEST"
ON TABLE SUBFOOT
"testing"
"VALUE<+0> - I just want backcolor on ITEM=1 (VALUE)"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
-* INCLUDE = endeflt,$
TYPE=REPORT, SIZE=7, $
TYPE=TITLE, SIZE= 7, $
TYPE=DATA, SIZE=6, $
TYPE=ACROSSVALUE, SIZE=8, $
TYPE=HEADING, JUSTIFY=LEFT, SIZE=9, $
TYPE=HEADING, LINE=4, SIZE=8, JUSTIFY=RIGHT, $
TYPE=TABFOOTING, LINE=1, BORDER-TOP = LIGHT, $
TYPE=TABFOOTING, LINE=2, ITEM=1, COLOR='BLUE', BACKCOLOR='GREY', STYLE=BOLD, BORDER-TOP = LIGHT, JUSTIFY=LEFT,$
ENDSTYLE
END
-RUN
I'm only in 8007... But it works (after I removed the Ford logo the INCLUDE = endeflt...
In FOCUS Since 1983 ~ from FOCUS to WebFOCUS. Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
February 14, 2016, 04:45 PM
Waz
Seems to be working here on 8.1.04.
Page 1 or 1 at the top and Prog: advr0038 at the bottom
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
February 16, 2016, 10:33 AM
jcannavo
Hello Ricardo,
I ran your code in Dev Studio on 8105 and everything seemed to work fine (I also removed the Ford logo and updated endeflt reference to match our path).
Joe
JC WebFOCUS Dev Studio / App Studio 8.2.01 Windows 7
February 18, 2016, 01:19 PM
Ricardo Augusto
jcannavo, the problem happens when run it from WebFOCUS 8105 Server. Can you test it there?
It works on my APP Studio too.
Thanks
WebFOCUS 8.1.05 / APP Studio
February 23, 2016, 07:39 AM
Ricardo Augusto
Anyone using 8105 there?
WebFOCUS 8.1.05 / APP Studio
February 26, 2016, 12:11 PM
Ricardo Augusto
WebFOCUS 8.1.05 / APP Studio
March 28, 2016, 10:38 AM
<Emily McAllister>
Hello,
I ran your code in my own installation of 8.1.05 and did not have any issue. I am not sure why this is happening to you. What GEN of 8.1.05 do you have installed?
Emily McAllister Focal Point Moderator
March 28, 2016, 12:01 PM
Ricardo Augusto
quote:
Emily McAllister
Hi,
I am able to run it under my APP Studio 8.1.05.
I am still getting that weird thing on Page ibi-page-number/> of ibi-total-pages/> and other object=string when running this code on WebFOCUS Reporting Server:
Edition: WebFOCUS Product Release: 8.1 Service Pack: 0.5 Build Version: branch8105m Build/GEN Number: 2 Build/GEN Date: September 25,2015 8:55:09 am EDT Application Server: Apache Tomcat/7.0.33
