All, I found topics on this subject searching the forum but it looks like it hasn't been revisited in 3-4 years. I have the following code which successfully produced a compound Excel report (data printed to three separate tabs in an Excel workbook) however it fails to burst as an attachment in an email. Can anyone shed some light on whether this functionality (bursting a compound excel report) is possible?

Thank you in advance for your help.

 -TYPE *** IBFS:/WFC/Repository/eongou02/std_reports/reportsdevel/DailyShrinkFlash/Daily_Blended_File_Doug *** &DATEMtDY &TOD *** Start
-SET &ExecedFrom = 'Report' ;
-INCLUDE IBFS:/WFC/Repository/eongou02/std_reports/reportsdevel/DailyShrinkFlash/Daily_Shrink_Recap_File_Checking.fex
-SET &ECHO = 'ALL' ;
-DEFAULTH &DIVISION = *
SET NODATA = ''
SET LINES = 999999

DEFINE FILE EBRRPT_RPT_DAILY_BLENDED_SHRINK_SUMMARY_TBL
TYRATE/D7.2%S=TYRATE*100;
LYRATE/D7.2%S=LYRATE*100;
OPTRATE/D7.2%S=OPTRATE*100;
GAPCL/D10.2%S=GAPCL*100;
RDFCST/D7.2%S=RDFCST*100;
DIVISION/I11=SDIV;
END
TABLE FILE EBRRPT_RPT_DAILY_BLENDED_SHRINK_SUMMARY_TBL
PRINT
INVENTORY/MDYY AS 'DATE'
TYSHRINK/D10CBM AS 'TY ,SHRINK'
TYSALES/D10CBM AS 'TY ,SALES'
TYRATE AS 'TY ,SHRINK ,%'
STATUS
LYSHRINK/D10CBM AS 'LY ,SHRINK'
LYSALES/D10CBM AS 'LY ,SALES'
LYRATE AS 'LY ,SHRINK ,%'
VARBPS/D10CB AS 'VAR'
OPTDLLRS/D10CBM AS 'OPTIMIZED ,$'
OPTRATE AS 'OPTIMIZED ,%'
VARTOOPT/D10CB AS 'VAR ,TO ,OPTIMIZED'
GAPCL AS 'GAP ,CLOSURE'
RDFCST AS 'RD ,FCST'
FINPDPOSTED AS 'POST ,PERIOD'
COHORT
IMPROVED AS 'IMPRVD'
TSS
FINQTRPOSTED AS 'QTR'
FLAG AS 'HSAP'
POSTING AS 'POST ,DATE'
FINWKPOSTED AS 'FIN ,WK'

WHERE STATUS EQ 'Rec';
WHERE DIVISION GE 1 AND DIVISION LT 99;
BY DIVISION PAGE-BREAK
BY LOWEST REGION AS 'REG'
BY LOWEST DISTRICT AS 'DIS'
BY LOWEST LOCID AS 'STORE'

ON TABLE SET BYDISPLAY ON
ON TABLE SET PAGE OFF
ON TABLE SET PAGE NOLEAD
ON TABLE PCHOLD AS 'Store' FORMAT XLSX OPEN
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *

TYPE=REPORT,FONT='CALIBRI',SIZE=9,COLOR=RGB(66 70 73),STYLE=NORMAL,JUSTIFY=CENTER,TITLETEXT=Stores,$
TYPE=pagenum, style=italic, size=6, justify=right,$
TYPE=tabheading,style=bold+italic,size=14,justify=center,$
TYPE=tabfooting,style=bold+italic,size=12,justify=center,border-top=heavy,border-top-color=rgb(52 55 58),$
TYPE=heading,style=bold,size=12,justify=center,$
TYPE=footing,style=bold,size=10,justify=center,$
TYPE=title,backcolor=rgb(102 102 102),color=rgb(255 255 255),style=-underline+bold,$
ENDSTYLE

END



DEFINE FILE EBRRPT_RPT_DAILY_BLENDED_SHRINK_SUMMARY_DISTRICT_TBL
TYRATE/D7.2%S=TYRATE*100;
LYRATE/D7.2%S=LYRATE*100;
OPTRATE/D7.2%S=OPTRATE*100;
GAPCL/D10.2%S=GAPCL*100;
RDFCST/D7.2%S=RDFCST*100;
TYOPTRATE/D7.2%S=TYOPTRATE*100;
DIVISION/I11=SDIV;
END

