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