unwanted Billing Document numbers in report

[Former Member]

Dear Friends,

A small problem with report,the actual requirement is YTD and MTD as per that values are coming correctly and data is also validateding with ECC ,when we are drilling to the billing document level some of the unwanted documnets(which are created prior to the 01.04.2009)we are considering YTD as 01.04.2009 as our financial year.but those documents are not having any valuesso the cumulative is coming fine even document wise also fine but only unwanted documents coming with out values in report it leads to unwanted explations to User .

Please can any suggest some ides or any suitable answers, tahnks in advance.

Thanks & Reagrds,

Sathish

[Former Member · Accepted solution]

Hi,

You can create a condition over the key figure and display only those values which are greater than 0. This may help you to avoid the display of unwanted billing document with blank YTD and MTD values.

Regards

Akhan

[Former Member]

Thank you for your kind informative and valuble suggestion.

Thanks & Regards,

Sathish

[Former Member]

Thank you for your kind informative and valuble suggestion.

Thanks & Regards,

Sathish

[Former Member]

Thank you for your kind informative and valuble suggestion.

Thanks & Regards,

Sathish

[Former Member]

Thank you for your kind informative and valuble suggestion.

Thanks & Regards,

Sathish

[Former Member]

Hi Sathish

Right click on the report -> go to query preoperties and Make the suppress zero rows condition active. This will remove all the unwanted rows.

Thanks.