p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Reporting Services (http://p2p.wrox.com/forumdisplay.php?f=205)
-   -   Calander Control in SSRS 2008 (http://p2p.wrox.com/showthread.php?t=77702)

mcdew January 7th, 2010 12:16 PM

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 !?!?!?!


All times are GMT -4. The time now is 11:35 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.