smaguire
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER