Showing results for 
Search instead for 
Did you mean: 

EVDRE - Option range - SuppressDataRow

Former Member
0 Kudos

Dear All,

I am trying to use SuppressDataRow within EVDRE.

Does anybody know how to use this option to suppress specific rows in the data range.

In my testing this had no effect.



Edited by: Richard Ritter on Feb 26, 2009 9:32 AM

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

For basic suppression, use the Suppress field in your expansion range -- a value of Y will suppress records with 0 or no values. A value of Budget,2009.Total will suppress records with 0 value in that alternate dimensional intersection. There are some other syntaxes that work for this suppression, too.

I've never used the SuppressDataRow option in the optionRange, and I think it's pretty esoteric.

Check out the online help, or the BPC for Office user guide for the full details on both of these.