Cells merge issue when extracting webi report in excel format

[rishabh_singhania]

Hi Experts,

We have some WEBI reports in BO XI 3.1.

The reports have header where we are showing report name and some values which user selects in prompt.

Now the issue is that when we save our webi report in excel format, many cells get merge.

I have read many post on scn which suggest some solutions like changing the autofit width option to no and aligning the header width with colums.

Tried both the option but no success.

Is there any other way to achieve this.

Thanks in advance,

Regards,

Rishabh

[rishabh_singhania]

Hi,

We managed to find the workaround for this merge cell issue.

Sharing it might be helpful for someone.

- Align the report name and other block in report in such a way that the ends are in line with the end point of any column. The only limitation is that when applying pivot to the excel output we neet to click on any of the ccolumn so that excel identify the data set.

- Second workaround is to break the webi document in two parts report1 will contain the report name and the block to show the prompt values selected by the user where as report2 will contain the table withactual data. The only limitation with this workaround is that when exporting the repot output to excel we will get two tabs in the excel sheet one containing the prompt values and secont tab containing the actual data.

Regards,

RS