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
Assuming you do mean null, then you need a detail filter that looks something like:
amount_sold is not missing
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
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
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.
suppress the null values.... if you need the steps how, google it.
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 (http://www.cognoise.com/index.php/topic,18290.5.html).