Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
replace empty cells with decimal values in Birt cross tab
Migrateduser
<p>Hi,</p>
<p> </p>
<p>I have created one cross tab report and it contains one column to show currency values and used "For Empty cells, show:" option to replace all empty cells with 0.00 value.</p>
<p> </p>
<p>After exporting report to excel these replaced values are showing as String in excel and showing some error 'Number in cell is formatted as Text......'.</p>
<p> </p>
<p>Is there any way to provide data type also for empty cell values ?</p>
<p> </p>
<p> </p>
<p>or is there any approach which can fix this issue ?</p>
Find more posts tagged with
Comments
There are no comments yet