Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Including a text file as footer
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Including a text file as footer
 Login/Join
 
Platinum Member
posted
I have a confidentiality statement in a text file I'd like to be able to include as a footer on a group of reports that are running in a compound report. What's the easiest or most efficient way to do this? (realizing that may be two different things!)
Thanks!

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


WebFOCUS 8.2.03 (production), 8.2.06 (testing)
AppStudio, InfoAssist
Windows, All Outputs
 
Posts: 162 | Location: Indiana | Registered: December 05, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
My assumption is that is a slightly short sentence and that your text file exist on the server with its metadata defined.

Read you sentence file and hold it. Then read (READFILE) the hold file to have the sentence in a variable to finally include that variable in your footer.

Something such as
TABLE FILE sentenceFile
BY confSentence
ON TABLE HOLD AS MYTEXT
END
-RUN
-READFILE MYTEXT
-RUN
-TYPE myConfidentialSentence : &confSentence

TABLE FILE abc
PRINT ...
BY ...
FOOTING
"&confSentence.EVAL"
END

This is one option


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
 
Posts: 2283 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Gold member
posted Hide Post
Just in case you're after a longer footing note, and you don't expect it to change much, let me ask if this is kind of what you've got in your text file (this one is for email but you get the idea -lawyer-speak):

CONFIDENTIALITY NOTICE:
The contents of this email message and any attachments are intended solely for the addressee(s)
and may contain confidential and/or privileged information and may be legally protected from
disclosure. If you are not the intended recipient of this message or their agent, or if this message
has been addressed to you in error, please immediately alert the sender by reply email and then
delete this message and any attachments.

And what you'd like to get is those lines put in as FOOTING (or ON TABLE SUBFOOT or whatever)?

Just wrap that guy in double quotes and put it in a focexec named something like confidentialfoot.fex.

Like so:
"CONFIDENTIALITY NOTICE: "
"The contents of this email message and any attachments are intended solely for the addressee(s) "
"and may contain confidential and/or privileged information and may be legally protected from "
"disclosure. If you are not the intended recipient of this message or their agent, or if this message "
"has been addressed to you in error, please immediately alert the sender by reply email and then "
"delete this message and any attachments. "

Save that in an easily accessible folder where all your users can see it... call it confidentialfoot.fex.

Now you use it by just doing a -INCLUDE rather than typing all that text:

TABLE FILE CAR
PRINT COUNTRY
FOOTING
"Today is &DATE"
-INCLUDE confidentialfoot.fex
"and anything else you want to put in your footing just for this report"
END

Hope that helps.

Toby
 
Posts: 62 | Registered: October 31, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Toby - That's what I was looking for. It is a long notice, which is why I wanted to have it in a file for reuse.

Thanks!


WebFOCUS 8.2.03 (production), 8.2.06 (testing)
AppStudio, InfoAssist
Windows, All Outputs
 
Posts: 162 | Location: Indiana | Registered: December 05, 2017Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Including a text file as footer

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.