Excel Number
How do i make the excel sum work on the XLS output obtained from BI Publisher ?
You have make use of the template better.
1. Do select the form-field by double clicking it
1.1. A property window will pop-up
2. Choose the number as the datatype for the field
3. Choose the Number format, you want to see as number.
Note: by default every other field could be String or Regular text.
Here is the small samples for it.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEHZL_2RkMFBznrUYJ0FdixxW-E-KWCQc2bUwP32FqB-QbrXmT5u0yRbLbOjQatzU8SokJE_oy9PJASzdaUKo3-V6yYMSzvGegp-Llg9HSisi3rEGvS63Etet5VT2TntZIWDz1zw/s400/Number-excel.jpg)
You have make use of the template better.
1. Do select the form-field by double clicking it
1.1. A property window will pop-up
2. Choose the number as the datatype for the field
3. Choose the Number format, you want to see as number.
Note: by default every other field could be String or Regular text.
Here is the small samples for it.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEHZL_2RkMFBznrUYJ0FdixxW-E-KWCQc2bUwP32FqB-QbrXmT5u0yRbLbOjQatzU8SokJE_oy9PJASzdaUKo3-V6yYMSzvGegp-Llg9HSisi3rEGvS63Etet5VT2TntZIWDz1zw/s400/Number-excel.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrXFt-5DnswdMA0W8y5y_OviywrxX8FZZBIlZjIPrx3ytIsuMQi5l2o6cvFHmIyqgZCL_ROKHonzBduJXOnN80zmI9YjGCPnNVqGXVw2u50PRWKjE8g6zidlCTpBr1zTYPBreMLQ/s400/excel+Number.jpg)
Comments