How to remove "#" from BEx report?

[Former Member]

Hello,

Do you have any idea how to remove "#" from BEx report? I know that it is possible to define in SPRO on the system level, but I am interested in a way to configure it for one particular report only. I don't want to see "#" signs, I would like to see blanks instead.

Thanks in advance

Arelis

[Former Member]

Thanks a lot

Arelis

[Former Member]

Code a very small VBa after refresh of the workbook, searching '#' and replacing it by space.

[Former Member]

/community [original link is broken]

[Former Member]

It is link to whole forum not to particular message, I think.

[Former Member]

    Range("C5:H23").Select
    Selection.Replace What:="#", Replacement:=" ", LookAt:=xlPart, _
        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
        ReplaceFormat:=False

Replace C5:H23 by the range you want to search for.

(Resultarea in 3.x or varname(1) in BI 7.0)

[Former Member]

i am sorry:

[Former Member]

Hi,

If you are in 3.5 Analyzer then you can also do the following.

 

Sub SAPBEXonRefresh(queryID As String, resultArea As Range)
           resultArea.Replace What:="#", Replacement:=" "
End Sub

HTH

Datta.