I have a detail report that uses an EXL2K Template. Report works fine. I have a request to add a simple summary report. I've tried several things and nothing works. For example, this does not work:

TABLE FILE CAR
PRINT CAR MODEL
ON TABLE PCHOLD FORMAT EXL2K TEMPLATE TEST1 SHEETNUMBER 1
END
TABLE FILE CAR
PRINT MODEL CAR
ON TABLE PCHOLD FORMAT EXL2K TEMPLATE TEST1 SHEETNUMBER 2
END

I don't get any errors but only SHEETNUMBER 1 is produced.

I also tried named ranges but that doesn't help. All that seems to happen there is the WF creates a named range, it does not place the report in a predefined named range that already exists in the template.

I also found this on IBI's website, but it does not work, it does not use a template.

How to produce multiple requests on one EXL2K Template.

If I could get both reports on sheet 1, then within the macro, I could cut and paste it to sheet 2.

Anyone know how to get 2 separate reports into one template?

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

Only the last output should use PCHOLD, the interim ones should HOLD to a predefined web archive file

T

Tony, thanks for the reply but when I do this:

TABLE FILE CAR
PRINT CAR MODEL
ON TABLE HOLD FORMAT EXL2K TEMPLATE TEST1 SHEETNUMBER 1
END
TABLE FILE CAR
PRINT MODEL CAR
ON TABLE PCHOLD FORMAT EXL2K TEMPLATE TEST1 SHEETNUMBER 2
END

Only SHEETNUMBER 2 has data, SHEETNUMBER 1 is blank. Just for the record, my template file has 3 worksheets and each worksheet has a blank in cell A1.

jg,

The output of the first HOLD should be a temporary .mht file which you will have to FILEDEF and use as input to your second pass.

FILEDEF tempmht DISK tempmht.mht
-RUN
TABLE FILE CAR
PRINT CAR MODEL
ON TABLE HOLD AS tempmht FORMAT EXL2K TEMPLATE TEST1 SHEETNUMBER 1
END
TABLE FILE CAR
PRINT MODEL CAR
ON TABLE PCHOLD FORMAT EXL2K TEMPLATE tempmht SHEETNUMBER 2
END

T

Tony, that works. Thanks very much.

Else, you can use EXL2K OPEN CLOSE NOBREAK to get mutiple sheets in same excel file.

Thanks

Enigma, thanks for the reply, but OPEN/CLOSE does not work with Templates. From what I have been able to find, at least in 7.1.3, what Tony shows above is the only way to get it to work.