Hai all..

I am working on different reports which need to be displayed in one excel sheet but 4 different tabs.

I am able to display them the way needed using EXL2K open and close for 3 reports. But the problem is with the 4th report which is a combination of 3 reports.

4th report is like.

TABLE FILE A
PRINT *
--STYLESHEET
END
TABLE FILE B
PRINT *
--STYLESHEET
END
TABLE FILE C
PRINT *
--STYLESHEET
END

How can this 4th report be shown in one tab (th tab) in the excel sheet with initial 3 reports?
Not sure if I can hold data and do something.

Hope I did not confuse some folks.
Thanks.

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

This link provides help for creating compound reports - see the section for "Creating a Compound Excel Report". I believe the NOBREAK option is what you are looking for.

Creating a Compound Report

Thanks Dan. NOBREAK worked..!!