Hi all I want to add a parameter value to the report footer. Connecting to SSAS 2005 cube from SSRS 2005. The parameter is simply the dates the user selected. I use the JOIN(@prmDate) thing and it does indeed pull the parameter through. Trouble is, because I use a Date hierachy I get the MDX gibberish eg [CFOCalandar].[Year].200&9 etc etc Anyone know of a way of presenting this 'properly' TIA

Me being stupid - used the Label instead of the Value. Much better.