I have a report that that users can select data up to five levels deep. The top line of the header reflects their selection criteria. I contatenate the selection description and show it centered on one line in the header. I have the HTML and Excel 2K versions working by using HTML code to format the headers. However, I cannot get the PDF version to work correctly. It looks at my contatenated report description and treats it as up to five separate fields, and therefore the formatting in not correct. I create the contatentated field as follows:

-SET &HEAD1TEXT = 'TOTAL COMPANY';
-IF &C_BU EQ 'FOC_NONE' GOTO H_END;
-SET &HEAD1TEXT = -IF &EVP_1 EQ 'FOC_NONE' GOTO H_END;
-SET &HEAD1TEXT = '&HEAD1TEXT.EVAL' || ' - ' | -IF &EVP_2 EQ 'FOC_NONE' GOTO H_END;
-SET &HEAD1TEXT = '&HEAD1TEXT.EVAL' || ' - ' | -IF &EVP_3 EQ 'FOC_NONE' GOTO H_END;
-SET &HEAD1TEXT = '&HEAD1TEXT.EVAL' || ' - ' | -IF &EVP_4 EQ 'FOC_NONE' GOTO H_END;
-SET &HEAD1TEXT = '&HEAD1TEXT.EVAL' || ' - ' | -H_END  

Then my heading is as follows:

HEADING
"Company Name Inc. <+0>&HEAD1TEXT"
"Source: XXX <+0>&HEAD2TEXT"
"&DATEMDYY &TOD <+0>($ in Thousands)"
  

stylesheet used is as follows:

TYPE=HEADING, ITEM=1, MACRO=h-sml-norm-left,$
TYPE=HEADING, LINE=1, ITEM=2, MACRO=h-nml-bold-center,$
TYPE=HEADING, LINE=2, ITEM=2, MACRO=h-nml-norm-center,$
  

Macros are as follows:

DEFMACRO=h-nml-bold-center,
 STYLE=BOLD,
 WIDTH=7.00,
 JUSTIFY=CENTER,$
-*
DEFMACRO=h-nml-norm-center,
 WIDTH=7.00,
 JUSTIFY=CENTER,$
-*
DEFMACRO=h-sml-norm-left,
 SIZE=7,
 WIDTH=1.50,
 JUSTIFY=LEFT,$
-*
  

