I am attempting to include the date range parameters from an Analysis
Services cube in the title of a Reporting Services 2005 report. The dropdown
selection in the from and to date range parameters is formatted as July 1,
2006 and July 31, 2006. My expression is "Report Name " &
Parameters!FromTransactionDateCalendarTime.Value & " to " &
Parameters!ToTransactionDateCalendarTime.Value.

Instead this is printing the title as "Report Name [Transaction
Date].[Calendar Time].[Date].&[20060701] to [Transaction Date].[Calendar
Time].[Date].&[20060731]". This is not what I want the users to see in the
title, so how can I fix it to print like this: "Report Name July 1, 2006 to
July 31, 2006".

Fixed it - changed .value to .label. Now need to do a trim because my
hierarchy was indented.

"bhorwatt" wrote: