Field Formatting in Report Headers

June 28, 2011, 09:41 AM

I have placed a defined field from my report in my report header. The field is formatted as packed numeric with comma inclusion and floating dollar sign (P22.2C!D) but when I place the field in the report header the comma inclusion and floating dollar is dropped. I've tried <+0> in front of the field in the header and can't get it to work.

Any ideas?

Thanks in advance for helping me out on this!

June 28, 2011, 10:07 AM

Francis Mariani

It seems to work in this test:

DEFINE FILE CAR
NUMBER1/P22.2C!D = DEALER_COST * 123.45; 
END

TABLE FILE CAR
SUM
SALES
BY COUNTRY

ON TABLE SUBHEAD
"REPORT HEADING: <NUMBER1"

HEADING
"PAGE HEADING: <NUMBER1"
END

I see "PAGE HEADING: $4,672,952.85" in the page heading.

June 28, 2011, 10:17 AM

Prarie

Can you post your code please.

June 30, 2011, 02:30 PM

kadkins

 
-* File rpt2_avg_basketsize_web.fex


-****************************************
-* kadkins 05/25/2011                   *
-****************************************

-INCLUDE setuser.fex

DEFINE FILE TRANSHISTORY
d_today/YYMD=&YYMD;
d_trans1/YYMD=DATEADD(d_today,'D',-1);
d_trans3/YYMD=DATEADD(d_today,'D',-3);
d_trans7/YYMD=DATEADD(d_today,'D',-7);
d_trans8/YYMD=DATEADD(d_today,'D',-8);
d_trans10/YYMD=DATEADD(d_today,'D',-10);
d_trans14/YYMD=DATEADD(d_today,'D',-14);
d_transdate/YYMD=HDATE(TRANSHISTORY.TRANSHISTORY.TRANSACTIONDATE, 'YYMD');
d_cvtcust/A20=EDIT(TRANSHISTORY.TRANSHISTORY.CUSTOMERID, '99999999999999999999');
d_trimcust/A9=TRIM('L', d_cvtcust, 20, '0', 11, 'A9');
d_ncust/I9=EDIT(d_trimcust);
d_debits/P22.2=
IF TRANSHISTORY.TRANSHISTORY.TRANSACTIONTYPE EQ '5' OR '16'
THEN 1* TRANSHISTORY.TRANSHISTORY.TRANSACTIONAMT
ELSE 0;
d_credits/P22.2=
IF TRANSHISTORY.TRANSHISTORY.TRANSACTIONTYPE EQ '4' OR '17'
THEN -1* TRANSHISTORY.TRANSHISTORY.TRANSACTIONAMT
ELSE 0;
d_netsales/P22.2=d_debits + d_credits;
END
TABLE FILE TRANSHISTORY
BY TOTAL COMPUTE d_basket/P22.2C!D = ( TOT.TRANSHISTORY.TRANSHISTORY.d_netsales ) / ( CNT.TRANSHISTORY.TRANSHISTORY.INVOICENUM ); NOPRINT
 AS 'Average Basket:'
HEADING
"Basket By Date: <+0>$<d_basket "
WHERE ( TRANSHISTORY.TRANSHISTORY.d_ncust GT 20000 ) AND ( TRANSHISTORY.TRANSHISTORY.d_transdate GT &d_transdate );
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=9,
     STYLE=UNDERLINE,
$
TYPE=TITLE,
     STYLE=BOLD,
$
TYPE=TABHEADING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=TABFOOTING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     SIZE=12,
     COLOR='BLUE',
     STYLE=BOLD,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=2,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=3,
     SIZE=12,
     STYLE=BOLD+UNDERLINE,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=FIELD,
     ITEM=1,
     SIZE=12,
     STYLE=BOLD+UNDERLINE,
$
TYPE=SUBHEAD,
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBFOOT,
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBTOTAL,
     BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
     SIZE=9,
$
TYPE=ACROSSTITLE,
     STYLE=BOLD,
$
TYPE=GRANDTOTAL,
     BACKCOLOR=RGB(210 210 210),
     STYLE=BOLD,
$
TYPE=REPORT,
     COLUMN=N1,
     SQUEEZE=1.430556,
$
ENDSTYLE
END

June 30, 2011, 02:42 PM

Francis Mariani

Seems to work:

TABLE FILE CAR
BY TOTAL COMPUTE d_basket/P22.2C!D = ( TOT.SALES ) / ( CNT.CAR ); NOPRINT
 AS 'Average Basket:'
HEADING
"Basket By Date: <+0><d_basket "

ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=9,
     STYLE=UNDERLINE,
$
TYPE=TITLE,
     STYLE=BOLD,
$
TYPE=TABHEADING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=TABFOOTING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     SIZE=12,
     COLOR='BLUE',
     STYLE=BOLD,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=2,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=3,
     SIZE=12,
     STYLE=BOLD+UNDERLINE,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=FIELD,
     ITEM=1,
     SIZE=12,
     STYLE=BOLD+UNDERLINE,
$
TYPE=SUBHEAD,
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBFOOT,
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBTOTAL,
     BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
     SIZE=9,
$
TYPE=ACROSSTITLE,
     STYLE=BOLD,
$
TYPE=GRANDTOTAL,
     BACKCOLOR=RGB(210 210 210),
     STYLE=BOLD,
$
TYPE=REPORT,
     COLUMN=N1,
     SQUEEZE=1.430556,
$
ENDSTYLE
END

Result in png image:

July 01, 2011, 08:49 AM

kadkins

But... it's not.