Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
1sabine8
Posting Yak Master
130 Posts |
 Posted - 2007-10-05 : 08:57:09
|
| Hi,I have a situation where i need to have two parameters (startDate, endDate) and use them as filters for my query. But i don't want to have a stored procedure with these parameters. So how can i have the two date parameters as calendars to choose dates from? |
|
|
jamie
Aged Yak Warrior
542 Posts |
Posted - 2007-10-09 : 09:23:55
|
| hi, within the report, first, change the dataset to :where Date Between (@startdate) and (@enddate)then click on Report, report parameters and change the parameters from string to datetime. This will automatically give you access to a date calender when you preview the report. |
 |
|
|
1sabine8
Posting Yak Master
130 Posts |
Posted - 2007-10-11 : 05:27:57
|
ok thanks a lot jamie  in fact i'm new to reporting |
|
|
|
|
|
|
Date Range Parameter