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 |
|
v_kash
Starting Member
45 Posts |
 Posted - 2012-04-13 : 12:01:43
|
| not sure how/if this is possible: so i have a report, and one of the parameters right now id a date parameter that is pre-populated. so for example, a value in the drop-down might is 'current calendar year', and if you select that, it means itll bring in values from 1/1/12 - 4/12/12. However, the user is asking for the ability to enter in a date range as well. Any ideas on the best way to allow for this? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-13 : 12:51:04
|
| add two date parameters and make them dependent on dropdown parameter so that if you select something it will get refreshed with date based on that selection. set default values to null so that you can directly go and select them if you want with two date values. In such cases you can make existing parameter as optional.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
optional date parameter