This content has been marked as final. Show 5 replies
Can you paste a sample of your XML data?
For example, the negative value from the field 'VAL' displays fine in both the PDF and HTML formats. Have you tried to display the number without any formatting (formatting type - regular text)? Does it work?
my output XML is the following:
<DESCRIPTION>2005 Jeep Cherokee </DESCRIPTION>
I have tried without format number or with text type for the field, but the problem is the same:
- The previous output in XML is totally correct, but with other output, for example, HTLM or PDF, displays without negative symbol.
I think that maybe the problem is with the template in Word... For this reason, I have tried with a lot of masks but the problem persists. There are any option to configure in Word or BI Publisher to display these values? Wich is a correct mask to display these values?
Thank you and regards.
Edited by: user12085357 on 18-may-2010 23:45
Edited by: user12085357 on 18-may-2010 23:54
What version of the BI Publisher desktop do you have? I used the data you provided and was able to display the negative numbers with and without formatting. I used the formatting of #,##0.00 for the TOTAL field and the negative numbers display correctly. This is output in the PDF format.
Account CostActAA Total
2140 -15999.99 -15,999.99
forgive me the delay.
Finally, I resolved the problem with the following format mask from Microsoft Word:
I hope it helps.
Thanks and regards.