Exporting to Excel using XML or BIFF exclude decimal value

I have problems when i want to export to Excel. I have tried using XML and BIFF component. I need to display a number in non decimal format, so I use "#,##0 " format. There are 2 problems;

  • First problem is that it always do round down, if i have 10,5 value it will be displayed with 10,
  • Second problem is that when i export it to excel, it removed the decimal value, so it will export he value as displayed

The report is simple, consist only a master band and a report summary band, where in the master band i put a numeric value, and in the report summary band, i put a sum of that numeric value

For each record, it will display the value round downed, but on the report summary page actually perform a sum of values with decimal then round on that value. So after i export it to excel, the value when i select all record will be different to the value in the report summary

Here is a sample to make it clearer:

This is to illustrate the problem.

As you can see display format will always round down on master band, but not on Report Summary. Round down on values with exact half on it's decimal value

This is from the report viewer, the left side is the real value, the right side is the formatted display value

Hope it clear enough to understand my question

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.