We are running against oracle, If I run the query against oracle in a tool outside of webfocus it runs in 2.5 minutes returns 89,000 rows.
I'm using sql passthrough, if I load the data out to a hold file it's done in 2.5 minutes, when I try to output it to EXL07 it runs for more than 1 hour and I kill it.


here is the code after the sqlout
TABLE FILE SQLOUT
PRINT
MFG_HOURS
BY PLANT_C NOPRINT
BY DEPARTMENT_X NOPRINT
BY PART_X NOPRINT
BY WORKORDER_X AS 'Workorder '
BY OPERATION_SEQ_N AS 'CURR'
BY OPERATION_DESCR_X AS 'OPER'
BY DUE_D AS 'SHIP DTE'
ACROSS WEEK_DUE

ON PLANT_C PAGE-BREAK

ON DEPARTMENT_X PAGE-BREAK
HEADING
" XXXXX YYYYYYYY I N C. <+0>DATEMDYY "
" SCHEDULED STANDARD HOURS (ACCOUNTING STDS)"
" FOR DEPT ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL07
ON TABLE SET STYLE *
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=8,
STYLE=NORMAL,
$
ENDSTYLE
END



****** Any ideas what I'm doing wrong? or need to change....thanks

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

WebFOCUS 7.7.1
Windows 2000
Output: Excel and PDF

Looks like your missing " at the end of "FOR DEPT and no END to terminate the report.

This is what happens when people do not post code between

[code]

[/code]

tags, the <FIELDNAME gets translated to HTML and disappears.

Have you tried running the simplest of code to test Excel 2007:

TABLE FILE CAR
PRINT
*
ON TABLE PCHOLD FORMAT EXL07
END

That is part of the title
the rest of the code is
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL07
ON TABLE SET STYLE *
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=8,
STYLE=NORMAL,
$
ENDSTYLE
END


It's not excel because I have other reports that use excel with no problems.

What do you mean about posting code?

quote:

Originally posted by Francis Mariani:
This is what happens when people do not post code between

[code]

[/code]

tags, the
Have you tried running the simplest of code to test Excel 2007:

TABLE FILE CAR
PRINT
*
ON TABLE PCHOLD FORMAT EXL07
END

There was a recent post about slow performance with EXL2K as an output format. I thought this might be that posting actually.

- ABT

quote:

What do you mean about posting code?

When you post code, please use the code tags as Francis has pointed out.

In the buttons above the text entry area, there is one that looks like </>.

Using this stoped the browser trying to evaluate the code a HTML.

Resolved hopefully going to 7.7.3 where we are able to set excel congfigurations