March 8, 2013 at 3:07 am
I have a parameter called Reporting Level in my Report where you can choose from 4 options:
Company BDM Region Site
What 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 BDM
FROM Site
WHERE @ReportingLevel = 'BDM'
SELECT DISTINCT Region
FROM Site
WHERE @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 Capacity
FROM OccupancyDetail INNER JOIN
Site ON OccupancyDetail.Site_Skey = Site.Site_Skey
WHERE (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.
Thanks
Wayne
March 27, 2013 at 1:02 pm
If 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 doing
Select 'Year' as ReportingPeriod
Union
Select 'Month
Where @ReportingPeriod = @ReportingPeriod
This will make the report wait until reportingperiod has been selected.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply