Value prompt with values from different levels

[Manu0521]

Hi ,
I need to show a value prompt which contains values form different levels but from same hierearchy.

Say 3 values from level1 , 2 values from level3 and 2 values from level 4.

How do i achieve this and how should i pass this value to my main query based on user selection.

Thanks,

[MFGF]

Hi,

Define a calculated item in your query driving the value prompt and use the expression set(xxx,xxx,xxx) where each xxx is the relevant member from the hierarchy. You can mix members from different levels. Set this as the Use value of your prompt.

In the report itself, add a calculation with the expression [your hierarchy] -> ?parameter?

Make sure the prompt is setting the same parameter.

Cheers!

MF.

[Manu0521]

It worked thanks a lot.

Thanks,