This content has been marked as final. Show 3 replies
The best way to achieve this is to actually call the report in two separate ways. To run the "conventional" layout, you would use DESFORMAT = PDF or perhaps HTML. When you run it for Excel output change the DESFORMAT to DELIMITED_DATA.
ok. but after delimited data, how it will open with excel ?
Set your file associations on your desk top such that csv files are opened by Excel.
When you click on the resulting CSV file output by the report, Excel will automatically open the file.