InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 16:00:26 GMT20http://www.sqlservercentral.com/Forums/Topic1428473-1633-1.aspxIf you make your parameters dependant on another parameter then you should be able to greythe others out.if you make your @Year or @Dates dependent on @ReportingLevel they'll be greyed out until you pick a ReportingLevel.If your @Reportingperiod isn't a query but a list of options you could make it a query by doingSelect 'Year' as ReportingPeriodUnionSelect 'MonthWhere @ReportingPeriod = @ReportingPeriodThis will make the report wait until reportingperiod has been selected. Wed, 27 Mar 2013 13:02:12 GMTSteven.Howeshttp://www.sqlservercentral.com/Forums/Topic1428473-1633-1.aspxI have a parameter called Reporting Level in my Report where you can choose from 4 options:Company BDM Region SiteWhat I want to be able to do is this:Select BDM and this opens another Parameter call BDM List (This is based on Get Values from a query), but I want the other Parameters to stay greyed out. Once a selection is made from the BDM List then the Time and Date Parameter becomes available.Is this possible?These are my Datasets for the BDM List and Region List:SELECT DISTINCT BDMFROM SiteWHERE @ReportingLevel = 'BDM'SELECT DISTINCT RegionFROM SiteWHERE @ReportingLevel = 'Region'This is my main Dataset:SELECT OccupancyDetail.CalendarYear, OccupancyDetail.CalendarMonth, SUM(OccupancyDetail.No_of_Nights) AS No_of_Nights, SUM(OccupancyDetail.Capacity) AS CapacityFROM OccupancyDetail INNER JOIN Site ON OccupancyDetail.Site_Skey = Site.Site_SkeyWHERE (OccupancyDetail.ReferenceDate = convert(Date,getdate()))AND CASE WHEN @Time = 'YEAR' THEN CAST(CalendarYear as varchar(4)) else CalendarMonth + ' ' + CAST(CalendarYear as varchar(4)) end in (@Dates)AND BDM IN (@BDM)AND Region in (@Region)GROUP BY OccupancyDetail.ReferenceDate, OccupancyDetail.CalendarYear, OccupancyDetail.CalendarMonthI hope you can help this is my 3rd day working on this.ThanksWayneFri, 08 Mar 2013 03:07:30 GMTwafw1971