Hi,
I will be passing a single input parameter from the launchpage say Country which is a listbox(using Table file car) to the fex.If the user selects 2 countries from the launchpage,then I want each country details to be displayed in a single tab of the excel sheet.Could anyone please tell me how to do this.

Thanks a lot in advance.

This message has been edited. Last edited by: <Kathryn Henning>,

  
TABLE FILE CAR
BY  LOWEST CAR.ORIGIN.COUNTRY
BY  LOWEST CAR.COMP.CAR
BY  CAR.BODY.DEALER_COST
BY  CAR.BODY.RETAIL_COST
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET COMPOUND 'BYTOC 1'
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
ENDSTYLE
END

Add a Table of Contents (TOC) to get a new worksheet for each selection of the first BY field. It is the last item on the right click menu of a BY field

Since I cannot tell if you are a code person or a tools person, look up BYTOC for code and/or Table of Contents report for tools. On the primary sort field of a report, they will send each section to a separate tab in the workbook. Good luck!