Variable for an Attribute

[Former Member]

Hello,

Good Morning to all,

In a query a attribute is defined for an Infoobject. In the output, i am getting zero values along with values for that attribute.But i want to display only the values other than zero. If it is possible at the query level please provide me the solution.

Thanks in Advance

Regards,

Siv

[Former Member]

Siva,

You can ignore the values which are displaying zero's by supressing zero's in the query level.. Try it out once..

Assign Points if it helps..

Thanks,

Gattu..

[Former Member]

hai,

If u are using the webapplicationdesigner then u can use this script restrict it....

<script type="text/javascript" >window.onload=function() { var Elements=document.getElementsByTagName('td'); for(var i=0;i&amp;lt;Elements.length;i++){if(Elements<i>.innerText=='0'){Elements<i>.innerHTML=' ';Elements<i>.style.whitespace='nowrap';}}}</script>

Thankz & regards,

Prakasu.m

[Former Member]

Thank you replay. But i am not using WAD,

[Former Member]

Hi Siva,

Go to the query properties,

If Ur 3.5 in display tab page you can find suppress zeros,

If ur in bi 7 ,

Form rows and columns tab,

U an find suppress zeros,

According to Ur requirement choose the option.

Hope it helps.

Cheers!!

Srinath

[Former Member]

I did it. But same result.

[Former Member]

right click on ur structure name in columns or rows whereever u have used, if no structure, right click on key figures and check - Also use zero suppression for Structure elements

[Former Member]

shiva,

See this link ,It may helps you.

http://help.sap.com/saphelp_nw70/helpdata/en/43/b57138c1afbd20e10000009b38f889/frameset.htm

Srinath

[Former Member]

It is not a Key figure. I query i took attribute ( Not an Char or Keyfigure) of an infoobject.

[Former Member]

u mean to say ur attribute value is zero?

[Former Member]

Yes, the value of attribute is zero.

[Former Member]

u can restrict an attribute for values only if it is navigational.. and if it it available in the data target as navigational attr.. otherwise you wont be able to restrict the attribute values..

*helpful answers deserve some points*

[Former Member]

But it is an display attribute

[Former Member]

Right click the chars and set "supress zeros" in query designer.

Ravi Thothadri

[Former Member]

But also i am getting zeros in the report.Can you please provide me any other solution