Question Re: Variable for an Attribute in Technology Q&A https://community.sap.com/t5/technology-q-a/variable-for-an-attribute/qaa-p/2769145#M1154331 <HTML><HEAD></HEAD><BODY><P>Right click the chars and set "supress zeros" in query designer.</P><P></P><P>Ravi Thothadri</P></BODY></HTML> Thu, 30 Aug 2007 01:42:38 GMT Former Member 2007-08-30T01:42:38Z Variable for an Attribute https://community.sap.com/t5/technology-q-a/variable-for-an-attribute/qaq-p/2769144 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P> </P><P>Good Morning to all,</P><P></P><P> 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.</P><P></P><P>Thanks in Advance</P><P></P><P>Regards,</P><P>Siv</P></BODY></HTML> Thu, 30 Aug 2007 01:37:05 GMT https://community.sap.com/t5/technology-q-a/variable-for-an-attribute/qaq-p/2769144 Former Member 2007-08-30T01:37:05Z Re: Variable for an Attribute https://community.sap.com/t5/technology-q-a/variable-for-an-attribute/qaa-p/2769145#M1154331 <HTML><HEAD></HEAD><BODY><P>Right click the chars and set "supress zeros" in query designer.</P><P></P><P>Ravi Thothadri</P></BODY></HTML> Thu, 30 Aug 2007 01:42:38 GMT https://community.sap.com/t5/technology-q-a/variable-for-an-attribute/qaa-p/2769145#M1154331 Former Member 2007-08-30T01:42:38Z Re: Variable for an Attribute https://community.sap.com/t5/technology-q-a/variable-for-an-attribute/qaa-p/2769146#M1154332 <HTML><HEAD></HEAD><BODY><P>But also i am getting zeros in the report.Can you please provide me any other solution</P></BODY></HTML> Thu, 30 Aug 2007 03:44:17 GMT https://community.sap.com/t5/technology-q-a/variable-for-an-attribute/qaa-p/2769146#M1154332 Former Member 2007-08-30T03:44:17Z Re: Variable for an Attribute https://community.sap.com/t5/technology-q-a/variable-for-an-attribute/qaa-p/2769147#M1154333 <HTML><HEAD></HEAD><BODY><P>hai, </P><P> If u are using the webapplicationdesigner then u can use this script restrict it....</P><P></P><P>&lt;script type="text/javascript" &gt;window.onload=function() { var Elements=document.getElementsByTagName('td'); for(var i=0;i&amp;amp;lt;Elements.length;i++){if(Elements&lt;i&gt;.innerText=='0'){Elements&lt;i&gt;.innerHTML=' ';Elements&lt;i&gt;.style.whitespace='nowrap';}}}&lt;/script&gt;</P><P></P><P></P><P>Thankz &amp; regards,</P><P>Prakasu.m</P></BODY></HTML> Thu, 30 Aug 2007 04:04:04 GMT https://community.sap.com/t5/technology-q-a/variable-for-an-attribute/qaa-p/2769147#M1154333 Former Member 2007-08-30T04:04:04Z Re: Variable for an Attribute https://community.sap.com/t5/technology-q-a/variable-for-an-attribute/qaa-p/2769148#M1154334 <HTML><HEAD></HEAD><BODY><P>Thank you replay. But i am not using WAD,</P></BODY></HTML> Thu, 30 Aug 2007 04:06:51 GMT https://community.sap.com/t5/technology-q-a/variable-for-an-attribute/qaa-p/2769148#M1154334 Former Member 2007-08-30T04:06:51Z Re: Variable for an Attribute https://community.sap.com/t5/technology-q-a/variable-for-an-attribute/qaa-p/2769149#M1154335 <HTML><HEAD></HEAD><BODY><P>Hi Siva,</P><P>Go to the query properties,</P><P>If Ur 3.5 in display tab page you can find suppress zeros,</P><P>If ur in bi 7 ,</P><P>Form rows and columns tab,</P><P>U an find suppress zeros,</P><P>According to Ur requirement choose the option.</P><P>Hope it helps.</P><P></P><P>Cheers!!</P><P>Srinath</P></BODY></HTML> Thu, 30 Aug 2007 06:17:08 GMT https://community.sap.com/t5/technology-q-a/variable-for-an-attribute/qaa-p/2769149#M1154335 Former Member 2007-08-30T06:17:08Z Re: Variable for an Attribute https://community.sap.com/t5/technology-q-a/variable-for-an-attribute/qaa-p/2769150#M1154336 <HTML><HEAD></HEAD><BODY><P>I did it. But same result.</P></BODY></HTML> Thu, 30 Aug 2007 06:42:03 GMT https://community.sap.com/t5/technology-q-a/variable-for-an-attribute/qaa-p/2769150#M1154336 Former Member 2007-08-30T06:42:03Z Re: Variable for an Attribute https://community.sap.com/t5/technology-q-a/variable-for-an-attribute/qaa-p/2769151#M1154337 <HTML><HEAD></HEAD><BODY><P>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</P></BODY></HTML> Thu, 30 Aug 2007 06:45:23 GMT https://community.sap.com/t5/technology-q-a/variable-for-an-attribute/qaa-p/2769151#M1154337 Former Member 2007-08-30T06:45:23Z Re: Variable for an Attribute https://community.sap.com/t5/technology-q-a/variable-for-an-attribute/qaa-p/2769152#M1154338 <HTML><HEAD></HEAD><BODY><P>Siva,</P><P></P><P>You can ignore the values which are displaying zero's by supressing zero's in the query level.. Try it out once..</P><P></P><P>Assign Points if it helps..</P><P></P><P>Thanks,</P><P></P><P>Gattu..</P></BODY></HTML> Thu, 30 Aug 2007 07:03:05 GMT https://community.sap.com/t5/technology-q-a/variable-for-an-attribute/qaa-p/2769152#M1154338 Former Member 2007-08-30T07:03:05Z Re: Variable for an Attribute https://community.sap.com/t5/technology-q-a/variable-for-an-attribute/qaa-p/2769153#M1154339 <HTML><HEAD></HEAD><BODY><P>shiva,</P><P>See this link ,It may helps you.</P><P><A href="http://help.sap.com/saphelp_nw70/helpdata/en/43/b57138c1afbd20e10000009b38f889/frameset.htm" target="test_blank">http://help.sap.com/saphelp_nw70/helpdata/en/43/b57138c1afbd20e10000009b38f889/frameset.htm</A></P><P></P><P>Srinath</P></BODY></HTML> Thu, 30 Aug 2007 07:13:13 GMT https://community.sap.com/t5/technology-q-a/variable-for-an-attribute/qaa-p/2769153#M1154339 Former Member 2007-08-30T07:13:13Z Re: Variable for an Attribute https://community.sap.com/t5/technology-q-a/variable-for-an-attribute/qaa-p/2769154#M1154340 <HTML><HEAD></HEAD><BODY><P>It is not a Key figure. I query i took attribute ( Not an Char or Keyfigure) of an infoobject.</P></BODY></HTML> Thu, 30 Aug 2007 07:42:30 GMT https://community.sap.com/t5/technology-q-a/variable-for-an-attribute/qaa-p/2769154#M1154340 Former Member 2007-08-30T07:42:30Z Re: Variable for an Attribute https://community.sap.com/t5/technology-q-a/variable-for-an-attribute/qaa-p/2769155#M1154341 <HTML><HEAD></HEAD><BODY><P>u mean to say ur attribute value is zero?</P></BODY></HTML> Thu, 30 Aug 2007 07:52:30 GMT https://community.sap.com/t5/technology-q-a/variable-for-an-attribute/qaa-p/2769155#M1154341 Former Member 2007-08-30T07:52:30Z Re: Variable for an Attribute https://community.sap.com/t5/technology-q-a/variable-for-an-attribute/qaa-p/2769156#M1154342 <HTML><HEAD></HEAD><BODY><P>Yes, the value of attribute is zero.</P></BODY></HTML> Thu, 30 Aug 2007 08:05:29 GMT https://community.sap.com/t5/technology-q-a/variable-for-an-attribute/qaa-p/2769156#M1154342 Former Member 2007-08-30T08:05:29Z Re: Variable for an Attribute https://community.sap.com/t5/technology-q-a/variable-for-an-attribute/qaa-p/2769157#M1154343 <HTML><HEAD></HEAD><BODY><P>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..</P><P></P><P>*<STRONG>helpful answers deserve some points</STRONG>*</P></BODY></HTML> Thu, 30 Aug 2007 08:39:30 GMT https://community.sap.com/t5/technology-q-a/variable-for-an-attribute/qaa-p/2769157#M1154343 Former Member 2007-08-30T08:39:30Z Re: Variable for an Attribute https://community.sap.com/t5/technology-q-a/variable-for-an-attribute/qaa-p/2769158#M1154344 <HTML><HEAD></HEAD><BODY><P>But it is an display attribute</P></BODY></HTML> Thu, 30 Aug 2007 08:43:35 GMT https://community.sap.com/t5/technology-q-a/variable-for-an-attribute/qaa-p/2769158#M1154344 Former Member 2007-08-30T08:43:35Z