Suppressing empty rows

[Former Member]

Hi everyone!!

In my Excel Report I have 6 columns. Some of the rows are empty but in these empty rows one column "Goods Recepient" is represented by a #. I would like to supress the entire row. How could I do that? I need to submit this report urgently, so hope to get an immediate reply.

Thanks.

[Former Member]

Select a key figure and create a condtion where Key Figure not equal to 0 so that query will retrieve the data which is having key figure value not equal to 0.

Regs

Gopi

Assign points if it helps ...

Message was edited by: Gopi

[Former Member]

Hi

Try using supress zeros -> go to query properties->display tab-> suppress zeros active -> effect on rows.

You can find the similar options once you execute the query in BEx analyzer-> use right mouse click context menu.

Regards

Pradip

[former_member184494]

Sebastian,

Open Goods recipient in the query designer and say Exclude "#" , but that would remove the values also , if youo do not want to show the # but want the rest of the fields , you could put the Goods Recipient in the Free Characteristics area and achieve the same.

Arun

Assign points if helpful