Dynamic report & container for dims

[dafnis14]

Hi,

I have to design a dynamic report with many dimensions & metrics.

So i decided to use a container to split the dimensions list boxes.

But when I select a dim value from one list, the dim fields from the other list box are displayed,

regardless of the condition:

Attached is a sample mode.

Will appreciate some tips here..

Thanks!

[sunny_talwar · Accepted solution]

Check with GetFieldSelections instead of Concat... because Concat will still have the field names when nothing is selected whereas GetFieldSelections will only show when a value is selected in _Dim1 or _Dim2

=SubStringCount('|' & GetFieldSelections(_Dim1, '|,') & '|', '|Code|') = 1

[dafnis14]

Brilliant, as usual!

Thanks for this tremendous tip!

[dafnis14]

Hi Sunny,

When 2 values are selected, still only one is displayed.

!

I changed the expression slightly:

from

=SubStringCount('|' & GetFieldSelections(_Dim1, '|,') & '|', '|Code|') = 1

to:

=SubStringCount('|' &  GetFieldSelections(_Dim1,'|')  & '|', '|Code|') =1

and now it does..

[sunny_talwar]

I think what I really wanted to do was this

=SubStringCount('|' & GetFieldSelections(_Dim1, '|,|') & '|', '|Code|') = 1

But what you did also worked...

[dafnis14]

Sometimes miracles happen..