Skip to Content
author's profile photo
Former Member

How to insert Blank rows while Zero Suppression is Activated?

I am using BI 2004s and have applied zero suppression to a query I have built, how ever this removes the blank rows I am using to format the report. Any ideas on how I could get the blank rows to remain whilst removing zero value rows?

Thanks

Stu

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    author's profile photo
    Former Member
    Posted on Aug 23, 2007 at 07:04 AM

    in zero suppression, select active(All values = 0)

    *reward if helpful*

    Add comment
    10|10000 characters needed characters exceeded