on 07-04-2013 1:06 PM
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
Use Table instead of Free standing cells... relative positioning does not work well with blank cells as it is not considered as block.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
77 | |
11 | |
8 | |
8 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.