Hi All,
Is there a restriction on using "OPEN NOBREAK" option while using a template in Excel.
Code is something like this:
ON TABLE PCHOLD FORMAT EXL2K OPEN NOBREAK TEMPLATE 'tmplt1'
......
some code
......
ON TABLE PCHOLD FORMAT EXL2K CLOSE TEMPLATE 'tmplt1'.

Its giving EOF (end of file) exception.
Any ideas?

Thanka,
Shyam

Actual error which I m getting is this:
Message Code Message Text

BTP1010 Starting worker thread
BTP1020 Starting task: Report
BTP1020 Task type: MR Standard Report
BTP1020 Retrieving MR report: app/report
BTP1020 Connecting to server EDASERVE with execution id 1
BTP1020 Executing focexec.
BTP1010 Task error:Pcb2.: java.io.EOFException
BTP1010 No report to distribute.

I have referred to the previous posts on the same subject, but none of them seems to answer this case.

Scheduling from report Caster and using an excel template while generating output on a single page. I just have one sheet in my output and want to concatenate two Table file outputs one below the other.
Has anyone encountered this issue previously?

Thanks in advance,
Shyam L

This message has been edited. Last edited by: <Shyam L>,

OPEN, NOBREAK and CLOSE are COMPOUND syntax which is not what Templates are about.

Use COMPOUND only to do what you are attempting and NOT templates.

T

Tony, thanks for the post.
Does that mean you can never accomplish having a single page compound report in an excel template?

Without template its working fine. I need a Landscape Legal setting for the page which the excel macro is currently doing. Can it be accomplished in any other way?

I haven't done this, but you could try creating your reports in 2 different sheets and using the macro in the template to pull the data into one sheet.

Thanks Pat....will give it a try.