Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

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


Patrick Pienkowski

Recommended Posts

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!

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...