Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Spacing Issue with In Line Email Reporting <SOLVED>

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Spacing Issue with In Line Email Reporting <SOLVED>
 Login/Join
 
Platinum Member
posted
I am having an issue with a report that I send in-line having "double spacing". When I send the report as an attachment in HTML or PDF format, I do not get the extra spacing (the problem looks just like there is an extra blank line between each line of the report.
Why would it appear to have this extra spacing between each line of the report? If it helps for context, I am using Microsoft Outlook for e-mail.




You can see the code for my .fex below:

 SET LINES = 999999

DEFINE FILE EBRRPT_RPT_FLASH_EMAIL_ROLLUP_TBL
asofdatehdr/A21 = 'Results as of:       ' ;
HEADERLINE/A20 = IF DIVISION EQ 99 THEN 'TOTAL COMPANY' ELSE 'DIVISION ' | TRIM('L',EDIT(DIVISION),11,'0',1,'A11');
ytdhdr/A21 = 'YTD Reconciled Shrink' ;
ytdblank/A1 = ' ' ;
qtdhdr/A21 = 'QTD Reconciled Shrink' ;
qtdblank/A1 = ' ' ;
ptdhdr/A21 = 'PTD Reconciled Shrink' ;
ptdblank/A1 = ' ' ;
wtdhdr/A21 = 'WTD Reconciled Shrink' ;
wtdblank/A1 = ' ' ;
dayhdr/A21 = 'DAY Reconciled Shrink' ;
dayblank/A1 = ' ' ;

rptspace1/A1 = ' ' ;
rptspace2/A1 = ' ' ;
rptspace3/A1 = ' ' ;
rptspace4/A1 = ' ' ;
rptspace5/A1 = ' ' ;
rptspace6/A1 = ' ' ;
rptspace7/A1 = ' ' ;
rptspace8/A1 = ' ' ;
rptspace9/A1 = ' ' ;
rptspace10/A1 = ' ' ;

storeslabel/A18 =            'Stores:           ' ;
tyshrinklabel/A18 =          'TY Shrink:        ' ;
tysaleslabel/A18 =           'TY Sales:         ' ;
tyshrinkpctlabel/A18 =       'TY Shrink %:      ' ;
lyshrinkpctlabel/A18 =       'LY Shrink %:      ' ;
varbpslabel/A18 =            'Var Bps:          ' ;
optimizedpctlabel/A18 =      'Optimized %:      ' ;
vartooptlabel/A18 =          'VarToOpt:         ' ;
gapclosurelabel/A18 =        'Gap Closure:      ' ;
pctstoresimprovedlabel/A18 = '% Stores Improved:' ;
ytdtyratepct/D7.2%=EBRRPT_RPT_FLASH_EMAIL_ROLLUP_TBL.YTDTYRATE * 100;
ytdlyratepct/D7.2%=EBRRPT_RPT_FLASH_EMAIL_ROLLUP_TBL.YTDLYRATE * 100;
ytdoptratepct/D7.2%=EBRRPT_RPT_FLASH_EMAIL_ROLLUP_TBL.YTDOPTRATE * 100;
ytdgapclosurepct/D7.2%=EBRRPT_RPT_FLASH_EMAIL_ROLLUP_TBL.YTDGAPCLOSE * 100;
ytdimprovedpct/D7.2%=EBRRPT_RPT_FLASH_EMAIL_ROLLUP_TBL.YTDIMPROVED * 100;
qtdtyratepct/D7.2%=EBRRPT_RPT_FLASH_EMAIL_ROLLUP_TBL.QTDTYRATE * 100;
qtdlyratepct/D7.2%=EBRRPT_RPT_FLASH_EMAIL_ROLLUP_TBL.QTDLYRATE * 100;
qtdoptratepct/D7.2%=EBRRPT_RPT_FLASH_EMAIL_ROLLUP_TBL.QTDOPTRATE * 100;
qtdgapclosurepct/D7.2%=EBRRPT_RPT_FLASH_EMAIL_ROLLUP_TBL.QTDGAPCLOSE * 100;
qtdimprovedpct/D7.2%=EBRRPT_RPT_FLASH_EMAIL_ROLLUP_TBL.QTDIMPROVED * 100;
ptdtyratepct/D7.2%=EBRRPT_RPT_FLASH_EMAIL_ROLLUP_TBL.PTDTYRATE * 100;
ptdlyratepct/D7.2%=EBRRPT_RPT_FLASH_EMAIL_ROLLUP_TBL.PTDLYRATE * 100;
ptdoptratepct/D7.2%=EBRRPT_RPT_FLASH_EMAIL_ROLLUP_TBL.PTDOPTRATE * 100;
ptdgapclosurepct/D7.2%=EBRRPT_RPT_FLASH_EMAIL_ROLLUP_TBL.PTDGAPCLOSE * 100;
ptdimprovedpct/D7.2%=EBRRPT_RPT_FLASH_EMAIL_ROLLUP_TBL.PTDIMPROVED * 100;
wtdtyratepct/D7.2%=EBRRPT_RPT_FLASH_EMAIL_ROLLUP_TBL.WTDTYRATE * 100;
wtdlyratepct/D7.2%=EBRRPT_RPT_FLASH_EMAIL_ROLLUP_TBL.WTDLYRATE * 100;
wtdoptratepct/D7.2%=EBRRPT_RPT_FLASH_EMAIL_ROLLUP_TBL.WTDOPTRATE * 100;
wtdgapclosurepct/D7.2%=EBRRPT_RPT_FLASH_EMAIL_ROLLUP_TBL.WTDGAPCLOSE * 100;
wtdimprovedpct/D7.2%=EBRRPT_RPT_FLASH_EMAIL_ROLLUP_TBL.WTDIMPROVED * 100;
daytyratepct/D7.2%=EBRRPT_RPT_FLASH_EMAIL_ROLLUP_TBL.DAYTYRATE * 100;
daylyratepct/D7.2%=EBRRPT_RPT_FLASH_EMAIL_ROLLUP_TBL.DAYLYRATE * 100;
dayoptratepct/D7.2%=EBRRPT_RPT_FLASH_EMAIL_ROLLUP_TBL.DAYOPTRATE * 100;
daygapclosurepct/D7.2%=EBRRPT_RPT_FLASH_EMAIL_ROLLUP_TBL.DAYGAPCLOSE * 100;
dayimprovedpct/D7.2%=EBRRPT_RPT_FLASH_EMAIL_ROLLUP_TBL.DAYIMPROVED * 100;
LOADDAY/A2=SUBSTR(11,EDIT(EBRRPT_RPT_FLASH_EMAIL_ROLLUP_TBL.RUNDATE),10,11,2,LOADDAY);
LOADMONTH/A2=SUBSTR(11,EDIT(EBRRPT_RPT_FLASH_EMAIL_ROLLUP_TBL.RUNDATE),8,9,2,LOADMONTH);
LOADYEAR/A4=SUBSTR(11,EDIT(EBRRPT_RPT_FLASH_EMAIL_ROLLUP_TBL.RUNDATE),4,7,4,LOADYEAR);
RUNDATE/A10=LOADMONTH || '-' || LOADDAY || '-' || LOADYEAR;
END

TABLE FILE EBRRPT_RPT_FLASH_EMAIL_ROLLUP_TBL
HEADING
"<HEADERLINE"
SUM asofdatehdr             AS ''  RUNDATE    AS ''
OVER rptspace1              AS ''  rptspace2   AS ''
OVER ytdhdr                 AS ''  ytdblank    AS ''
OVER storeslabel            AS ''  YTDLOCID    AS ''
OVER tyshrinklabel          AS ''  YTDTYSHRINK/D10CBM AS ''
OVER tysaleslabel           AS ''  YTDTYSALES/D10CBM  AS ''
OVER tyshrinkpctlabel       AS ''  ytdtyratepct   AS ''
OVER lyshrinkpctlabel       AS ''  ytdlyratepct   AS ''
OVER varbpslabel            AS ''  YTDVARBPS/I5   AS ''
OVER optimizedpctlabel      AS ''  ytdoptratepct  AS ''
OVER vartooptlabel          AS ''  YTDOPTVAR/I5   AS ''
OVER gapclosurelabel        AS ''  ytdgapclosurepct AS ''
OVER pctstoresimprovedlabel AS ''  ytdimprovedpct AS ''
OVER rptspace3              AS ''  rptspace4   AS ''
OVER qtdhdr                 AS ''  qtdblank    AS ''
OVER storeslabel            AS ''  QTDLOCID    AS ''
OVER tyshrinklabel          AS ''  QTDTYSHRINK/D10CBM AS ''
OVER tysaleslabel           AS ''  QTDTYSALES/D10CBM  AS ''
OVER tyshrinkpctlabel       AS ''  qtdtyratepct   AS ''
OVER lyshrinkpctlabel       AS ''  qtdlyratepct   AS ''
OVER varbpslabel            AS ''  QTDVARBPS/I5   AS ''
OVER optimizedpctlabel      AS ''  qtdoptratepct  AS ''
OVER vartooptlabel          AS ''  QTDOPTVAR/I5   AS ''
OVER gapclosurelabel        AS ''  qtdgapclosurepct AS ''
OVER pctstoresimprovedlabel AS ''  qtdimprovedpct AS ''
OVER rptspace5              AS ''  rptspace6   AS ''
OVER ptdhdr                 AS ''  ptdblank    AS ''
OVER storeslabel            AS ''  PTDLOCID    AS ''
OVER tyshrinklabel          AS ''  PTDTYSHRINK/D10CBM AS ''
OVER tysaleslabel           AS ''  PTDTYSALES/D10CBM  AS ''
OVER tyshrinkpctlabel       AS ''  ptdtyratepct   AS ''
OVER lyshrinkpctlabel       AS ''  ptdlyratepct   AS ''
OVER varbpslabel            AS ''  PTDVARBPS/I5   AS ''
OVER optimizedpctlabel      AS ''  ptdoptratepct  AS ''
OVER vartooptlabel          AS ''  PTDOPTVAR/I5   AS ''
OVER gapclosurelabel        AS ''  ptdgapclosurepct AS ''
OVER pctstoresimprovedlabel AS ''  ptdimprovedpct AS ''
OVER rptspace7              AS ''  rptspace8   AS ''
OVER wtdhdr                 AS ''  wtdblank    AS ''
OVER storeslabel            AS ''  WTDLOCID    AS ''
OVER tyshrinklabel          AS ''  WTDTYSHRINK/D10CBM AS ''
OVER tysaleslabel           AS ''  WTDTYSALES/D10CBM  AS ''
OVER tyshrinkpctlabel       AS ''  wtdtyratepct   AS ''
OVER lyshrinkpctlabel       AS ''  wtdlyratepct   AS ''
OVER varbpslabel            AS ''  WTDVARBPS/I5   AS ''
OVER optimizedpctlabel      AS ''  wtdoptratepct  AS ''
OVER vartooptlabel          AS ''  WTDOPTVAR/I5   AS ''
OVER gapclosurelabel        AS ''  wtdgapclosurepct AS ''
OVER pctstoresimprovedlabel AS ''  wtdimprovedpct AS ''
OVER rptspace9              AS ''  rptspace10   AS ''
OVER dayhdr                 AS ''  dayblank    AS ''
OVER storeslabel            AS ''  DAYLOCID    AS ''
OVER tyshrinklabel          AS ''  DAYTYSHRINK/D10CBM AS ''
OVER tysaleslabel           AS ''  DAYTYSALES/D10CBM  AS ''
OVER tyshrinkpctlabel       AS ''  daytyratepct   AS ''
OVER lyshrinkpctlabel       AS ''  daylyratepct   AS ''
OVER varbpslabel            AS ''  DAYVARBPS/I5   AS ''
OVER optimizedpctlabel      AS ''  dayoptratepct  AS ''
OVER vartooptlabel          AS ''  DAYOPTVAR/I5   AS ''
OVER gapclosurelabel        AS ''  daygapclosurepct AS ''
OVER pctstoresimprovedlabel AS ''  dayimprovedpct AS ''

BY HEADERLINE NOPRINT PAGE-BREAK


ON TABLE SET PAGE OFF
ON TABLE SET PAGE NOLEAD
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET UNITS INCHES
ON TABLE SET STYLE *
TOPMARGIN=0.05, BOTTOMMARGIN=0.05, LEFTMARGIN=0.05, RIGHTMARGIN=0.05,
FONT='Calibri', SIZE=9, COLOR=BLACK, GRID=OFF, SQUEEZE=OFF,$
TYPE=REPORT, LEFTGAP=.02, RIGHTGAP=.02, TOPGAP=0.02, BOTTOMGAP=0.02, COLOR=BLACK,$
TYPE=DATA, TOPGAP=0.02, BOTTOMGAP=0.02,$
TYPE=REPORT, SQUEEZE=OFF,$

TYPE=REPORT, COLUMN=asofdatehdr  , POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=rptspace1, POSITION=0, STYLE=BOLD,$)
TYPE=REPORT, COLUMN=ytdhdr, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=storeslabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=tyshrinklabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=tysaleslabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=tyshrinkpctlabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=lyshrinkpctlabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=varbpslabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=optimizedpctlabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=vartooptlabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=gapclosurelabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=pctstoresimprovedlabel, POSITION=0, STYLE=BOLD,$

