04-24-2007 8:10 PM
Hi Experts,
I am getting 00.00 in my classical report for currency/discount field, so, I wuld like to hv blanks(nothing) in these fields!
So,
1- How to format it?
By the by,
2-For all Data types, How to supress their initial values on the report? like for,
C -
N -
D-
T-
etc.?????
3- Generally, How the clients / users wuld like to hv in the report?
ThanQ.
Message was edited by:
Sridhar
Message was edited by:
Sridhar
04-24-2007 8:21 PM
2-For all Data types, How to supress their initial values on the report? like for,
C -
N -
D-
T-
<b>For all the above data types, you can say:
IF NOT <VARIABLE> IS INITIAL.
*----
ENDIF.
For internal tables, you say:
IF NOT ITAB[] IS INTIAL.
*----
ENDIF.</b>
3- Generally, How the clients / users wuld like to hv in the report?
<b>Depends upon the requirement.</b>
Thanks,
SKJ
04-24-2007 8:13 PM
04-24-2007 9:16 PM
04-24-2007 9:19 PM
Hi Rich,
ThanQ for ur cont. support.
Do u hv any idea about my other thread with title,
SELECT DMBTR FROM BSEG WHERE AUGBL EQ WA_AUGBL AND KTOSL = 'SKT'-JOIN????
Actually, I wuld like to hv this title as( i.e. no JOIN),
<i><b> SELECT DMBTR FROM BSEG WHERE AUGBL EQ WA_AUGBL AND KTOSL = 'SKT????</b></i>
If so, pls. respond!
ThanQ.
04-24-2007 9:42 PM
Try this:
SELECT DMBTR FROM BSEG WHERE AUGBL EQ WA_AUGBL AND KTOSL
like 'SKT%'.
Thanks,
SKJ
04-24-2007 10:04 PM
Hi,
No, thats not the problem/am looking for!
Pls. hv a glance on my other thread with title,
SELECT DMBTR FROM BSEG WHERE AUGBL EQ WA_AUGBL AND KTOSL = 'SKT'-JOIN????
Actually, I wuld like to hv this title as( i.e. no JOIN),
<u><b>SELECT DMBTR FROM BSEG WHERE AUGBL EQ WA_AUGBL AND KTOSL = 'SKT????</b></u>
If u hv any thoughts, pls. respond!
ThaNQ.
04-24-2007 8:15 PM
Hi,
You can use NO-ZERO
Ex..
DATA: V_MENGE TYPE MENGE_D VALUE '0.00'.
WRITE: / V_MENGE NO-ZERO.
Thanks,
Naren
04-24-2007 8:16 PM
Hi,
Before writing this field check whether it has some value or not. If it is initial dont print/write it in the output.
Something like....
if x is not initial.
write: x.
endif.
Regards,
Bharat.
04-24-2007 8:21 PM
2-For all Data types, How to supress their initial values on the report? like for,
C -
N -
D-
T-
<b>For all the above data types, you can say:
IF NOT <VARIABLE> IS INITIAL.
*----
ENDIF.
For internal tables, you say:
IF NOT ITAB[] IS INTIAL.
*----
ENDIF.</b>
3- Generally, How the clients / users wuld like to hv in the report?
<b>Depends upon the requirement.</b>
Thanks,
SKJ