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     [CLOSED]Use a variable in ReportCaster subject lines?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED]Use a variable in ReportCaster subject lines?
 Login/Join
 
Doug
Expert
posted
Is it possible to use a DM variable in the subject line of a ReportCaster job, Distribution / Notification sections? If so, How?

I want to add &DATEMtDYY &TOD there.

This message has been edited. Last edited by: <Emily McAllister>,




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Waz
Expert
posted Hide Post
I would suggest testing it.

You can have an amper variable in the filename of attached reports, so I assume you could do it with the subject.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Doug
Expert
posted Hide Post
Frowner I did, and it didn't work, as follows: 
What I entered: "Daily_Reports &DATEMtDYY &TOD"
What came out : "Daily_Reports &DATEMtDYY &TOD"
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Doug
Expert
posted Hide Post
Frowner 
I even tried: "Daily_Reports !IBI.AMP.DATEMtDYY; !IBI.AMP.TOD;"
And I got   : "Daily_Reports !IBI.AMP.DATEMtDYY; !IBI.AMP.TOD;"
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Waz
Expert
posted Hide Post
Frowner

What about a variable you created in the fex ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Doug
Expert
posted Hide Post
Frowner Same... I created, &ThisOrThat using: -SET &ThisOrThat= 'Whatever'; 
I entered: Daily_Reports &ThisOrThat !IBI.AMP.ThisOrThat;
I saw    : Daily_Reports &ThisOrThat !IBI.AMP.ThisOrThat;
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Waz
Expert
posted Hide Post
Bugger.

TechSupport time ? Confused


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Doug
Expert
posted Hide Post
Yep: Bugger.... TechSupport time ! Confused
I will be meeting with some IBIers tomorrow. So, I may run this by them... I'll keep you posted...
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Waz
Expert
posted Hide Post
Yeah, would be a useful capability


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Wep5622
Virtuoso
posted Hide Post
You can use DM variables in WF8.1's ReportCaster. I know, because we tripped over that with some subject lines and message bodies that contained ampersands that were not DM variables, but just plain ampersands.


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
 
Posts: 1669 | Location: Enschede, Netherlands | Registered: August 12, 2010Report This Post
Doug
Expert
posted Hide Post
Thanks Wep5622, Unfortunately, as you saw, we're on 8007...

Would you please explain the differences between "just plain ampersands" and "DM variables"? I'm guessing the "just plain ampersands" are those set by the system (system variables) and "DM variables are those which are -SET within the fex that is being called by RC...




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Tim P.
Platinum Member
posted Hide Post
Doug,
I think Wep meant they had '&' as regular text in message bodies and subject lines as apposed to an actual variable being called.

'Ben & Jerry's Report' <--Subject line where '&' likely isn't a variable.

&time_of_day <-- probably a DM variable.

...and now I want ice cream...


WebFOCUS App Studio 8.2.02
Windows 7, All Outputs
 
Posts: 141 | Location: Mclean, VA | Registered: December 04, 2012Report This Post
MattC
Guru
posted Hide Post
Here is what I just figured out on all of this after an hour or two struggling with this.

Your fex must reside on the server and not in the repository. You can use a DM Variable, but it must also be used in the report itself.


WebFOCUS 8.1.05
 
Posts: 496 | Registered: January 04, 2008Report 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     [CLOSED]Use a variable in ReportCaster subject lines?

Copyright © 1996-2020 Information Builders