Hi,

I have an excel report with say sorting on field COUNTRY. I also have Page Break on COUNTRY field. My requirement is that once Country changes from US to ENGLAND, ENGLAND's data should be displayed in a new excel worksheet. Similarly from ENGLAND to FRANCE, France's data should come in new sheet. So on and so forth.

Hence how to create and populate data in new xls worksheets as the sort field changes its value?

Regards,
CD

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

Digger,

Try this:

TABLE FILE CAR
SUM
SALES
BY COUNTRY
BY CAR BY BODYTYPE
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
-* This creates the multiple worksheets
ON TABLE SET COMPOUND 'BYTOC 1'
-*
ON TABLE SET HTMLCSS ON
END

I believe the only thing that creates multiple sheets in excel is creating a compound report. Unless there is some fancy styling that will allow it. I learn something new about FOCUS/WebFOCUS almost every day any more.

Looking at this 4 years later and it still works for Excel 2000 but:

TABLE FILE CAR
SUM
SALES
BY COUNTRY
BY CAR BY BODYTYPE
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL07
-* This creates the multiple worksheets
ON TABLE SET COMPOUND 'BYTOC 1'
-*
ON TABLE SET HTMLCSS ON
END

leaves Excel to complain that "Repaired Records: Worksheet properties from /workbook.xml part (Workbook)". Is there a new way to do this with Excel 2007?

WF 7.7.02/AIX/Websphere running on Win2008