Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using Parameter Field as "Text" in page Header of a Report

Status
Not open for further replies.

sumgait

Programmer
Jun 14, 2001
21
0
0
CA
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top