SQL Reporting Date Parameters

I am using SQL 2000 reporting and I have 3 report parameters (2 of them dates). Is there a way with the included report viewer (from the sql reporting samples) to allow the date input parameters to be date pickers?

Thanks

[236 byte] By [adamscabana] at [2007-12-17]

«« SDLC design using .net framework
»» Sql Server 2005 Active Directory Intergration

# 1

Unfortunately date pickers are not available in RS2000. However in 2005 they are most definitely there.

In the meantime you have two simple alternatives within Report Manager:
1. create parameters which contain a limited set of day/week/month/year values you wish your users to be able to report on
2. give your users text boxes into which they can type the date values (this one can be a little messy)

A more involved solution lies in developing your own custom front end to the report so you can embed date picker controls.

HTH

NickBarclay at 2007-10-6 >

top of Msdn Tech,SQL Server,SQL Server Reporting Services...

# 2

Thanks Nick

adamscabana at 2007-10-6 >

# 3

Nick, I do not see the week values. I would like to add Week to Date (WTD) as a filter value for a report I have. That way the user always has WTD data. Am I missing it under filter (on a date time) in Report Builder?

Thanks
Ron

RonWilson at 2007-10-6 >

SQL Server

SQL Server Reporting Services

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech