Hello Community. This topic has been seen in the previous ve...

[Patrick Pienkowski]

Hello Community. This topic has been seen in the previous version of forums as well as this new forum. I have had no luck in finding a solution to this. I am wondering if anyone has found a solution to burst a report with multiple sheets that have different columns (Summary and Detail). I currently am able to burst but the second tab is created as another report instead of a second sheet. So if I run a report that is to be sent to 5 users, I will receive 10 reports. One report for summary and one report for detail instead of 5 reports with a sheet for summary and a sheet for detail. Please let me know if anyone has a solution for this! The below code is what currently bursts as separate reports instead of sheets.

-****************************************************** SUMMARY ************************************************

-IF &RPTTYP EQ 2 GOTO RPTTYP2;

TABLE FILE HOLDMAIN345

SUM TOTALS AS Totals

DISP AS Disposables

COMPUTE TOTPERC/D12.2% = DISP / TOTALS * 100; AS Disposables,% Of Total

COMPUTE CARPERC/D12.2% = (CARRY + CUT + DRINK + ENVI) / DISP * 100; AS Carry Out,% Of Disposables

CARRY AS Carry Out,Packaging

CUT AS Cutlery /,Cutlery Kits

DRINK AS Disposable,Drinkware

ENVI AS Environmental

BY &BYDST NOPRINT

BY DWRSMN AS RSM

BY DWDSMN AS DSM

BY DWREPN AS SALES REP

&TOTALS

&TOTALS2

ON TABLE PCHOLD FORMAT EXL07 &OPEN

&PAGEBREAK

HEADING

 

&REPORTNAME

&FDATE - &TDATE

Edward Don and Company Confidential and Proprietary

Created On: <+0> &DATEtrMDYY

ON TABLE SET HTMLCSS ON

ON TABLE SET STYLE *

UNITS=IN,

PAGESIZE=LEGAL,

LEFTMARGIN=0.250000,

RIGHTMARGIN=0.250000,

TOPMARGIN=0.250000,

BOTTOMMARGIN=0.250000,

SQUEEZE=ON,

ORIENTATION=LANDSCAPE,

$

TYPE=REPORT,

TITLETEXT=SUMMARY,

$

TYPE=TITLE,

STYLE=BOLD,

JUSTIFY=CENTER,

BACKCOLOR=LIGHT GRAY,

$

TYPE=DATA,

COLUMN=TOTALS,

COLOR=RED,

WHEN=TOTALS LT 0,

$

TYPE=DATA,

JUSTIFY=CENTER,

$

TYPE=FOOTING,

STYLE=BOLD,

$

TYPE=GRANDTOTAL,

STYLE=BOLD,

JUSTIFY=CENTER,

$

TYPE=FOOTING,

STYLE=BOLD,

$

TYPE=SUBTOTAL,

STYLE=BOLD,

JUSTIFY=CENTER,

$

ENDSTYLE

END

-RUN

-IF &RPTTYP EQ 1 GOTO END345;

-RPTTYP2

-****************************************************** DETAIL ************************************************

TABLE FILE HOLDMAIN345

SUM TOTALS AS Totals

DISP AS Disposables

CARRY AS Carry Out Packaging

CUT AS Cutlery / Cutlery Kits

DRINK AS Disposable Drinkware

ENVI AS Environmental

BY &BYDST NOPRINT

BY DWRSMN AS RSM

BY DWDSMN AS DSM

BY DWREPN AS SALES REP

BY CLASS AS Class Name

BY SUBCLASS AS Subclass Name

BY CUSTNUM AS CUSTOMER #

BY CUSTNM AS CUSTOMER

ON &BYDST RECAP

AVGCALC/D12.2% = (DISP / TOTALS) * 100;

AVGCALC2/D12.2% = ((CARRY + CUT + DRINK + ENVI) / (DISP)) * 100;

ON &BYDST SUBFOOT WITHIN

<+0><+0><+0><+0><+0><+0><+0>PERCENT OF TOTAL: <AVGCALC

<+0><+0><+0><+0><+0><+0><+0>PERCENT OF DISPOSABLES: <AVGCALC2

&TOTALS

&TOTALS2

ON TABLE PCHOLD FORMAT EXL07 &CLOSE

&PAGEBREAK

HEADING

 

&REPORTNAME

&FDATE - &TDATE

Edward Don and Company Confidential and Proprietary

Created On: <+0> &DATEtrMDYY

ON TABLE SET HTMLCSS ON

ON TABLE SET STYLE *

UNITS=IN,

PAGESIZE=LEGAL,

LEFTMARGIN=0.250000,

RIGHTMARGIN=0.250000,

TOPMARGIN=0.250000,

BOTTOMMARGIN=0.250000,

SQUEEZE=ON,

ORIENTATION=LANDSCAPE,

$

TYPE=REPORT,

TITLETEXT=DETAIL,

$

TYPE=TITLE,

STYLE=BOLD,

JUSTIFY=CENTER,

BACKCOLOR=LIGHT GRAY,

$

TYPE=DATA,

COLUMN=TOTALS,

COLOR=RED,

WHEN=TOTALS LT 0,

$

TYPE=DATA,

JUSTIFY=CENTER,

$

TYPE=FOOTING,

STYLE=BOLD,

$

TYPE=GRANDTOTAL,

STYLE=BOLD,

JUSTIFY=CENTER,

$

TYPE=SUBFOOT,

STYLE=BOLD,

$

TYPE=SUBTOTAL,

STYLE=BOLD,

JUSTIFY=CENTER,

$

ENDSTYLE

END

-RUN

-END345

Much appreicated!

[Charles Morris 2]

Try adding NOBREAK after the EXL07 OPEN - this should force the 2nd report to another sheet within the same workbook

e,g, PCHOLD FORMAT EXL07 OPEN NOBREAK

[Patrick Pienkowski]

Hey Charles, thanks for the quick response. I have tried this and unfortunately that does not work either.

[Toby Mills]

Hi Pat

Im trying to narrow down where things might go wrong.

If you leave out the idea of Bursting - does this report look right to you in Excel (with 2 reports each on their own worksheet)

if that works, and bursting doesnt, thats a good thing to know.

Thanks

Toby

[Charles Morris 2]

why are the OPEN and CLOSE shown as &OPEN and &CLOSE I dont see these pre-specified anywhere and they are specific keywords. Sorry, I didnt notice this before

[Patrick Pienkowski]

Toby,

If you are asking if the reports end up on one worksheet (2 tabs) without bursting, then yes sir it does.

Pat

[Patrick Pienkowski]

Charles,

Sorry I did not specify those. You can disregard the &'s and see them as regular OPEN and CLOSE. It did not work either way.

Thanks,

Patrick Pienkowski

[Manoj Chaurasia]

HI Patrick

First of all welcome to myibi If this is still an issue for you please open a case with techsupport.