display blank instead of #

[Former Member]

HI Eperts,

If any characteristic have # value and in report output or in workbook it is being displayed as # or 'not assigned'.

now can I display a blank space instead of # in my workbook output?

Also make me clear regarding the usage of conditions in BEx Query Designer.

Regards,

Vishal.

[Former Member · Accepted solution]

Hey,

you need to do VB coding for that but for more information ... look in to it

But its eazy to replace 0 to Blank

If whole the report does not have any value to display, it will not throw only the zero records.

But you can generally replace the zero as blank as below. In this case you can deactivate the check box, supress zero.

In BI 7, go to query properties...select value display tab ....go to zero value display ....select zero as space...save.

Santosh

[dheeraj_gupta · Accepted solution]

Hi,

I know its not a very good way to do it, but it works.

Simply go to the Maintainence of the Characteristic/info-objects in RSA1.

For the Unassigned record maintain a discription, say u maintain '.'

So this way you will see a . there, which is close to a blank, but I agree not a blank.

Moreover any data upload to this objects will not removed the changed discription of .

[Former Member]

Hi,

Also chk this links;

Reg

Pra

[former_member200211]

Here are the steps to do the same

1) In excel menu Tools->macro

2) Enter the macro name say SAPBEXonRefresh

3) click 'create', will go to visual basic editor

4) To display '#' as '', paste the following code

Sub SAPBEXonRefresh(queryID As String, resultArea As Range)

Dim c As Range

For Each c In resultArea.Cells

If c.Value = "#" Then c.Value = ""

Next c

End Sub

5) Close the editor and click on refresh again.

refer this link which solved the probelm.u have to paste the code as it is.and enter the macroname exactly as mentioned above.

to remove 'not assigned' ,u have to insert one more line for this code after If c.Value = "#" Then c.Value = ""

If c.Value = "Not assigned" Then c.Value = ""

Next c

Hope this helps.

[Former Member]

Thanks Lavanya,

for your response.

But what if I want only replace one characteristic's # value with space.

for rest of the characteristics it should remain #.