Focal Point
[CLOSED] PDF report as Email Inline message via ReportCaster

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9727059096

November 30, 2018, 10:43 AM
Alma Guardiola
[CLOSED] PDF report as Email Inline message via ReportCaster
Is it possible to insert a PDF report as an EMail Inline message via Report Caster? I have tried selecting the option in report caster to send the report as INline message but when the email is sent, report is sent as an attachment. Anybody know why this is happening? Thanks.

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


WebFOCUS 8
Windows, All Outputs
November 30, 2018, 11:21 AM
FP Mod Chuck
Hi Alma

HTML is the only output format supported for an in-line message for email delivery.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
November 30, 2018, 12:33 PM
Alma Guardiola
Thank you for your quick response. I'm trying to format a table (grid) in the SUBHEAD section of the report, which requires borders and cell shading. I haven't been able to get it to work with HTML format. I'm able to get it to display the data in column format but won't allow borders or shading. Any suggestions?


WebFOCUS 8
Windows, All Outputs
November 30, 2018, 01:21 PM
MartinY
Please share sample code of what you are looking for using IB file such as CAR file.


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
November 30, 2018, 03:02 PM
Alma Guardiola
Here's a sample code for the PDF format. Lines 16-23 is the table I need included in the report.

HEADING
" "
" "
" "
" "
" "
" "
" "
"Dear " "
"This message is to inform you that you have been placed on "" "
"Students interested in receiving federal, state, and/or institutional aid must meet the federal-regulated"
"academic progress standards outlined below:"
" "
""""""ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
SQUEEZE=ON,
$
TYPE=REPORT,
FONT='AERIAL NARROW',
SIZE=11,
STYLE=NORMAL,
TOPGAP=0.000000,
BOTTOMGAP=0.000000,
$
TYPE=HEADING,
SIZE=10,
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=8,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=10,
OBJECT=FIELD,
ITEM=1,
STYLE=ITALIC,
$
TYPE=HEADING,
LINE=10,
OBJECT=TEXT,
ITEM=2,
STYLE=ITALIC,
$
TYPE=HEADING,
LINE=10,
OBJECT=FIELD,
ITEM=1,
STYLE=BOLD,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=11,
STYLE=ITALIC,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=14,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=16,
OBJECT=FIELD,
ITEM=1,
BORDER-TOP=MEDIUM,
BORDER-BOTTOM=MEDIUM,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BACKCOLOR='GRAY',
STYLE=BOLD,
WIDTH=2.500,
$
TYPE=HEADING,
LINE=16,
OBJECT=FIELD,
ITEM=2,
BORDER-TOP=MEDIUM,
BORDER-BOTTOM=MEDIUM,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BACKCOLOR='GRAY',
STYLE=BOLD,
WIDTH=2.500,
$
TYPE=HEADING,
LINE=16,
OBJECT=FIELD,
ITEM=3,
BORDER-TOP=MEDIUM,
BORDER-BOTTOM=MEDIUM,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BACKCOLOR='GRAY',
STYLE=BOLD,
WIDTH=2.500,
$
TYPE=HEADING,
LINE=17,
OBJECT=FIELD,
ITEM=1,
BORDER-TOP=MEDIUM,
BORDER-BOTTOM=MEDIUM,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BACKCOLOR='WHITE',
JUSTIFY=LEFT,
WIDTH=2.500,
$
TYPE=HEADING,
LINE=17,
OBJECT=FIELD,
ITEM=2,
BORDER-TOP=MEDIUM,
BORDER-BOTTOM=MEDIUM,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BACKCOLOR='WHITE',
JUSTIFY=LEFT,
WIDTH=2.500,
$
TYPE=HEADING,
LINE=17,
OBJECT=FIELD,
ITEM=3,
BORDER-TOP=MEDIUM,
BORDER-BOTTOM=MEDIUM,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BACKCOLOR='WHITE',
JUSTIFY=LEFT,
WIDTH=2.500,
$
TYPE=HEADING,
LINE=18,
OBJECT=FIELD,
ITEM=1,
BORDER-TOP=MEDIUM,
BORDER-BOTTOM=MEDIUM,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BACKCOLOR='WHITE',
JUSTIFY=LEFT,
WIDTH=2.500,
$
TYPE=HEADING,
LINE=18,
OBJECT=FIELD,
ITEM=2,
BORDER-TOP=MEDIUM,
BORDER-BOTTOM=MEDIUM,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BACKCOLOR='WHITE',
JUSTIFY=LEFT,
WIDTH=2.500,
$
TYPE=HEADING,
LINE=18,
OBJECT=FIELD,
ITEM=3,
BORDER-TOP=MEDIUM,
BORDER-BOTTOM=MEDIUM,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BACKCOLOR='WHITE',
JUSTIFY=LEFT,
WIDTH=2.500,
$
TYPE=HEADING,
LINE=19,
OBJECT=FIELD,
ITEM=1,
BORDER-TOP=MEDIUM,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BACKCOLOR='WHITE',
JUSTIFY=LEFT,
WIDTH=2.500,
$
TYPE=HEADING,
LINE=19,
OBJECT=FIELD,
ITEM=2,
BORDER-TOP=MEDIUM,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BACKCOLOR='WHITE',
JUSTIFY=LEFT,
WIDTH=2.500,
$
TYPE=HEADING,
LINE=19,
OBJECT=FIELD,
ITEM=3,
BORDER-TOP=MEDIUM,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BACKCOLOR='WHITE',
JUSTIFY=LEFT,
WIDTH=2.500,
$
TYPE=HEADING,
LINE=20,
OBJECT=FIELD,
ITEM=1,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
SIZE=6,
BACKCOLOR='WHITE',
JUSTIFY=LEFT,
WIDTH=2.500,
$
TYPE=HEADING,
LINE=20,
OBJECT=FIELD,
ITEM=2,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BACKCOLOR='WHITE',
JUSTIFY=LEFT,
WIDTH=2.500,
$
TYPE=HEADING,
LINE=20,
OBJECT=FIELD,
ITEM=3,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BACKCOLOR='WHITE',
JUSTIFY=LEFT,
WIDTH=2.500,
$
TYPE=HEADING,
LINE=21,
OBJECT=FIELD,
ITEM=1,
BORDER-BOTTOM=MEDIUM,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BACKCOLOR='WHITE',
JUSTIFY=LEFT,
WIDTH=2.500,
$
TYPE=HEADING,
LINE=21,
OBJECT=FIELD,
ITEM=2,
BORDER-BOTTOM=MEDIUM,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BACKCOLOR='WHITE',
JUSTIFY=LEFT,
WIDTH=2.500,
$
TYPE=HEADING,
LINE=21,
OBJECT=FIELD,
ITEM=3,
BORDER-BOTTOM=MEDIUM,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BACKCOLOR='WHITE',
JUSTIFY=LEFT,
WIDTH=2.500,
$
TYPE=HEADING,
LINE=22,
OBJECT=FIELD,
ITEM=1,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BACKCOLOR='WHITE',
WIDTH=2.500,
$
TYPE=HEADING,
LINE=22,
OBJECT=FIELD,
ITEM=2,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BACKCOLOR='WHITE',
WIDTH=2.500,
$
TYPE=HEADING,
LINE=22,
OBJECT=FIELD,
ITEM=3,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BACKCOLOR='WHITE',
WIDTH=2.500,
$
TYPE=HEADING,
LINE=23,
OBJECT=FIELD,
ITEM=1,
BORDER-BOTTOM=MEDIUM,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BACKCOLOR='WHITE',
WIDTH=2.500,
$
TYPE=HEADING,
LINE=23,
OBJECT=FIELD,
ITEM=2,
BORDER-BOTTOM=MEDIUM,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BACKCOLOR='WHITE',
WIDTH=2.500,
$
TYPE=HEADING,
LINE=23,
OBJECT=FIELD,
ITEM=3,
BORDER-TOP=MEDIUM,
BORDER-BOTTOM=MEDIUM,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BACKCOLOR='WHITE',
WIDTH=2.500,
$


WebFOCUS 8
Windows, All Outputs
November 30, 2018, 03:14 PM
MartinY
When I said :
quote:

Please share sample code of what you are looking for using IB file such as CAR file

It means to create a sample using the CAR file that will result in what you need (or similar to).

From what you posted there is a lot of error in the HEADING definition : too many or not enough of double quotes. Maybe related to the fact the you haven't use the code tag.

When posting sample code or output layout, please use the code tag.
Last one on the ribbon
</>


What is ?
quote:
Lines 16-23 is the table I need included in the report



WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007