Management Reporter settings - Red when negative - Export to Excel

(0) Share

Report

Posted on by Yoke May

330

I 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

I have the same question (0)

All responses (1)

Answers (0)

Greg Byer 2,586 on at

Like (0)

Report

Hi May,

What is the Format/Currency Override set to in the column definition? I would verify that you do not have anything set for the zero value override text. If there is anything there, remove it and try the report again.

Was this reply helpful? Yes No