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 |
|
MattHeid
Starting Member
7 Posts |
 Posted - 2007-03-21 : 16:31:14
|
| Hello all,Hope that someone can help with this. I am trying to write an expression that will return a date using the two of the parameters on the report. I tried using CAST but VS will not allow that. The parameters are..Parameters!Month.ValueParameters!Year.Value There are going to be twelve columns on the report, each one representing a month out of the time frame selected. If the user were to select January 2007 the columns would then display --Jan 07, Dec 06, Nov 06 and so on. Thanks so much for any help in this. |
|
|
MattHeid
Starting Member
7 Posts |
Posted - 2007-03-21 : 17:40:21
|
| I was able to convert to date and pull the month.. However, I am still stuck trying to DATEADD to get the months to roll back.This is what I have so far.=MonthName(Month(DateSerial(Parameters!Year.value,Parameters!month.Value))) |
 |
|
|
|
|
|
Creating Date From Parameters