[CLOSED] subfoot and total lines is not aligned and extra space in PDF report
Hi
Iam facing an issue with Subtotal in my PDF report.An extra line is coming around the subtotal and grand total section.And the result for grand total and subtotal are not aligning in the same line.Please find the below the sample code. The sampleoutput is coming like below.
field1 field2 field3 ***********extra space here************* subtotal fiel1subtotal fiel2subtotal fiel3subtotal ***********extra space here************* Grandtotal Grandtotal1 Grandtotal2 Grandtotal3
the values for subtotal and grandtotal is not in the same line.
DEFINE FILE SSUPT V_DUMMY/I2 = ; V_REG_N/A41 = 'Region ' | EDIT(ALTN_REGN_REF_I, '$$$999'); END TABLE FILE SSUPT PRINT LOC_REF_I CATGNAME WTD_TOT_SHTG_A WTD_BTWN_SLS_A LY_TOT_SHTG_A' LY_BTWN_SLS_A COMPUTE CY_RATE/P15.2B=(WTD_TOT_SHTG_A/WTD_BTWN_SLS_A)*100; COMPUTE LY_RATE/P15.2B=(LY_TOT_SHTG_A/LY_BTWN_SLS_A)*100; COMPUTE BP_LY/P15.2B=((LY_TOT_SHTG_A/LY_BTWN_SLS_A)*100)-((WTD_TOT_SHTG_A/WTD_BTWN_SLS_A)*100); BY V_DUMMY NOPRINT BY V_REG_N NOPRINT ON V_REG_N RECOMPUTE WTD_TOT_SHTG_A WTD_BTWN_SLS_A LY_TOT_SHTG_A LY_BTWN_SLS_A CY_RATE LY_RATE BP_LY AS '' ON V_DUMMY SUMMARIZE AS 'GRAND TOTAL' ON TABLE PCHOLD FORMAT PDF ON TABLE SET HTMLCSS ON ON TABLE SET PAGE NOLEAD ON TABLE NOTOTAL ON TABLE SET STYLE * UNITS=IN, PAGESIZE='Letter', SQUEEZE=ON, ORIENTATION=LANDSCAPE,$ TYPE=REPORT, FONT='ARIAL', SIZE=10, GRID=OFF, COLOR='BLACK', BACKCOLOR='NONE', STYLE=NORMAL, $ TYPE=TITLE, BORDER=MEDIUM,BORDER-COLOR='WHITE', SIZE=9, BACKCOLOR=RGB(153 153 153), JUSTIFY=CENTER, COLOR='BLACK', STYLE=BOLD,$ TYPE=HEADING, SIZE=10, JUSTIFY=CENTER, STYLE=BOLD, HEADALIGN=BODY, COLOR='MAROON',$ TYPE=DATA,SIZE=9,BACKCOLOR=('WHITE' RGB(240 240 240)),JUSTIFY=RIGHT,$ TYPE=DATA,COLUMN=LOC_REF_I,JUSTIFY=LEFT,$ TYPE=SUBTOTAL,BY=V_REG_N,BACKCOLOR=RGB(180 180 180), STYLE=BOLD,SIZE=9,$ TYPE=SUBTOTAL,BY=V_DUMMY, COLOR='WHITE', BACKCOLOR=RGB(90 90 90), SIZE=9,$ ENDSTYLE END
Can some one please suggest.
Thanks in advance.This message has been edited. Last edited by: Kerry,
WebFocus 7.1.4 xp html,excel,pdf
March 31, 2011, 09:59 AM
DavSmith
This was solved in 7.6.11. The new SET command DROPBLNKLINE removes blank lines around subtotals/grand totals.
SET DROPBLNKLINE=ON
For earlier versions, use of Subfoots will do the trick:
TABLE FILE CAR
SUM SALES
BY COUNTRY
BY CAR
BY MODEL
ON COUNTRY SUBFOOT
"*Sub-Total <COUNTRY><+0><ST.SALES>"
ON TABLE SUBFOOT
"*Grand-Total <+0> <+0> <CT.SALES>"
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=SUBFOOT,STYLE=BOLD,HEADALIGN=BODY,$
TYPE=TABFOOTING,STYLE=BOLD,HEADALIGN=BODY,$
ENDSTYLE
In FOCUS since 1985 - WF 8.009/8.104 Win 8 Outputs: ALL of 'em! Adapters: Sql Server Teradata Oracle
April 01, 2011, 07:27 AM
souji
Thanks for the reply.I have used SET DROPBLNKLINE=ON command but it didnt help.I actually have % in my footing.Thats the reason i used recompute.
WebFocus 7.1.4 xp html,excel,pdf
April 01, 2011, 09:07 AM
mgrackin
Souji,
I think you are dealing with a common problem with SUBTOTAL/SUB-TOTAL/RECOMPUTE/SUMMARIZE row titles that occurs especially when you have a NOPRINT on your BY sort fields.
Read the following FocalPoint thread for some helpful information.
Mickey is correct. There must be something interfering with DROPBLNKLINE in your code. using the CAR database, I tried to make it break using a combinations of NOPRINT and Subtotal, Sub-total, Recompute, Summarize, etc but could not.
I suggest opening a case.
In FOCUS since 1985 - WF 8.009/8.104 Win 8 Outputs: ALL of 'em! Adapters: Sql Server Teradata Oracle
April 04, 2011, 07:50 AM
Tom Flynn
DROPBLNKLINE works on 7.6.11 and above, not, 7.1.4...
The problem is not with the DROPBLNKLINE. The problem is with the standard FOCUS behavior of placing values on a TOTAL line. If there isn't enough room on the same line for the value of the field for which the TOTALS are being calculated and the total values themselves, FOCUS will use two lines for the TOTAL information. Please check the link to the FocalPoint thread I included in my previous post. This will explain the issue in more detail.
DROPBLNKLINE is intended to simply eliminate blank lines, not force the TOTAL line to always appear on one line.