topic ALV - NO_ZERO in Application Development and Automation Discussions

ALV - NO_ZERO

Former Member — Wed, 20 Jan 2010 18:57:17 GMT

Hi All,

I need to generate an ALV report, but the lines should be listed sometimes with zeros (when the value is zero) and sometimes with blanks. I have another column to check if it should list blank or zero.

Follow an example:

" " this line it should list 'Value' field with the BLANKS

0,00 this line it should list 'Value' field with the ZEROS

Thanks in advance,

Janete

Re: ALV - NO_ZERO

kesavadas_thekkillath — Wed, 20 Jan 2010 19:11:33 GMT

Decalre the field of type character and add some logic in your code.

I dont think that the built in functionalities will not help you in such conditions.

Re: ALV - NO_ZERO

Former Member — Wed, 20 Jan 2010 20:55:52 GMT

Janete Okuma ,

Add a simple logic in the code to find out what is stored in the field VALUE.

For ex:

If value is initial.

move space to value.

elseif value CO '0'.

move c_zero to value.

else.

dont change the contents

endif.

Regards,

Vikram.M

Re: ALV - NO_ZERO

Former Member — Thu, 21 Jan 2010 04:05:13 GMT

Hi Janete Okuma ,

You can handel your requirement in code logic , while filling the internal table.

You need to decide the condition for decision and use IF statement.

Hope this resolves your issue.

Re: ALV - NO_ZERO

Former Member — Thu, 21 Jan 2010 05:07:58 GMT

hi ,

For field '' '' & '0' you can check ....at the time of filling the data into internal table

if field is initial  or field EQ '0'.
else .
append in internal table.
 endif.

regards

Gaurav

Re: ALV - NO_ZERO

Former Member — Wed, 03 Feb 2010 11:46:47 GMT

We use Crystal Reports since a couple of years now with satisfaction. Only one question:

We want to show all projects with hours (also zero) but we can see only the projects where hours are been booked.

It makes sense but we must manually check the projects where hours have been booked but perhaps must be booked (sorry for my bad grammatical English)

Is there a code/formula where we can also see the projects where the hours supposed to be u201C0u201D (zero).

Kind regards,

Ivonne

Re: ALV - NO_ZERO

Former Member — Thu, 04 Feb 2010 11:18:24 GMT

This issue has not been solved yet.

Maybe I have not explained correctly. It is an ALV report, similar to FC10 with several levels (tree).

I am using NO_ZERO, but it is necessary to print space in header levels and zero in detail levels.

The problem is that with NO_ZERO detail lines are printed with space.

And I can´t create this column as a character, because this column should be summarized.

Anyway, thanks everybody.