I have created a SQL report that uses 2 parameter fields:
1. StartDate a date-time field (in the form of MM-DD-YYYY e.g. 03-01-2005
for March 1, 2005)
2. EndDate a date-time field (in the form of MM-DD-YYYY e.g. 09-27-2005 for
September 27, 2005)
In my report I have a logo in the page header with the following text placed
beside the logo:
[Logo]Examination Branch Exam Status Report
In the period of: [Start Date] "to" [End Date]
The parameter fields display next to the logo as 03-01-2005 to 09-27-2005
How do I get these parameter fields to display like this:
[Logo]Examination Branch Exam Status Report
In the period of: March 1, 2005 to September 27, 2005 - in other words
display dates as text!
I know that you can do this with Crystal Report parameter fields but I am a
bit new to SSRS.
Thanks again for any help on this.
John Falloon
1. StartDate a date-time field (in the form of MM-DD-YYYY e.g. 03-01-2005
for March 1, 2005)
2. EndDate a date-time field (in the form of MM-DD-YYYY e.g. 09-27-2005 for
September 27, 2005)
In my report I have a logo in the page header with the following text placed
beside the logo:
[Logo]Examination Branch Exam Status Report
In the period of: [Start Date] "to" [End Date]
The parameter fields display next to the logo as 03-01-2005 to 09-27-2005
How do I get these parameter fields to display like this:
[Logo]Examination Branch Exam Status Report
In the period of: March 1, 2005 to September 27, 2005 - in other words
display dates as text!
I know that you can do this with Crystal Report parameter fields but I am a
bit new to SSRS.
Thanks again for any help on this.
John Falloon