Reporting Services Custom Formatting

hi,
I am using reporting services 2008, and I am trying to show my TaskId field as 3 digits..i.e "000"
So for example, if I don't format it, it will show as 1, 2 or 3....etc
When I use Format(MyFieldId.Value, "000) from the Placeholder Properties, it shows just fine as ...i.e: 001, 002, 011 (Which is what I want) EXCEPT exporting the report to Microsoft Excel will show me the formatted field column as "#VALUE!" And If I remove the formatting from the reporting services and export it again to Excel it would show just fine but as 1,2, 11...etc

Exporting it to any other file..pdf, word, html will work fine with the custom formatting being set to "000" ONLY excel does not like it.

does anyone know how to fix this issue?
Thanks
smaguireAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
Advertise Here
 
Chris LuttrellConnect With a Mentor Senior Database ArchitectCommented:
Try this instead for the custom format for that cell, I just tried it in 2008 exporting to Excel and it worked for me, I guess maybe the part to do the negative format makes the difference.
000;(000)

SSRS2008CustomNumberFormatting.png
0
 
smaguireAuthor Commented:
That was it, Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.