I have a report that is displaying a parameter in a textbox inside the report.
Now I right clicked on the textbox, went to properties, and set number formatting to: Date - 01/31/2000
However, when I render the report it does not display the date in that format. It displays it in the way the sproc returns it which is: 5/13/2011 3:08:30 PM
I tried changing the parameter type to TEXT instead of datetime, made no difference.
I am having the same problem with currency. I will return 12345 and it will just display that way in the textbox instead of $12,345.00.
View Complete Post