Share
Report
330I have a MR reports where i had set the report to generate amount in RED when is negative. When the report is perfectly fine when displayed on Report Viewer but when export to EXCEL, those with format/currency override set on column/report will show the word [Red] on those value with zero. When check on the excel format, found that the format was showing as ###0.00%;(###0.00%);\[\R\e\d\] causing any cell with 0% to be replaced with the word [Red].
Is there a way to overcome this problem?
Appreciate all suggestions.
Thanks
May
*This post is locked for comments
All responses (
Answers (
