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,

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

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

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!