How to hide hash (#)?

[Former Member]

Hi guys,

Just a quick question. I've got a report which shows empty field for certain characteristics. These are automatically filled with a hash (#).

Is there any chance I can hide this hash and just show an empty field?

Your input is appreciated.

Greetz,

Joost

[Former Member]

Hi guys!

Please not that excluding these records from the query is not an option. It would simply mean that the entire record is not shown in the query.

E.g. First name & last name. If I only have a last name and I filter out the # in the first name (since the first name is not filled in), it would remove the entire record from the query. The last name will not be shown.

So I only want to hide the #!

[Former Member]

Hi,

refer this thread

see if it helps your problem

regards,

partha

[Former Member]

If in BEx Analyzer, you can code a small VBa macro which will search and replace # by whatever you want.

[Former Member]

is this report in BEX analyzer or the web?

[Former Member]

Hi,

refer this post

here it mentions about restricting the ' # ' (unassigend value in the query level by using an exclude restriction. Do let us know if it helped

regards,

partha

Edited by: Partha Chakraborty on Sep 2, 2008 5:50 PM