Hello! I am trying to run two different procedures within a focexc to get the report to distribute to tabs (worksheets) with one Excel workbook. However I'm not having much luck.

Below is what I have so far:

APP HOLD reportengine
-MRNOEDIT BEGIN
SQL SQLMSS
EX storedprocedure_daily;
-MRNOEDIT END
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS DUKACT FORMAT FOCUS
END
APP HOLD reportengine
-MRNOEDIT BEGIN
SQL SQLMSS
EX storedprocedure_daily_q;
-MRNOEDIT END
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS DUKQACT FORMAT FOCUS
END
TABLE FILE DUKACT
PRINT
column info
HEADING
"report name"

ON TABLE SET PAGE-NUM OFF
ON TABLE SUMMARIZE AS 'TOTAL'
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='SCREEN',
LEFTMARGIN=0.500000,
RIGHTMARGIN=0.500000,
TOPMARGIN=0.500000,
BOTTOMMARGIN=0.500000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=9,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
RIGHTGAP=0.125000,
TOPGAP=0.013889,
BOTTOMGAP=0.027778,
titletext='Daily Activity',
$
TYPE=DATA,
COLUMN=N9,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
FONT='TIMES NEW ROMAN',
BACKCOLOR='SILVER',
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
FONT='TIMES NEW ROMAN',
SIZE=14,
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
FONT='TIMES NEW ROMAN',
SIZE=10,
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=2,
OBJECT=TEXT,
ITEM=2,
FONT='TIMES NEW ROMAN',
SIZE=10,
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=2,
OBJECT=TEXT,
ITEM=3,
FONT='TIMES NEW ROMAN',
SIZE=10,
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=3,
OBJECT=TEXT,
ITEM=1,
FONT='TIMES NEW ROMAN',
SIZE=10,
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=3,
OBJECT=TEXT,
ITEM=2,
FONT='TIMES NEW ROMAN',
SIZE=10,
STYLE=NORMAL,
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
TYPE=REPORT,
COLUMN=N9,
SQUEEZE=0.555556,
$
TYPE=REPORT,
COLUMN=N3,
SQUEEZE=0.791667,
$
TYPE=REPORT,
COLUMN=N4,
SQUEEZE=0.791667,
$
TYPE=REPORT,
COLUMN=N5,
SQUEEZE=0.583333,
$
TYPE=REPORT,
COLUMN=N6,
SQUEEZE=0.652778,
$
TYPE=REPORT,
COLUMN=N7,
SQUEEZE=0.527778,
$
TYPE=REPORT,
COLUMN=N8,
SQUEEZE=0.666667,
$
TYPE=REPORT,
COLUMN=N10,
SQUEEZE=0.680556,
$
TYPE=REPORT,
COLUMN=N11,
SQUEEZE=0.597222,
$
TYPE=REPORT,
COLUMN=N12,
SQUEEZE=0.680556,
$
TYPE=REPORT,
COLUMN=N13,
SQUEEZE=0.625000,
$
ENDSTYLE
ON TABLE HOLD AS EX1 FORMAT EXL2K OPEN
END
TABLE FILE DUKQACT
PRINT
column info
HEADING
"report name"
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='SCREEN',
LEFTMARGIN=0.500000,
RIGHTMARGIN=0.500000,
TOPMARGIN=0.500000,
BOTTOMMARGIN=0.500000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
TITLETEXT='Quote Activity',
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=9,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
RIGHTGAP=0.125000,
TOPGAP=0.013889,
BOTTOMGAP=0.027778,
$
TYPE=DATA,
COLUMN=N9,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
BACKCOLOR='SILVER',
STYLE=BOLD,
TOPGAP=0.013889,
BOTTOMGAP=0.027778,
JUSTIFY=CENTER,
$
TYPE=REPORT,
COLUMN=N8,
SQUEEZE=0.458333,
TOPGAP=0.013889,
BOTTOMGAP=0.027778,
$
ENDSTYLE
ON TABLE HOLD FORMAT EXL2K CLOSE
END

I'm sure that I am missing something easy, I would greatly appreciate someone pointing out the easy mistake.

Thanks,
Jason

JBucks,

ON TABLE HOLD AS EX1 FORMAT EXL2K OPEN

Switch HOLD to PCHOLD where and remove the AS EX1.

ON TABLE HOLD FORMAT EXL2K CLOSE

Switch HOLD to PCHOLD

That should get it to work.

Fletcher

Look at this post:
https://forums.informationbuilders.com/eve/forums/a/...341019331#7341019331

It's about bursting a report to multiple worksheets in a workbook using new syntax in 5.3 in case you are interested.

Brilliant! Thank you it worked perfectly.