How to restrict the rows having zero values

[inu]

HI
I have amount_sold item in my report , i want to display the amount_sold only which is not null, if null then dont display the record. how to write the logic . please specify the steps to be followed.

Thanks and Regards
Inam

[BigChris]

Assuming you do mean null, then you need a detail filter that looks something like:

amount_sold is not missing

[inu]

Hi
Thank you for your given time, but i didnot get u, can u please explain it , what steps i have to take.
1) Should i take another query calculation. or i have to modify the expression of amount_sold.
2)What function and logic should be used to reach to desired solution

Please i m not as much master in report studio.

Thank u
Inam

[BigChris]

Hi,

No, you don't need to do anything to the query calculation - you just need to drag your field into the detail filter section (top right in your query design) and add is not missing to the end of it.

C

[tequila]

How about this (looking at screenshot) ?

Dataformat - Number (Zahl) - Nullcharakter (Nullwertzeichen) and press 1x spacebar (empty)

also the result is when amount_sold output 0 it show empty.

Hope it is a right solution for you.

[Francis aka khayman]

suppress the null values.... if you need the steps how, google it.

[bdbits]

Built-in null suppression is under the Data menu in Report Studio. If that does not work for you for whatever reason, then it matters whether you are using a relational or a dimensional (cube, DMR) source.

For relational, you should use the detail filter as suggested.

For dimensional, I would apply a filter() to an edge data item (assuming crosstab). e.g. filter([Cube].[Hierarchy].[Level1].[Level2],[amount_sold] is not null). There might be better ways as I am not the most proficient report developer, but this does work for me.

Whatever you do, never, ever use a detail filter on a dimensional data source. CognosPaul is the spokesperson as to why. :D You can read one of his great explanations at http://www.cognoise.com/index.php/topic,18290.5.html.