Monday, March 26, 2012

Error when reading the Label field from Report Parameters

Hi there,

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