[sprabhakar]

Hi,

We have this fuctionality working on OTM versions 4/5.0 &5.5 on more than 50 reports. Please do the following to achieve this.

1. Copy the report headers into HEADER section of the report
2. Delete them from the MAIN section of the report
3. When invoking the the report, pass the parameter "desformat=DELIMITED"

You should see the report open in MS Excel with proper headers.

If you are seeing data being repeated, there are other ways to resolve it. One of them is
to
1. Keep just one repeating frame in the MAIN section of the report
2. Pickup all possible data required to display in the main query
3. Generate data for all others fields through formula columns inside the main query.

This is just one of the ways. Please revert & we will advice you of other options if this is difficult for you to achive.

Thanks
Prabhakar