TYPE=REPORT, COLUMN=RUNDATE         , POSITION=0.900,$
TYPE=REPORT, COLUMN=rptspace2    , POSITION=0.700,$
TYPE=REPORT, COLUMN=ytdblank   , POSITION=0.700,$
TYPE=REPORT, COLUMN=YTDLOCID    , POSITION=0.500,$
TYPE=REPORT, COLUMN=YTDTYSHRINK, POSITION=0.700,$
TYPE=REPORT, COLUMN=YTDTYSALES, POSITION=0.760,$
TYPE=REPORT, COLUMN=ytdtyratepct, POSITION=0.820,$
TYPE=REPORT, COLUMN=ytdlyratepct, POSITION=0.820,$
TYPE=REPORT, COLUMN=YTDVARBPS, POSITION=0.890,$
TYPE=REPORT, COLUMN=ytdoptratepct, POSITION=0.820,$
TYPE=REPORT, COLUMN=YTDOPTVAR, POSITION=0.890,$
TYPE=REPORT, COLUMN=ytdgapclosurepct, POSITION=0.850,$
TYPE=REPORT, COLUMN=ytdimprovedpct, POSITION=0.850,$

TYPE=REPORT, COLUMN=rptspace3, POSITION=0, STYLE=BOLD,color=RED,$)
TYPE=REPORT, COLUMN=qtdhdr, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=storeslabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=tyshrinklabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=tysaleslabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=tyshrinkpctlabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=lyshrinkpctlabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=varbpslabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=optimizedpctlabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=vartooptlabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=gapclosurelabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=pctstoresimprovedlabel, POSITION=0, STYLE=BOLD,$

