Problem Using Calendar Periods as parameter comparison

[mknsawdust]

Don’t know if this is possible or if there is a better way to do this, but any help would be appreciated.

I have a where clause that is used to select sales information for a period based on a parameter that’s passed from a drop down list. The parameter being passed("& parameters!GetPeriod.Value &) represents any level of the calendar hierarchy selected from a drop down list. It could be year, qtr, month, week, or day. The problem is, when you compare the parameter to the calendar, you have to specify the level of the hierarchy the comparison is for([Fiscal Month Name]). Is there any other way to handle this? If not, it means I have to write a separate report for each level of the hierarchy.

WHERE {ClosingPeriod([Calendar].[Fiscal Calendar].[Fiscal Month Name], [Calendar].[Fiscal Calendar].["& parameters!GetPeriod.Value &"])}