I am trying to fill a Textbox with the Label-Field from the Report Parameters. The Multi-Value-Option is checked and it is possible to select multi-values from the time hierarchy [Time].[Year - Half Year - Quarter - Month].
For example you can choose:
"Calendar 2007" ([Time].[Year - Half Year - Quarter - Month].[Year].&[2007-01-01T00:00:00])
"Quarter 4, 2006" ([Time].[Year - Half Year - Quarter - Month].[Quarter].&[2006-10-01T00:00:00])
and "April 2006" ([Time].[Year - Half Year - Quarter - Month].[Month].&[2006-04-01T00:00:00])
Now I want to fill a Textbox with the chosen parameter values by putting following expression as value of the textbox:
Parameters!TimeYearHalfYearQuarterMonthDate.Label ... with "TimeYearHalfYearQuarterMonthDate" as the name of the DataSet.
That gives an Error.
Can you please help me out?
Best regards
Claudio
Why are you using .Label? Either I don't fully understand your problem or you should be using:
Parameters!TimeYearHalfYearQuarterMonthDate.Value
|||First of all: .Value doesn't work either. Second: I am using Label, because I don't want the value like [Time].[Year - Half Year - Quarter - Month].[Year].&[2007-01-01T00:00:00] to be displayed, but the Label like Year 2007.|||Hi there,
how can I fill a Textbox with the Report Parameters when using multi-values for them?
For example you can choose:
"Calendar 2007" ([Time].[Year - Half Year - Quarter - Month].[Year].&[2007-01-01T00:00:00])
"Quarter 4, 2006" ([Time].[Year - Half Year - Quarter - Month].[Quarter].&[2006-10-01T00:00:00])
and "April 2006" ([Time].[Year - Half Year - Quarter - Month].[Month].&[2006-04-01T00:00:00])
together. And I want a Textbox to show the Parameters used. Like Calendar 2007; Quarter 4, 2006; April 2006.
Please help me out with this issue!
Best regards
Claudio
|||
Hi,
In order to show all your selected parameters from a multi value param, i use this function:
join(Parameters!your-param.label, " ; ")
hope this helps.
Vinnie
|||Hi Vinnie!Thank you very very much! It works!
Bye
Claudio
sql
No comments:
Post a Comment