TYPE=REPORT, COLUMN=rptspace4    , POSITION=0.700,$
TYPE=REPORT, COLUMN=qtdblank   , POSITION=0.700,$
TYPE=REPORT, COLUMN=QTDLOCID    , POSITION=0.500,$
TYPE=REPORT, COLUMN=QTDTYSHRINK, POSITION=0.700,$
TYPE=REPORT, COLUMN=QTDTYSALES, POSITION=0.760,$
TYPE=REPORT, COLUMN=qtdtyratepct, POSITION=0.820,$
TYPE=REPORT, COLUMN=qtdlyratepct, POSITION=0.820,$
TYPE=REPORT, COLUMN=QTDVARBPS, POSITION=0.890,$
TYPE=REPORT, COLUMN=qtdoptratepct, POSITION=0.820,$
TYPE=REPORT, COLUMN=QTDOPTVAR, POSITION=0.890,$
TYPE=REPORT, COLUMN=qtdgapclosurepct, POSITION=0.850,$
TYPE=REPORT, COLUMN=qtdimprovedpct, POSITION=0.850,$

TYPE=REPORT, COLUMN=rptspace5, POSITION=0, STYLE=BOLD,$)
TYPE=REPORT, COLUMN=ptdhdr, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=storeslabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=tyshrinklabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=tysaleslabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=tyshrinkpctlabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=lyshrinkpctlabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=varbpslabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=optimizedpctlabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=vartooptlabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=gapclosurelabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=pctstoresimprovedlabel, POSITION=0, STYLE=BOLD,$

