Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 955
  • Last Modified:

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
0
smaguire
Asked:
smaguire
1 Solution
 
Chris LuttrellSenior 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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now