on 02-02-2006 2:38 PM
BW Experts,
Can we replace the # with 0 that shows up in the Bex reports when there is no data?. Is there any table / program / transaction where we can customize this settings.
Suggestions appreciated.
Thanks,
BWer
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi BWer,
you can follow the code in the thread, change 'not assigned' with '0', or use table interface
by Peter
SAPBEXonRefresh()
Dim c as range
For Each c in resultArea.cells
if c.Value = "#" then c.Value = "0"
Next c
or
by Jens (consider to performance)
put in SAPBEXonRefresh()
resultArea.Select
Cells.Replace What:="#", Replacement:="0", LookAt:=xlPart, _
SearchOrder:=xlByRows,
MatchCase:=False,
SearchFormat:=False, _
ReplaceFormat:=False
table interface, redefine CHARACTERISTIC_CELL method...
if I_CHAVL = '#'.
c_cell_content = '0'.
endif.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.