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 |
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
 Posted - 2012-06-06 : 14:04:32
|
| In my report I have startdate, enddate and timerange. How could I disable the startdate and enddate when I select timerange?deafalt value for startdate = '6/5/201' and enddate = '6/5/201 11:59:59 PM'time range i can select: <12, <24, <36, so on...The problem is when I select timerange I need to disable start and enddate. how can I do this? |
|
|
vijays3
Constraint Violating Yak Guru
354 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-06-07 : 22:49:14
|
quote:
Originally posted by basicconfiguration
In my report I have startdate, enddate and timerange. How could I disable the startdate and enddate when I select timerange?deafalt value for startdate = '6/5/201' and enddate = '6/5/201 11:59:59 PM'time range i can select: <12, <24, <36, so on...The problem is when I select timerange I need to disable start and enddate. how can I do this?
add a hidden parameter and set an expression based on timerange parameter to set boolean value as true of false based on whether its set or not.then use this parameter in start and end date parameter expression to enable disable them------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
Posted - 2012-06-11 : 19:32:02
|
| I fixed this one. thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-06-11 : 19:44:02
|
| wc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
time range