many time i asked the question in interview that can we have multiple layouts in reports 10g and 11g.
please help me .
my requirement is:
i have a report which has many feilds. so i arange fields up and down. but when i want same report in excel all the fields must be in single line.
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.