Export to Excel

Question

Post reply

Export to Excel

Syed Asim Rizvi

Ten Centuries

Points: 1162
More actions
March 31, 2006 at 10:00 am

#168899

I have this report which shows particular vaules in RED color:
Now when I try to export this to Excel, it changes all the values to RED:
There is an Expression behind that changes color of the text according to user input.
Is there anything I can do, so that formatting will not change after exporting it to Excel?
Appreciated!

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

moe_mayne SSCommitted Points: 1933 More actions · Answer 1

moe_mayne

SSCommitted

Points: 1933

March 31, 2006 at 10:27 am

#630191

i can't see the broken images...

Moe C

Syed Asim Rizvi Ten Centuries Points: 1162 More actions · Answer 2

Oh man........ anyway,

I have this report that shows data in Matrix like:

NAME 1st Q 2nd Q 3rd Q 4th Q Total

ALISON LOUCKS 40 0 22 0 62

AMANDA DANIEL 5 19 11 9 44

AMANDA SIFFORD 0 20 1 4 25

Behind these numeric values there is an expression that changes color to RED if lets say the value is less than 10. This displays fine in Browser, but when exported to Excel, all the numeric values are shown in RED, like:

NAME 1st Q 2nd Q 3rd Q 4th Q Total

ALISON LOUCKS 40 0 22 0 62

AMANDA DANIEL 5 19 11 9 44

AMANDA SIFFORD 0 20 1 4 25

I know formulas can't be exported to Excel, is that true for Expressions as well?

moe_mayne SSCommitted Points: 1933 More actions · Answer 3

http://msdn2.microsoft.com/en-us/library/ms345242(SQL.90).aspx

Look at the Using Conditional Formatting part and in your propertiers select color and put a formula like that one in this link.... hope this helps .. oh and formulas come accross great for me in excel.. matrix and certain kinda of formulas and where you place them give you an error when you try exporting out to excel... that was one of my biggest problems was making every report excel exportible..

Moe C

Syed Asim Rizvi Ten Centuries Points: 1162 More actions · Answer 4

Thats exactly what I have and meant when I said there is an expression behind these numeric values:

=IIF( Fields!COUNTS.Value < Parameters!param_Highlight.Value, "Red","Black")

Therefore, my problem remains there but I really appreciates your reply.

What I'm wondering is that this problem is because I'm using Matrix not Table, where there is only one Data field...may be...

moe_mayne SSCommitted Points: 1933 More actions · Answer 5

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_dc_v1_5xkc.asp

Moe C

Scott Herbert-214404 Old Hand Points: 387 More actions · Answer 6

I found the answer here:

basically it's a bug, and there's a dodgy get-around.