Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bkana
Starting Member
18 Posts |
 Posted - 2007-01-04 : 10:50:16
|
| I have a report that runs transcripts for people. I have a date parameter setup along with last and first name. The date parameter field is used to specify what year (ex. 1/1/2006 - 12/31/2006) to pull the information for.Now..I have a text box at the bottom (Footer) of my report that says something to the affect of "Official transcripts for 2006". There will be times when I have to run the report using a different year other then "2006" in the date parameter field. How do I have the text at the bottom change to reflect the year I'm reporting on? If I use dates say in 2004 I need the text at the bottom to reflect that year and not 2006. Can this be accomplished?Thx,Bill |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-01-04 : 12:38:17
|
| Just use the Year function to get the year from the date parameter in the textbox expression, it will look something like this=Year(Parameters!yourparameter.Value) |
 |
|
|
bkana
Starting Member
18 Posts |
Posted - 2007-01-04 : 13:53:53
|
| Thanks snSQL, I'll give it a try. |
|
|
|
|
|
|
Date parameters