For some reason &HEAD2TEXT, which is build similarly to &HEAD1TEXT works as intended, but &HEAD1TEXT formats only the first part of the contatenation (the
What am I doing wrong? Thanks.

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

PROD: WebFOCUS 7.1.4 on Win 2003/Microsoft-IIS 6.0/ServletExec 4.2/JAVA version 1.5.0_09
DEV: WebFOCUS 7.6.1 on Win 2003/Microsoft-IIS 6.0/ServletExec 4.2/JAVA version 1.5.0_09
LOCAL: WebFOCUS 7.6.2 on Win XP SP2/Apache Tomcat 5.5.17/JAVA version 1.5.0_09

It appears to me that after each & is evaluated, you end up with two fields in

"Company Name Inc. <+0>&HEAD1TEXT"

You may want to change your stylesheet to read

TYPE=HEADING, LINE=1, OBJECT=FIELD, MACRO=h-nml-bold-center,$

Ken

I tried adding the OBJECT=FIELD .... I get the same results as before.

Interesting. My data bolded, but I still did end up with the spacing issue.

Part of your problem is with the way PDF displays data in headings when using concatenation. Even though the content of the data column could be one character, if the field is defined with 20 characters, you get the full 20 characters displayed.

For example, if you do the following:

TABLE FILE CAR
SUM SALES
BY CAR
ON CAR PAGE-BREAK
HEADING
"L1"
"L2 <CAR <+0 <CAR"
" "
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=REPORT, ORIENTATION=LANDSCAPE, $
DEFMACRO=h-nml-bold-center, STYLE=BOLD, WIDTH=7.00, JUSTIFY=CENTER,$
TYPE=HEADING,LINE=2, OBJECT=FIELD, MACRO=h-nml-bold-center, $
ENDSTYLE
END

You will see the two values of CAR spread out across the report. Now, if you do the following:

TABLE FILE CAR
SUM SALES
COMPUTE NEWCAR/A40 = {{ CAR || ' '} | CAR } ; NOPRINT
BY CAR
ON CAR PAGE-BREAK

HEADING
"L1"
"L2 <NEWCAR"
" "

ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=REPORT, ORIENTATION=LANDSCAPE, $
DEFMACRO=h-nml-bold-center, STYLE=BOLD, WIDTH=7.00, JUSTIFY=CENTER,$
TYPE=HEADING,LINE=2, OBJECT=FIELD, MACRO=h-nml-bold-center, $
ENDSTYLE
END

The two values for car are near each other.

It is along these lines that you need to be thinking.

Ken

Matthew,

Is this the same problem you are getting?

-SET &CNTRYCAR = -SET &CNTRYCARBODY = -SET &COUNTRY = '-SET &CAR = '-SET &BODYTYPE = '-SET &HEADING01 = 'LEFT<+0>-SET &HEADING02 = 'RIGTH<+0>-SET &HEADING03 = 'CENTER<+0>
TABLE FILE CAR
PRINT
     RETAIL_COST AS ''
     DEALER_COST AS ''
BY
     COUNTRY NOPRINT
BY
     CAR NOPRINT
BY
     BODYTYPE NOPRINT
ON BODYTYPE SUBHEAD
"LEFT<+0>&COUNTRY.EVAL"
"RIGTH<+0>&CNTRYCAR.EVAL"
"CENTER<+0>&CNTRYCARBODY.EVAL"
-*"LEFT<+0>&COUNTRY.EVAL"
-*"RIGTH<+0>&COUNTRY.EVAL<+0>&CAR.EVAL"
-*"CENTER<+0>&COUNTRY.EVAL<+0>&CAR.EVAL<+0>&BODYTYPE.EVAL"
-*"&HEADING01"
-*"&HEADING02"
-*"&HEADING03"
-*"LEFT<+0>-*"RIGTH<+0>-*"CENTER<+0>ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
UNITS=IN,PAGESIZE='LEGAL',SQUEEZE=ON,ORIENTATION=LANDSCAPE,$

TYPE=REPORT,FONT='ARIAL',SIZE=8,COLOR='BLACK',BACKCOLOR='NONE',STYLE=NORMAL,$
TYPE=SUBHEAD,ITEM=1,WIDTH=1,JUSTIFY=LEFT,$
TYPE=SUBHEAD,ITEM=2,WIDTH=1,JUSTIFY=LEFT,$
TYPE=SUBHEAD,ITEM=3,WIDTH=1,JUSTIFY=LEFT,$
TYPE=SUBHEAD,ITEM=4,WIDTH=1,JUSTIFY=LEFT,$
TYPE=SUBHEAD,LINE=2,ITEM=1,WIDTH=1,JUSTIFY=RIGHT,$
TYPE=SUBHEAD,LINE=2,ITEM=2,WIDTH=1,JUSTIFY=RIGHT,$
TYPE=SUBHEAD,LINE=2,ITEM=3,WIDTH=1,JUSTIFY=RIGHT,$
TYPE=SUBHEAD,LINE=2,ITEM=4,WIDTH=1,JUSTIFY=RIGHT,$
TYPE=SUBHEAD,LINE=2,ITEM=1,WIDTH=1,JUSTIFY=CENTER,$
TYPE=SUBHEAD,LINE=2,ITEM=2,WIDTH=1,JUSTIFY=CENTER,$
TYPE=SUBHEAD,LINE=2,ITEM=3,WIDTH=1,JUSTIFY=CENTER,$
TYPE=SUBHEAD,LINE=2,ITEM=4,WIDTH=1,JUSTIFY=CENTER,$
ENDSTYLE
END

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

If I was correct in recreating your problem here is the reason why it happened.


When using
I'm guessing this is what you want.

-SET &COUNTRY = -SET &CNTRYCAR = -SET &CNTRYCARBODY = 
DEFINE FILE CAR
FIELD1/A100 = COUNTRY;
FIELD2/A100 = COUNTRY || ' - ' || CAR;
FIELD3/A100 = COUNTRY || ' - ' || CAR || ' - ' || BODYTYPE;
END

TABLE FILE CAR
PRINT
     RETAIL_COST AS ''
     DEALER_COST AS ''
BY
     COUNTRY NOPRINT
BY
     CAR NOPRINT
BY
     BODYTYPE NOPRINT
HEADING
"LEFT<+0>"RIGTH<+0>"CENTER<+0>-*"LEFT<+0>&COUNTRY.EVAL"
-*"RIGTH<+0>&CNTRYCAR.EVAL"
-*"CENTER<+0>&CNTRYCARBODY.EVAL"
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
UNITS=IN,PAGESIZE='LEGAL',SQUEEZE=ON,ORIENTATION=LANDSCAPE,$

TYPE=REPORT,FONT='ARIAL',SIZE=8,COLOR='BLACK',BACKCOLOR='NONE',STYLE=NORMAL,$
TYPE=HEADING,LINE=1,ITEM=1,JUSTIFY=LEFT,WIDTH=1,STYLE=NORMAL,$
TYPE=HEADING,LINE=1,ITEM=2,JUSTIFY=LEFT,WIDTH=7,STYLE=BOLD,SIZE=8,$
-*TYPE=HEADING,LINE=1,ITEM=2,SIZE=8,STYLE=BOLD,$
-*TYPE=HEADING,LINE=1,ITEM=3,SIZE=8,STYLE=BOLD,$
-*TYPE=HEADING,LINE=1,ITEM=4,SIZE=8,STYLE=BOLD,$

TYPE=HEADING,LINE=2,ITEM=1,JUSTIFY=RIGHT,WIDTH=1,STYLE=NORMAL,$
TYPE=HEADING,LINE=2,ITEM=2,JUSTIFY=RIGHT,WIDTH=7,STYLE=UNDERLINE,SIZE=9,$
-*TYPE=HEADING,LINE=2,ITEM=2,SIZE=9,STYLE=UNDERLINE,$
-*TYPE=HEADING,LINE=2,ITEM=3,SIZE=9,STYLE=UNDERLINE,$
-*TYPE=HEADING,LINE=2,ITEM=4,SIZE=9,STYLE=UNDERLINE,$

TYPE=HEADING,LINE=3,ITEM=1,JUSTIFY=CENTER,WIDTH=1,STYLE=NORMAL,$
TYPE=HEADING,LINE=3,ITEM=2,JUSTIFY=CENTER,WIDTH=7,STYLE=BOLD+UNDERLINE,SIZE=10,$
-*TYPE=HEADING,LINE=3,ITEM=2,SIZE=10,STYLE=BOLD+UNDERLINE,$
-*TYPE=HEADING,LINE=3,ITEM=3,SIZE=10,STYLE=BOLD+UNDERLINE,$
-*TYPE=HEADING,LINE=3,ITEM=4,SIZE=10,STYLE=BOLD+UNDERLINE,$
-*TYPE=HEADING,LINE=3,ITEM=5,SIZE=10,STYLE=BOLD+UNDERLINE,$
-*TYPE=HEADING,LINE=3,ITEM=6,SIZE=10,STYLE=BOLD+UNDERLINE,$
ENDSTYLE
END

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

The last solution did work. Thank you for your help.