Issue with Webi Report when Exporting to Exel

[Former Member]

Hi Guys,

I have an issue with webi report  when i am exporting to Exel

actually bellow is my report format I have done the sections based on currency, product ,industry and I have taken a blank cell and inserted the amount values if i place the amount cell on the particular section then it will give the section total amount up to here every thing is fine

but when I export the report to exel the amount cell displaying down to the row, its taking as separate row 

bellow is the screen shot

can any one help

thanks in advance

[former_member189638]

Use Table instead of Free standing cells... relative positioning does not work well with blank cells as it is not considered as block.

[Former Member]

Thanks for rply

even if use table instead of Blonk getting same issue

any other solutions...

thanks

[Former Member]

Hi Mahi,

Try to use the vertical table by removing/hiding header, add two rows below and size the height of each cell matching to currency, product and Industry cells on main block and overlay this on the main block to show the amount values in it, this offers you similar formatting capability as your other block and would be consistent as the other block with your formatting, you can avoid such issues when exporting to Excel.

Thanks

Mallik

[Former Member]

Thanks for rply

even if use table instead of Blonk getting same issue

any other solutions...

thanks

[Former Member]

Hi Mahi,

Why not try calculating Amount Total at each level as within the Amount column itself instead of going for overlaying blank cells or another piece of block. and  merge the header for each section up to product column. This way formatting in excel would not be an issue at all.

Thanks

Mallik

[Former Member]

Hi Malik,

Thanks for Rply

can you please elaborate the above solution and if I fold the section does it give the total for each section..? like bellow

this is normal view

and if i fold it has to show  like below

[Former Member]

Hi Mahi,

As far as i know, It should work. try using calculation context and Nofilter function to calculate section level totals within block headers. I have used below to come up with Year total within the block header. You can try to derive your totals in below lines using calculation context, I think you can avoid formatting issues from Excel side.

=NoFilter(Sum([Quantity]) ForAll([Quarter]))

Thanks

Mallik