Hi

I am working on a complex report with lots of calculations and I am at the end trying to solve an issue. I am not so good with styling, need some help from you guys.

 
TABLE FILE CAR
BY COUNTRY
SUM 
COMPUTE SALES_TH/D20.2 = SALES/1000; NOPRINT
COMPUTE SALES_RND/D20.2 = SALES_TH * 1000; NOPRINT
PRINT SALES NOPRINT
ON COUNTRY SUBFOOT
"Sales: <ST.SALES    Sales rounded: <ST.SALES_RND"
ON TABLE PCHOLD FORMAT HTML
END

Sample in PDF:
Sales: 12000 Sales rounded:               12,000.00

My code is similar to this. If I run this report in HTML, everything is fine but in PDF, space shows up between text and actual number in the footing. this is because the format of the field is D20.2 and its creating all those spaces to make it up D20. How can I avoid those spaces in PDF? I cannot change the format of the field and I calculate subtotal directly in the footing using ST. prefix operator. Please let me know of any suggestions.

thank you..

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

You may have to have two sections in your report, one for HTML and the other for PDF.

I found pre-total the field, then convert it to alpha (FTOA) and left justify it with LJUST.

  
TABLE FILE CAR
SUM 
COMPUTE SALES_TH/D20.2 = SALES/1000; NOPRINT
COMPUTE SALES_RND/D20.2 = SALES_TH * 1000; NOPRINT
COMPUTE RSALES_A/A30   = LJUST(30,FTOA(SALES_RND,'(D20.2)','A30'),'A30'); NOPRINT
BY COUNTRY
ON COUNTRY SUBFOOT
"Sales: <ST.SALES    Sales rounded: <RSALES_A "
" "
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=SUBFOOT,
	 LINE=1,
	 OBJECT=FIELD,
	 ITEM=1,
	 JUSTIFY=LEFT,
$
TYPE=SUBFOOT,
	 LINE=1,
	 OBJECT=FIELD,
	 ITEM=2,
	 JUSTIFY=LEFT,
	 BACKCOLOR='YELLOW',
$
ENDSTYLE
END

Thanks for the reply Mary.
I am trying to eliminate the space by not converting it to alpha and not calculating the subtotal ahead

With HTML the rule is that HTML suppresses multiple spaces.
Unless you say ON TABLE SET SHOWBLANKS ON.
That’s the way HTML works.
PDF does not suppress multiple spaces.
Option is to set the width for the column in the style

quote:

Originally posted by JG:
With HTML the rule is that HTML suppresses multiple spaces.
Unless you say ON TABLE SET SHOWBLANKS ON.
That’s the way HTML works.
PDF does not suppress multiple spaces.
Option is to set the width for the column in the style

Hi JG

I am trying this but does not seem to work.

 

TABLE FILE CAR
BY COUNTRY
SUM 
COMPUTE SALES_TH/D20.2 = SALES/1000; NOPRINT
COMPUTE SALES_RND/D20.2 = SALES_TH * 1000; NOPRINT
ON COUNTRY SUBFOOT
"Sales: <ST.SALES    Sales rounded: <ST.SALES_RND"
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=8,
$
TYPE=TITLE,
     STYLE=BOLD,
$
TYPE=SUBFOOT,
     LINE=1,
	 OBJECT=FIELD,
         ITEM=1,
	 WIDTH=0.5000,
	 JUSTIFY=LEFT,
$
ENDSTYLE
END
 

quote:

TYPE=SUBFOOT

you mean you want something like this

TYPE=SUBFOOT,ITEM=1,WIDTH=0.3000,JUSTIFY=LEFT,$
TYPE=SUBFOOT,ITEM=2,WIDTH=0.5000,JUSTIFY=LEFT,$
TYPE=SUBFOOT,ITEM=3,WIDTH=0.3000,JUSTIFY=LEFT,$
TYPE=SUBFOOT,ITEM=4,WIDTH=0.5000,JUSTIFY=LEFT,$

