Focal Point
Setting burst size for Burst report
August 07, 2008, 05:00 AM
SujiSetting burst size for Burst report
Hello,
It will be helpful if anyone can suggest me how to set size value for burst reports?Is there any criteria needed for setting burst size for such reports?Is there any API available to do this ?
Thanks,
Suji.
Reportcaster 7.1
Webfocus 7.1.4
Oracle 10G
WebFOCUS 7.7.02(Production)
WebFOCUS 7.7.02(Test region)
Oracle backend (10g)and Windows Frontend.
HTML,PDF,EXL2K,FLEX,AHTML
August 07, 2008, 05:53 AM
Danny-SRLSuji,
What do you mean by size? Number of lines?
Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
August 07, 2008, 07:07 AM
FrankDutchThe burst is doneon the first BY field you create in your FEX.
So you have to define an email adres for each of the burst values.
Suppose you want to report the sales per Accountmanager you create something like
TABLE FILE SALES
SUM SALES
BY ACCOUNTMANAGER
BY STORE
ACROSS MONTH
END
|
Frank |
| prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7 |
August 07, 2008, 09:00 AM
SujiFrankDutch,
what do you mean by burst value? Is it size of the burst file or something else?Please elaborate.
Danny,
I mean byte size of the burst file split and sent across different email addresses by 'Burst Size'.
Thanks,
Suji.
WebFOCUS 7.7.02(Production)
WebFOCUS 7.7.02(Test region)
Oracle backend (10g)and Windows Frontend.
HTML,PDF,EXL2K,FLEX,AHTML
August 07, 2008, 12:19 PM
Darin LeeI think you're missing the point of bursting. There is no such thing as "burst size." As Frank explained, bursting means that the report is run and then separated by the primary sort value and each section is distributed to the destination associated in the address book with that sort value.
If that's not clear enough, you need to go back to the Report Caster manuals and read up on bursting.
Regards,
Darin
In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
August 07, 2008, 12:32 PM
Danny-SRLSuji,
To sum up:
When you burst a report, WF uses the values of the first BY field. To each value must be associated an e-mail address.
The size of each file sent is a function of the number of its lines and pages.
If what you are saying is that when you burst your file according to the values of the BY field you are creating attachments which are too big then you have to try to limit the number of lines per BY value.
I hope this makes things a bit clearer.
Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
August 07, 2008, 01:53 PM
FrankDutchOr you can create a BY field based upon the number of lines.
If you make that field the first BY field you can send each x lines in a separate report and send that to different (or the same) receivers.
Suppose you want to let 10 people control 250 lines of data this would be an opportunity.
We all hope to here from you if this is what you need.
|
Frank |
| prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7 |