View Single Post
  #1 (permalink)  
Old January 7th, 2010, 12:16 PM
mcdew mcdew is offline
Registered User
Join Date: Jan 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Unhappy Calander Control in SSRS 2008

I am pulling may hair out over this issue. I am following the steps for Chapter 9 Using Date Parameters From SQL Server 2008 Reporting Services and no matter what I do, I cannot get the two and from dates to work with a date picker.

I have entered the following into the Report Properties Code:
Function DateParameter(DateValue As Date) As String
Dim sDateUniqueName As String
Dim SDateKey As String
sDateKey = YEAR(DateValue).ToString( ) _
& RIGHT("0" & MONTH(DateValue).ToString, 2) _
& RIGHT("0" & DAY(DateValue).ToString( ), 2)
sDateUniqueName = " [ID OPEN DATE].[ID CALENDAR].&[" & sDateKey & "]"
return sDateUniqueName
End Function

But when I follow the stop to change the Data Type of the Parameter to Date/Time I get the following error message: "<Default Value 1> Value is not a date or Time and it jumps to the Default Values Tab.

What am I doing wrong !?!?!?!
Reply With Quote