Try this code:

 
TABLE FILE CAR
BY COUNTRY
SUM 
COMPUTE SALES_TH/D20.2 = SALES/1000; NOPRINT
COMPUTE SALES_RND/D20.2 = SALES_TH * 1000; NOPRINT
ON COUNTRY SUBFOOT
"<+0>Sales: <ST.SALES    <+0>Sales rounded: <ST.SALES_RND"
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=8,
$
TYPE=TITLE,
     STYLE=BOLD,
$
TYPE=SUBFOOT,
     LINE=1,
	 OBJECT=FIELD,
     ITEM=1,
	 WIDTH=0.5000,
	 JUSTIFY=LEFT,
$
TYPE=SUBFOOT,
     LINE=1,
	 OBJECT=FIELD,
     ITEM=2,
	 WIDTH=0.5000,
	 JUSTIFY=LEFT,
$
ENDSTYLE
END

Its working fine........

Hi Aravind

I still see the space.

Tank you..

quote:

Originally posted by SriAravind:
Try this code:

 
TABLE FILE CAR
BY COUNTRY
SUM 
COMPUTE SALES_TH/D20.2 = SALES/1000; NOPRINT
COMPUTE SALES_RND/D20.2 = SALES_TH * 1000; NOPRINT
ON COUNTRY SUBFOOT
"<+0>Sales: <ST.SALES    <+0>Sales rounded: <ST.SALES_RND"
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=8,
$
TYPE=TITLE,
     STYLE=BOLD,
$
TYPE=SUBFOOT,
     LINE=1,
	 OBJECT=FIELD,
     ITEM=1,
	 WIDTH=0.5000,
	 JUSTIFY=LEFT,
$
TYPE=SUBFOOT,
     LINE=1,
	 OBJECT=FIELD,
     ITEM=2,
	 WIDTH=0.5000,
	 JUSTIFY=LEFT,
$
ENDSTYLE
END

Its working fine........

quote:

I am trying to eliminate the space by not converting it to alpha and not calculating the subtotal ahead

I don't think you can easily escape the conversion to alpha as Mary suggested ... you know that styling poses peculiar challenges.

However, you may not need to precalculate and carry a subtotal. Just do a RECAP before your subfoot, create an alpha field there with the subtotal calculation you need and use it in the SUBFOOT instead.

TABLE FILE CAR
BY COUNTRY
SUM 
COMPUTE SALES_TH/D20.2 = SALES/1000; NOPRINT
COMPUTE SALES_RND/D20.2 = SALES_TH * 1000; NOPRINT
PRINT SALES NOPRINT

ON COUNTRY RECAP
T_SALES_RND/A25 = SQUEEZ(25, FTOA(SALES_TH * 1000, '(D20.2)', T_SALES_RND), T_SALES_RND);

ON COUNTRY SUBFOOT
"Sales: <ST.SALES    Sales rounded: <T_SALES_RND>"
ON TABLE PCHOLD FORMAT PDF

ON TABLE SET STYLE *
TYPE=SUBFOOT, BY=COUNTRY, OBJECT=FIELD, ITEM=2, JUSTIFY=LEFT, COLOR=RED, $
ENDSTYLE
END

Caveat: you will lose the right alignment of those total values across the multiple created SUBFOOT's.

This may be an issue with the version....I'm using 7.6.11 version and its working there....
Can someone check for other versions also????

quote:

Originally posted by BI_Developer:
Hi Aravind

I still see the space.

Tank you..

quote:

Originally posted by SriAravind:
Try this code:

 
TABLE FILE CAR
BY COUNTRY
SUM 
COMPUTE SALES_TH/D20.2 = SALES/1000; NOPRINT
COMPUTE SALES_RND/D20.2 = SALES_TH * 1000; NOPRINT
ON COUNTRY SUBFOOT
"<+0>Sales: <ST.SALES    <+0>Sales rounded: <ST.SALES_RND"
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=8,
$
TYPE=TITLE,
     STYLE=BOLD,
$
TYPE=SUBFOOT,
     LINE=1,
	 OBJECT=FIELD,
     ITEM=1,
	 WIDTH=0.5000,
	 JUSTIFY=LEFT,
$
TYPE=SUBFOOT,
     LINE=1,
	 OBJECT=FIELD,
     ITEM=2,
	 WIDTH=0.5000,
	 JUSTIFY=LEFT,
$
ENDSTYLE
END

Its working fine........

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