TABLE FILE EBRRPT_RPT_DAILY_BLENDED_SHRINK_SUMMARY_DISTRICT_TBL
PRINT
TYSHRINK/D10CBM AS 'TY ,SHRINK'
TYSALES/D10CBM AS 'TY ,SALES'
TYRATE AS 'TY ,SHRINK ,%'
LYSHRINK/D10CBM AS 'LY ,SHRINK'
LYSALES/D10CBM AS 'LY ,SALES'
LYRATE AS 'LY ,SHRINK ,%'
VARBPS/D10CB AS 'VAR'
OPTDLLRS/D10CBM AS 'OPTIMIZED ,$'
TYOPTRATE AS 'OPTIMIZED ,%'
VARTOOPT/D10CB AS 'VAR ,TO ,OPTIMIZED'
GAPCL AS 'GAP ,CLOSURE'

WHERE DIVISION GE 1 AND DIVISION LT 99;
BY DIVISION PAGE-BREAK
BY LOWEST REGION AS 'REG'
BY LOWEST DISTRICT AS 'DIS'

ON TABLE SET BYDISPLAY ON
ON TABLE SET PAGE OFF
ON TABLE SET PAGE NOLEAD
ON TABLE PCHOLD AS 'District' FORMAT XLSX
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT,FONT='CALIBRI',SIZE=9,COLOR=RGB(66 70 73),STYLE=NORMAL,JUSTIFY=CENTER,TITLETEXT=District,$
TYPE=pagenum, style=italic, size=6, justify=right,$
TYPE=tabheading,style=bold+italic,size=14,justify=center,$
TYPE=tabfooting,style=bold+italic,size=12,justify=center,border-top=heavy,border-top-color=rgb(52 55 58),$
TYPE=heading,style=bold,size=12,justify=center,$
TYPE=footing,style=bold,size=10,justify=center,$
TYPE=title,backcolor=rgb(102 102 102),color=rgb(255 255 255),style=-underline+bold,$

ENDSTYLE
END


DEFINE FILE EBRRPT_RPT_DAILY_BLENDED_SHRINK_SUMMARY_REGION_TBL
TYRATE/D7.2%S=TYRATE*100;
LYRATE/D7.2%S=LYRATE*100;
OPTRATE/D7.2%S=OPTRATE*100;
GAPCL/D10.2%S=GAPCL*100;
RDFCST/D7.2%S=RDFCST*100;
TYOPTRATE/D7.2%S=TYOPTRATE*100;
DIVISION/I11=SDIV;
END

TABLE FILE EBRRPT_RPT_DAILY_BLENDED_SHRINK_SUMMARY_REGION_TBL
PRINT
TYSHRINK/D10CBM AS 'TY ,SHRINK'
TYSALES/D10CBM AS 'TY ,SALES'
TYRATE AS 'TY ,SHRINK ,%'
LYSHRINK/D10CBM AS 'LY ,SHRINK'
LYSALES/D10CBM AS 'LY ,SALES'
LYRATE AS 'LY ,SHRINK ,%'
VARBPS/D10CB AS 'VAR'
OPTDLLRS/D10CBM AS 'OPTIMIZED ,$'
TYOPTRATE AS 'OPTIMIZED ,%'
VARTOOPT/D10CB AS 'VAR ,TO ,OPTIMIZED'
GAPCL AS 'GAP ,CLOSURE'
WHERE DIVISION GE 1 AND DIVISION LT 99;
BY DIVISION PAGE-BREAK
BY LOWEST REGION AS 'REG'


ON TABLE SET BYDISPLAY ON
ON TABLE SET PAGE OFF
ON TABLE SET PAGE NOLEAD
ON TABLE PCHOLD AS 'Region' FORMAT XLSX CLOSE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT,FONT='CALIBRI',SIZE=9,COLOR=RGB(66 70 73),STYLE=NORMAL,JUSTIFY=CENTER,TITLETEXT=Region,$
TYPE=pagenum, style=italic, size=6, justify=right,$
TYPE=tabheading,style=bold+italic,size=14,justify=center,$
TYPE=tabfooting,style=bold+italic,size=12,justify=center,border-top=heavy,border-top-color=rgb(52 55 58),$
TYPE=heading,style=bold,size=12,justify=center,$
TYPE=footing,style=bold,size=10,justify=center,$
TYPE=title,backcolor=rgb(102 102 102),color=rgb(255 255 255),style=-underline+bold,$

