I get automatic suppression altough suppression option is set to No Suppression

[iliana]

Hi!
Report studio automatically suppresses rows in the list report I created,
even though suppression option is set to No suppression.

I tried creating a new package from the same model with dimensional data (DMR) and created a crosstab.
I put the dimension members one by one but I still get the suppression.

Cognos Version is 10.1.1

Any ideas?

[norkos]

Hi,

Use outer joins instead of inner joins in your relational model. I think the DB server make the "suppression" and not Report Studio.
I think you should try to run the Report studio generated SQL directly on the SQL server and check whether it contains these suppressed rows or not.
And it works the same in DMR models too.

NoRkoS

[iliana]

Thank you, by looking at the SQL this is probably the problem.