Skip to Content
0
Jan 13, 2011 at 12:56 AM

Zero suppression doesn't work

56 Views

Hi,

We are having an issue with the zero suppression.

We have done a simple query with Material and Price in Columns, and Calmonth in rows.

We want to suppress the zeros, but it is not working if we let the Material in columns (example 1).

If we change the drill down for Material, and we put in rows, the zero suppression is working fine (example 2)

EXAMPLE 1
		Price
Material	A123	A432	B564
Calmonth	
10.2010		0	15	55

EXAMPLE 2

Calmonth	Material 	Price
10.2010		A432		15
		B564		55

The suppression is configured in query designer for rows, columns and structures.

This is happening in Analyzer and thru RSRT, but if we execute the query thru the web (portal) it works as expected.

What do you think it could be happening?

Thanks in advance, Federico