SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 optional date parameter		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

v_kash
Starting Member

44 Posts
Posted - 04/13/2012 :  12:01:43  Show Profile  Send v_kash a Yahoo! Message  Reply with Quote
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

India
48076 Posts
Posted - 04/13/2012 :  12:51:04  Show Profile  Reply with Quote
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 MVP
http://visakhm.blogspot.com/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000