ENDSTYLE
END
-RUN
-SET &ECHO = 'OFF' ;
-TYPE *** &RECORDS Records &LINES lines ***
-TYPE *** IBFS:/WFC/Repository/eongou02/std_reports/reportsdevel/DailyShrinkFlash/Daily_Blended_File_Doug *** &DATEMtDY &TOD *** Ended
 

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

Hi,
Your issue is not related to the bursting feature but with the schedule itself.

Be sure as in the task tab to have selected : "Override the Format Specified in the Procedure" and have selected the "EXL07 - Excel 07 (*.xlsx)" format

Thanks for the input Martin. I actually already had that set to EXL07 and it still doesn't work.

I'm 99% sure its related to it being a compound report because if I comment out the code that produces the second and third tabs (making it a simple one tab report) it will burst just fine.

I'm not talking of having

ON TABLE PCHOLD FORMAT XLSX

as you have in your code. I talking in the schedule itself, under the task tab you need to check "Override the Format Specified in the Procedure" and have selected the "EXL07 - Excel 07 (*.xlsx)" format.

I have reproduce your issue and if you don't perform the above, the report is not distributed by RC when it's a compound.
It is RC that needs to have the format set in the task itself.

quote:

Originally posted by MartinY:
I'm not talking of having

ON TABLE PCHOLD FORMAT XLSX

as you have in your code. I talking in the schedule itself, under the task tab you need to check "Override the Format Specified in the Procedure" and have selected the "EXL07 - Excel 07 (*.xlsx)" format.

I have reproduce your issue and if you don't perform the above, the report is not distributed by RC when it's a compound.
It is RC that needs to have the format set in the task itself.

Yes, I know exactly what you are talking about. I've already selected EXL07 in the override field and it does not solve the problem.

Create a fex with the following then schedule it.
Do not forget to check the "Burst Report" option from the task tab

TABLE FILE CAR
SUM RETAIL_COST
    DEALER_COST
BY COUNTRY
BY CAR
BY MODEL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT XLSX OPEN
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
TYPE=REPORT,
     TITLETEXT='Country',
$
ENDSTYLE
END

TABLE FILE CAR
SUM RETAIL_COST
    DEALER_COST
BY COUNTRY
BY CAR
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT XLSX
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
TYPE=REPORT,
     TITLETEXT='Car',
$
ENDSTYLE
END

TABLE FILE CAR
SUM RETAIL_COST
    DEALER_COST
BY COUNTRY
BY MODEL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT XLSX CLOSE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
TYPE=REPORT,
     TITLETEXT='Model',
$
ENDSTYLE
END

You should receive one mail with 15 attached files in it : 5 countries X 3 reports since it burst on Country.

Martin,I created the fex and then set up the job to burst it and got the following:

Schedule ID: S7e23737dsdbb1s404ds8719s4a4011d9f8d3, Job Description: burst test Completed with errors/warnings No report to distribute.

I even remembered to set the override to EXL07 :-)

I also tried it without setting the override, same result.

Martin, FYI the .fex you created works just fine when I run it. It just doesn't burst.

You probably have something not properly setup in your schedule as for your bursting 'cause it work fine on my side.

It's become difficult to help since I can't see all the setup...

The last time I checked, you cannot burst a Compound Excel report, so i had to use PDF for 8105. I am not sure whether this has been fixed or not.

WebFOCUS Release 8.1 Version 05M > ReportCaster > ReportCaster > Tips and Techniques for Coding a ReportCaster Report
Compound Reports and Coordinated Compound Reports
ReportCaster can distribute compound reports developed using the Document Composer in Developer Studio in AHTML, DHTML, EXL2K, PDF, and PPT formats.
ReportCaster can burst and distribute coordinated compound reports developed using the Document Composer in Developer Studio in DHTML, PDF, and PPT formats.

ReportCaster Burst Formats

FYI, I ran Martin's fex with a schedule (Burst on and Override format to EXL07) and got the 15 attachments.

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

quote:

Originally posted by MartinY:
You probably have something not properly setup in your schedule as for your bursting 'cause it work fine on my side.

It's become difficult to help since I can't see all the setup...

Martin, I know its hard because you cant attach screenshots, but let me give you a rundown of my settings in the schedule file, tab by tab and see if that helps :

Properties:
box for 'Enabled' checked
Job priority=normal

Recurrences:
Set to "Run Once" and enabled

