Masking sensitive data on report

[#1]

I am a novice to Business Objects; still getting accustomed to running different queries, different reporting, etc.  I am creating a simple report that is pulling 6 unique fields from our database, one of which is a 9 digit acct. number.  I would like to get that acct number to return on the report as all 'x's.  Is there a way to easily accomplish this?

[Former Member · Accepted solution]

Hi

In the report you can hardcode Account number as "xxxxxxxxx".

Let us know if your requirement is something different.

~Anuj

[Former Member · Accepted solution]

Thanks.  That appears to properly work as long as a value is returned in that field.  If no value is returned, I would prefer to see the blank in that field for that specific line item.  Is that doable?

[Former Member · Accepted solution]

You Can Do something like below-

=if isnull([Account Number]) then [Account Number] Else "xxxxxxxxxx"

-Anuj

[Former Member · Accepted solution]

Hi R Var,

If we think as an end user using this report, do you think account number as XXXXXXXX would make any sense to them?

In case you do not want to display the account number then you can simply remove it from the result objects.

Else display atleast 4 ending characters by using substr () , trim () or fill( )functions.

Regards,

Yuvraj

[Former Member · Accepted solution]

Thanks, that worked perfectly. 

[Former Member · Accepted solution]

Hi if your issue is resolved please close the thread.

[Former Member]

Hi R Var,

You should mark the correct answer.

-Anuj