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] ReportCaster - How to Burst on Email Address?
Go
New
Search
Notify
Tools
Reply
  
[Solved] ReportCaster - How to Burst on Email Address?
 Login/Join
 
Master
posted
The following code models a report we'd like to schedule in ReportCaster:
-* File BurstByEmail.fex
DEFINE FILE GGSALES
 EMAILADDRESS/A50 = DECODE REGION ('Midwest' 'bgates@microsoft.com'
                                   'West'    'ghopper@usnavy.gov');
END
TABLE FILE GGSALES
"Sales Report"
SUM DOLLARS/I9C
BY  EMAILADDRESS AS 'Email Address'
ON  EMAILADDRESS PAGE-BREAK AND REPAGE
BY  ST
IF  REGION EQ 'Midwest' OR 'West'
ON TABLE SET STYLE *
  INCLUDE = endeflt, $
 ENDSTYLE
END  



The scenario is that one TABLE FILE command will crank out a report sorted by email address (a person).

We would like the schedule this job in ReportCaster and have RC burst the report by email address, and send out the report to the email address for that page/section of the report.

We've only begun to use RC, and at this point we've only been sending out a specific report to a specific email address. (This has been working great! :-))

This is the first time we are attempting to burst.

The email addresses found and displayed by the report can vary. It wouldn't ever necessarily be the same person(s). (In other words there isn't a 'distribution list'.)

Any/all assistance gratefully accepted.

This message has been edited. Last edited by: David Briars,




Test: WebFOCUS 8.1.05M Prod: WebFOCUS 8.1.05M Server: Windows Server 2012/Tomcat Standalone Workstation: Windows 7/IE 11 Database: Oracle 12c/Netezza Output: AHTML/XLSX/HTML/PDF/JSCHART Tools: WFDS, Repository Content, BI Portal Designer, & ReportCaster

 
Posts: 788 | Registered: April 23, 2003Reply With QuoteReport This Post
Expert
posted Hide Post
From what I can remember, the high order sort need to match the burst value is a distribution list to get the email address.

In a previous job, I seem to remember they had dynamic distribution lists, that were populated on the fly.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6252 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Reply With QuoteReport This Post
Silver Member
posted Hide Post
We used a Distribution File for the distribution type and created the distribution file dynamically with a pre-processing fex in the RC job. The pre-processing fex reads from a SQL view that stores everyone’s email addresses by division name. The records in this view, and therefore the resultant distribution file, contained many records similar to this;
John.Doe.@whatever.org;Jane.Doe@whatever.org,SALES,$

The main RC fex then uses SALES as the first BY field. The pre-processing fex must reside on the reporting server but it’s all detailed in the RC manual.


8.8.09 - z/Linux (WF, Report Caster, Report Library).
Iway FFS on MVS (HFS)
 
Posts: 36 | Location: Oklahoma City | Registered: December 05, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
According to the doc https://webfocusinfocenter.inf...s_rchelp_dynamic.htm :

A Dynamic Distribution List enables you to return in memory either a list of burst values and destinations, or only a list of destinations from a data source (for example, a flat file, SQL database, FOCUS data source, or LDAP).


WebFOCUS 8206, Unix, Windows
 
Posts: 1822 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Silver Member
posted Hide Post
Look up Value and Dest in Focal Point. Those are the required fieldnames (which can be assigned via an AS phrase) in the fex that extracts the burst and email values.


8009
Windows, HTML, AHTML, Excel
In FOCUS since 1983
 
Posts: 41 | Location: Charlotte, NC | Registered: January 06, 2012Reply With QuoteReport This Post
Expert
posted Hide Post
Yes, Value and Dest, which must match the primary sort order in the fex to be bursted when using a Dynamic Distibution list (DDL).
Execute a fex within the RC job from the content folder and select the the DDL from a fex from the app folder for your RC job.
Enjoy It!




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Currently with Fidelity Investments
 
Posts: 3066 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
Master
posted Hide Post
Thank you all for the information and references (and encouragement).

With that, our new ReportCaster bursting with a dynamic distribution list is working great.
 
Posts: 788 | Registered: April 23, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Solved] ReportCaster - How to Burst on Email Address?

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