Suppress Active Form based on not all but more than 1 measur

[bunchukokoy]

Hi Everyone!

Does anybody know how can I suppress an active form based only only on two measures, although I have five measures on my active form? Based on my understanding, TM1RptTitle can only be used in TM1RptView once per dimension, so how will I be able to do that if the measures are contained in one dimension? I'm using 9.4.

I just want the other three measures as supporting detail.

Please.

Thanks a lot!

Bunch

[tomok]

This is possible, just takes a little extra work that can't be done as part of the active form creation wizard. Go ahead and create your active form but do it off a view that has only the two measures. In this case you'll have to have them as columns most likely. After the initial active form is created, add columns to the form for your additional three measures. Expand the TM1RPTDATARNGx and TM1RPTFMTRNG ranges to include your new columns. Now the messy part. You will need to add DBRW formulas to these new columns but you can't point them to the TM1RPTVIEW formula like the rest of the report because that is what the zero suppression is using. You will have to create your own VIEW statement somewhere outside of the active form range and point these new measures to that cell. I have used this method many times and it works perfectly.

[bunchukokoy]

Many thanks Sir Tomok! I'll inform once I've done it.

Bunch

[bunchukokoy]

Thanks Sir Tomok. It works right.