cancel
Showing results for 
Search instead for 
Did you mean: 

How to hide hash (#)?

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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
0 Kudos

Hi,

refer this thread

see if it helps your problem

regards,

partha

Former Member
0 Kudos

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

Former Member
0 Kudos

is this report in BEX analyzer or the web?

Former Member
0 Kudos

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