Setting for non display of records

[Former Member]

Hi ,

my requirement is don't display records where value contains 0 .

What setting can i made for this ?

Regards,

PSR

[former_member190501 · Accepted solution]

Hi,

Under Expand range parameters there is a sub parameter called Suppress to suppress zero values.

Supress:( Optional) Set the Row expansion parameter to Y to suppress the rows that retrieve zero values. Set the Column expansion parameter to Y to suppress all columns that retrieve zero values. For more information, see Suppress Parameter.

http://help.sap.com/saphelp_bpc75_nw/helpdata/en/2c/e37096b9264faa8645020bb211a1fc/content.htm

hope it helps...

regards,

Raju

[Former Member · Accepted solution]

Hi Raju,

Just wanted to focus on one point.

Suppress = Y wont display the records if there is no record in the database. However, if there is a 0 value, then the suppress wont work. Kindly have a look at the link provided by you. There is a place, which says that The system does not suppress rows or columns returning a zero (where a zero amount is stored in the database).

[Former Member · Accepted solution]

Hi Raju ,

Thanks for reply .

my case , row has expension and column has no expansion .

I puted the Y in the rowexpansen in supress cell .

still it showing records with blank value .

i dont require records with has zero or empty or blank cells .

pls let me know any option .

regards,

PSR

[former_member190501 · Accepted solution]

Hi,

Optimize your application first and run the rport.

To eliminate 0 records while optimizaing the application follow the below steps:

**Goto tcode RSPC choose /CPMB/LIGHT_OPTIMIZE / /CPMB/FULL_OPTMIZE

**Select Process type Collapse and check whether Switch on Zero elimination is checked or not

If not check this check box and save process type .

hope it works...

regards,

Raju

[former_member288392]

Hi,

Unlike what is mentioned in the thread, I tried the suppress option and it supresses both the ones with ones which are blank and the ones with zeroes as well.

-hope this helps

sridhar