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] Need a way to dynamically add store number to file names burst out by email:

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Need a way to dynamically add store number to file names burst out by email:
 Login/Join
 
CoolGuy
Virtuoso
posted
Hi all,

My scenario is that I have table request in WF that gets its data from an Excel sheet. I need to output the data back into Excel with the changes the request makes to it. The only catch is I need to distribute via a dynamic distribution list wherein each file attachment has the store number in the file name. So, if Billy Bob Joe gets several attachments in one email to in turn disperse to others he's in charge of, he needs to be able to uniquely identify each attachment by store number to do so.

In the table request I have I've tried something like the following with no luck:

TABLE FILE sheetName
PRINT
STORE_NUMBER
...
BY ...
ON TABLE PCHOLD AS "Exp_Drug_Credits for <STORE_NUMBER" FORMAT EXL2K


Does anyone know of a way to grab a value from a request and make it available in the output's desired file name?


Thanks in advance!

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


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
 
Posts: 1113 | Location: USA | Registered: January 27, 2015Report This Post
MartinY
Virtuoso
posted Hide Post
Using ON TABLE SET COMPOUND BYTOC and the RC bursting feature will have each file name's suffix with the first BY field. In your case it should be the store number.
TABLE FILE CAR
PRINT RETAIL_COST
BY COUNTRY
BY CAR
ON TABLE PCHOLD AS "Exp_Drug_Credits" FORMAT EXL2K
ON TABLE SET COMPOUND BYTOC
END


Hope this help


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: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
Hallway
Master
posted Hide Post
We also just found out that in the schedule, under task, you can use '%BURST' in the Save Report As: filename 
 Exp_Drug_Credits for '%BURST'


Hallway

 
Prod: 8202M1
Test: 8202M4
Repository:
 
OS:
 
Outputs:
 
 
 
 
 
Posts: 608 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Report This Post
CoolGuy
Virtuoso
posted Hide Post
Thanks all! "Learned me" something new today. Wink


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
 
Posts: 1113 | Location: USA | Registered: January 27, 2015Report This Post
Dave
Master
posted Hide Post
It just dawned on me that this is the solution to countless previous questions about adding a parameter to the output name ( save report as ) issue in the Report Caster...

...just add a dummy BY-field NOPRINT with the desired ( dynamic ) filename to all rows. Check "Burst Report" and you're done. Wink


_____________________
WF: 8.0.0.9 > going 8.2.0.5
 
Posts: 668 | Location: Veghel, The Netherlands | Registered: February 16, 2010Report This Post
SWES
Platinum Member
posted Hide Post
Is there also a way to not have the file name burst out? It appears to me that there has been a change with WF 8, since previously the file name was not added and it was only the burst value itself?


WebFOCUS 8105m
Windows 7, All Outputs

Member of the Benelux Usergroup
 
Posts: 198 | Location: Amsterdam | Registered: August 24, 2011Report 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] Need a way to dynamically add store number to file names burst out by email:

Copyright © 1996-2020 Information Builders