Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > SQL Server > Reporting Services
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old January 7th, 2010, 11:16 AM
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
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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 12: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 11:34 AM
pop up calander control pankajmittal3 ASP.NET 2.0 Professional 3 August 12th, 2006 08:19 PM



All times are GMT -4. The time now is 08:01 AM.


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