I have a request for a simple progress bar on an SSRS report. This scale of the progress bar is the starting date through the ending date of a project. This seems to be very simple until I want to format the scale as dates. Unfortunately, the labels are displayed as the sql server integer value of the date. So I go the "number" tab of the scale properties, and "date" is missing from the options. I choose custom and enter "MM/dd," to which the sample displays "01/31." I'm thinking, OK, thumbs up. Then, however, ALL the labels are displayed as the literal "MM/dd."
Hopefully the attachments will make the issues more clear.
Is it possible to format the scale as dates?
Thanx in advance,
Don Simpson
I'm not sure about Heisenberg.