Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > Reporting Services
|
Reporting Services SQL Server Reporting Services. Please specify which version.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Reporting Services section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 7th, 2010, 12:16 PM
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 !?!?!?!





Similar Threads
Thread Thread Starter Forum Replies Last Post
Has anyone got this working with VWDE 2008 / SQL Express 2008? john77 BOOK: ASP.NET 3.5 Website Programming Problem Design Solution 4 January 18th, 2010 01:16 PM
Adding Calander Control In VS2005 reporting brad60 ASP.NET 2.0 Basics 0 August 27th, 2009 12:37 PM
SQL 2008 will not run on Windows 2008? dkrus Book: Professional Microsoft SQL Server 2008 Administration ISBN: 978-0-470-24796-9 1 February 23rd, 2009 12:34 PM
pop up calander control pankajmittal3 ASP.NET 2.0 Professional 3 August 12th, 2006 08:19 PM





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