Tasks:
One task appropriately named 'Task 1'
Type= WebFOCUS Report
Path=location of .fex (I run other .fex files in schedules from this path, so I know its a valid path)
Procedure=car.fex
Server Name and Execution ID are both set correctly as per many other jobs that I schedule
'Burst Report' box is checked
'Override the Format Specified in the Procedure' is unchecked, however I have checked this box before and set to 'EXL07'
'Save Report As: 'car.xlsx'
There is nothing in the 'Parameters' tab or the 'Pre./Post-Procedures' tab

Distribution:
There is one Email Distribution that is enabled named 'Email'
Type=Email Address(s)
To= my email address
From= my email address
Reply Address= my email address
Subject= test burst
Radio Button for 'Send all reports as attachments' is selected
'Add Report to Zip File' box is not checked

On the 'Options' tab the Mail Server Name is set correctly as per every other report I have ever scheduled (so no changes there that might have caused this issue)
None of the other check boxes are selected and no account name and password needed


Notifications:
Notification Type= Always
Reply address= my email address
Subject= Test Burst
Brief Message to=my email address
Full Message to= my email address



That is everything in the schedule file. Let me know if something looks wrong or if I'm missing something that you expect to see.

quote:

Originally posted by tomatosauce:
The last time I checked, you cannot burst a Compound Excel report, so i had to use PDF for 8105. I am not sure whether this has been fixed or not.

FYI, I ran Martin's fex with a schedule (Burst on and Override format to EXL07) and got the 15 attachments.

Well, I am encouraged that two people seem to be able to do this. Now I just have to become #3...LOL

quote:

'Override the Format Specified in the Procedure' is unchecked, however I have checked this box before and set to 'EXL07'

You need to keep that check box "checked".

Here is a copy of the error message I get in my email from running this job, if this helps provide context.

 ReportCaster Log Report Schedule ID: Sd3795321sf95es49fbsbb32sd113fdf1726f, Job Description: car burst test
 
 
                  Process:    Jf15f8149j3502j47b2jabe0j9c419a1272dd
              Schedule ID:    Sd3795321sf95es49fbsbb32sd113fdf1726f
               Start Time:    2017-05-17 13:04:21
                 End Time:    2017-05-17 13:04:22
 

    Message Code    Message Text

    BTP1010         Schedule Executed On Demand at gvllc617a.dolgen.net:8200
    BTP1010         Job placed in the waiting queue at 2017-05-17 13:04:21.277-0500 (1,495,044,261,277)
    BTP1010         Job started running at 2017-05-17 13:04:21.278-0500 (1,495,044,261,278)
    BTP1010         Job remained in waiting queue for 0.001 seconds
    BTP1020         Starting task: Task 1
    BTP1020         Task type: WebFOCUS Report
    BTP1020         Task domain: eongou02/
    BTP1020         Retrieving WebFOCUS Report: IBFS:/WFC/Repository/eongou02/std_reports/reportsdevel/DailyShrinkFlash/car.fex
    BTP1020         Connecting to server EDASERVE with execution id svc-ebr at 2017-05-17 13:04:21.357-0500 (1,495,044,261,357)
    BTP1020         Connection to the Reporting Server EDASERVE established at 2017-05-17 13:04:21.440-0500 (1,495,044,261,440)
    BTP1020         The time to establish a connection to the Reporting Server EDASERVE was 0.083 seconds
    BTP1020         Executing focexec.
    BTP1020         Connection to the Reporting Server EDASERVE closed at 2017-05-17 13:04:22.135-0500 (1,495,044,262,135)
    BTP1020         Job ran on the Reporting Server EDASERVE for 0.695 seconds
    BTP1020         Task error: incoming signal 'rt(sig f(OPFSIGNAL)  ' 4842484f 4c442e48 544d2020 20202020  *HBHOLD.HTM......* 20202020 20202020 20202020 20202020  *....
    BTP1010         No report to distribute.
    BTP1010         Job finished at 2017-05-17 13:04:22.151-0500 (1,495,044,262,151)
    BTP1010         Job time on distribution server after the report completed was 0.0 seconds
    BTP1010         Total running time was 0.873 seconds
    BTP1010         Total elapsed time (including the queue time) was 0.874 seconds
 

quote:

Originally posted by MartinY:

quote:

'Override the Format Specified in the Procedure' is unchecked, however I have checked this box before and set to 'EXL07'

You need to keep that check box "checked".

Yep, I have it checked.

quote:

Task error: incoming signal 'rt(sig f(OPFSIGNAL) ' 4842484f 4c442e48 544d2020 20202020 *HBHOLD.HTM......* 20202020 20202020 20202020 20202020 *....