TYPE=REPORT, COLUMN=rptspace6    , POSITION=0.700,$
TYPE=REPORT, COLUMN=ptdblank   , POSITION=0.700,$
TYPE=REPORT, COLUMN=PTDLOCID    , POSITION=0.500,$
TYPE=REPORT, COLUMN=PTDTYSHRINK, POSITION=0.700,$
TYPE=REPORT, COLUMN=PTDTYSALES, POSITION=0.760,$
TYPE=REPORT, COLUMN=ptdtyratepct, POSITION=0.820,$
TYPE=REPORT, COLUMN=ptdlyratepct, POSITION=0.820,$
TYPE=REPORT, COLUMN=PTDVARBPS, POSITION=0.890,$
TYPE=REPORT, COLUMN=ptdoptratepct, POSITION=0.820,$
TYPE=REPORT, COLUMN=PTDOPTVAR, POSITION=0.890,$
TYPE=REPORT, COLUMN=ptdgapclosurepct, POSITION=0.850,$
TYPE=REPORT, COLUMN=ptdimprovedpct, POSITION=0.850,$

TYPE=REPORT, COLUMN=rptspace7, POSITION=0, STYLE=BOLD,$)
TYPE=REPORT, COLUMN=wtdhdr, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=storeslabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=tyshrinklabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=tysaleslabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=tyshrinkpctlabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=lyshrinkpctlabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=varbpslabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=optimizedpctlabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=vartooptlabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=gapclosurelabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=pctstoresimprovedlabel, POSITION=0, STYLE=BOLD,$

