Need to display "-" instead of "#" for blanks

[Former Member]

How to Display "-" instead of "#" for blank symbols in the query output.

[edwin_harpino · Accepted solution]

hi,

in bex, you can use vba macro. in web, use table interface

SAPBEXonRefresh()

Dim c as range

For Each c in resultArea.cells

if c.Value = "#" then c.Value = "-"

Next c

or

by Jens (consider to performance)

put in SAPBEXonRefresh()

resultArea.Select

Cells.Replace What:="#", Replacement:="-", LookAt:=xlPart, _

SearchOrder:=xlByRows,

MatchCase:=False,

SearchFormat:=False, _

ReplaceFormat:=False

table interface, redefine CHARACTERISTIC_CELL method...

if I_CHAVL = '#'.

c_cell_content = '-'.

endif.

[Former Member · Accepted solution]

Thanks a lot A.H.P

[Former Member · Accepted solution]

Hi Edwin,

We are using Business Objects WEBI reports based on BEX and we have the same requirement of not to show # on the report, does this solution work for BO based reporting also or did you find any other options for BO reporting.

Appreciate your help.

Regards,

Raman.