What is that ????

You got that error running my sample fex ?

My last suggestion prior to the one where I will suggest you to open a case with support, is to restart everything : client, RS, RC, DS, and at worst, the whole server where your IBI products are installed.

I have no more ideas since it does work on my side and have also been validated by someone else.

GL

quote:

Originally posted by MartinY:

quote:

Task error: incoming signal 'rt(sig f(OPFSIGNAL) ' 4842484f 4c442e48 544d2020 20202020 *HBHOLD.HTM......* 20202020 20202020 20202020 20202020 *....

What is that ????

You got that error running my sample fex ?

My last suggestion prior to the one where I will suggest you to open a case with support, is to restart everything : client, RS, RC, DS, and at worst, the whole server where your IBI products are installed.

I have no more ideas since it does work on my side and have also been validated by someone else.

GL

OK. Thanks Martin for your help. I am a business user of WF and not in IT, so I will pass your suggestion along to them.

Sorry about the repost

WebFOCUS Release 8.1 Version 05M > ReportCaster > ReportCaster > Tips and Techniques for Coding a ReportCaster Report
Compound Reports and Coordinated Compound Reports
ReportCaster can distribute compound reports developed using the Document Composer in Developer Studio in AHTML, DHTML, EXL2K, PDF, and PPT formats.
ReportCaster can burst and distribute coordinated compound reports developed using the Document Composer in Developer Studio in DHTML, PDF, and PPT formats.

ReportCaster Burst Formats

I do use the bursting feature with XLSX format (Excel 07) under WF8105M.

My sample is working perfectly distributing report to several recipient where one is receiving all reports (the 15 attachments) and another just receive ENGLAND (3 attachments).

But not as 1 file with 3 tabs. To perform such a thing, another technique/format must be used.

quote:

Originally posted by tomatosauce:
Sorry about the repost

WebFOCUS Release 8.1 Version 05M > ReportCaster > ReportCaster > Tips and Techniques for Coding a ReportCaster Report
Compound Reports and Coordinated Compound Reports
ReportCaster can distribute compound reports developed using the Document Composer in Developer Studio in AHTML, DHTML, EXL2K, PDF, and PPT formats.
ReportCaster can burst and distribute coordinated compound reports developed using the Document Composer in Developer Studio in DHTML, PDF, and PPT formats.

ReportCaster Burst Formats

Webfocus is one of the most frustrating tools I've ever worked with. Apparently you're saying this is not supposed to be possible per the documentation and yet two people above have verified doing it.

I don't get it.

quote:

Originally posted by MartinY:
I do use the bursting feature with XLSX format (Excel 07) under WF8105M.

My sample is working perfectly distributing report to several recipient where one is receiving all reports (the 15 attachments) and another just receive ENGLAND (3 attachments).

But not as 1 file with 3 tabs. To perform such a thing, another technique/format must be used.

For what its worth, my version of WF appears to be 8007

Pay attention

quote:

in Developer Studio

since there is now also Application Studio (AS) to consider and since I've seen many differences between both tools, it could be possible that it's not available using DS but possible with AS...

I haven't used any of them to create the sample fex, I've used Editor. Could it also make a difference ????......

quote:

For what its worth, my version of WF appears to be 8007

Could also be a path to explore...

Getting back to my last suggestion : Open a case with support.

quote:

Originally posted by MartinY:
Pay attention

quote:

in Developer Studio

since there is now also Application Studio (AS) to consider and since I've seen many differences between both tools, it could be possible that it's not available using DS but possible with AS...

I haven't used any of them to create the sample fex, I've used Editor. Could it also make a difference ????......

I dumped your code into text editor within Dev Studio to create the sample .fex

quote:

I dumped your code into text editor within Dev Studio to create the sample .fex

I believe you, reason why you should open a case with support. It may be related to your WF version or using DS.

But on my side it's text editor under AS.

Tag this discussion with [CASE-OPEN] since I don't think that we'll able to help you further more and keep us informed of development.

quote:

Originally posted by MartinY:

quote:

I dumped your code into text editor within Dev Studio to create the sample .fex

I believe you, reason why you should open a case with support. It may be related to your WF version or using DS.

But on my side it's text editor under AS.

Tag this discussion with [CASE-OPEN] since I don't think that we'll able to help you further more and keep us informed of development.

Will do. Thanks again for trying to help.

manglum, did you get the compound excel report to burst?