TYPE=REPORT, COLUMN=rptspace8    , POSITION=0.700,$
TYPE=REPORT, COLUMN=wtdblank   , POSITION=0.700,$
TYPE=REPORT, COLUMN=WTDLOCID    , POSITION=0.500,$
TYPE=REPORT, COLUMN=WTDTYSHRINK, POSITION=0.700,$
TYPE=REPORT, COLUMN=WTDTYSALES, POSITION=0.760,$
TYPE=REPORT, COLUMN=wtdtyratepct, POSITION=0.820,$
TYPE=REPORT, COLUMN=wtdlyratepct, POSITION=0.820,$
TYPE=REPORT, COLUMN=WTDVARBPS, POSITION=0.890,$
TYPE=REPORT, COLUMN=wtdoptratepct, POSITION=0.820,$
TYPE=REPORT, COLUMN=WTDOPTVAR, POSITION=0.890,$
TYPE=REPORT, COLUMN=wtdgapclosurepct, POSITION=0.850,$
TYPE=REPORT, COLUMN=wtdimprovedpct, POSITION=0.850,$

TYPE=REPORT, COLUMN=rptspace9, POSITION=0, STYLE=BOLD,$)
TYPE=REPORT, COLUMN=dayhdr, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=storeslabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=tyshrinklabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=tysaleslabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=tyshrinkpctlabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=lyshrinkpctlabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=varbpslabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=optimizedpctlabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=vartooptlabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=gapclosurelabel, POSITION=0, STYLE=BOLD,$
TYPE=REPORT, COLUMN=pctstoresimprovedlabel, POSITION=0, STYLE=BOLD,$

TYPE=REPORT, COLUMN=rptspace10    , POSITION=0.700,$
TYPE=REPORT, COLUMN=dayblank   , POSITION=0.700,$
TYPE=REPORT, COLUMN=DAYLOCID    , POSITION=0.500,$
TYPE=REPORT, COLUMN=DAYTYSHRINK, POSITION=0.700,$
TYPE=REPORT, COLUMN=DAYTYSALES, POSITION=0.760,$
TYPE=REPORT, COLUMN=daytyratepct, POSITION=0.820,$
TYPE=REPORT, COLUMN=daylyratepct, POSITION=0.820,$
TYPE=REPORT, COLUMN=DAYVARBPS, POSITION=0.890,$
TYPE=REPORT, COLUMN=dayoptratepct, POSITION=0.820,$
TYPE=REPORT, COLUMN=DAYOPTVAR, POSITION=0.890,$
TYPE=REPORT, COLUMN=daygapclosurepct, POSITION=0.850,$
TYPE=REPORT, COLUMN=dayimprovedpct, POSITION=0.850,$

ENDSTYLE
END
-RUN
 

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8
Windows, All Outputs
 
Posts: 111 | Registered: July 23, 2015Report This Post
Expert
posted Hide Post
Right-click and View Source in your Outlook email.

Take a look at the HTML in a text editor.

Do the same with the attachment.

Compare - you will most likely find differences.

If there are no differences, perhaps Outlook is wrapping very wide table cells...


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Platinum Member
posted Hide Post
I solved by removing the following from the style sheet coding:

  TOPMARGIN=0.05, BOTTOMMARGIN=0.05, LEFTMARGIN=0.05, RIGHTMARGIN=0.05,
FONT='Calibri', SIZE=9, COLOR=BLACK, GRID=OFF, SQUEEZE=OFF,$
TYPE=REPORT, LEFTGAP=.02, RIGHTGAP=.02, TOPGAP=0.02, BOTTOMGAP=0.02, COLOR=BLACK,$
TYPE=DATA, TOPGAP=0.02, BOTTOMGAP=0.02,$
TYPE=REPORT, SQUEEZE=OFF,$


and replaced with
FONT='Calibri', SIZE=9, COLOR=BLACK, GRID=OFF,   


WebFOCUS 8
Windows, All Outputs
 
Posts: 111 | Registered: July 23, 2015Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Spacing Issue with In Line Email Reporting <SOLVED>

Copyright © 1996-2020 Information Builders