crystal reports

[EyeTalion]

I'm running a CR through my app. On the left hand side of the report is a list of the fields I GROUP BY, which is a credit card number. I need to either remove the listing or mask some of it...is this possible?

thanks.

[janis]

You can use formula to e.g. cut some chars and replace them with '*'. In your CR insert formula field and add something like this:
Dim strCred as string
strCred=CStr ({Table.cred_number}) 'credit number field
strCred=Left (x,Len(strCred)-5) & "*****"

regard j

[EyeTalion]

am I close?

Dim strCred As String
        strCred=CStr ({pcms_pcard_transaction_header.credit_card_no}) 'credit number field 
        strCred = Left(x, Len(strCred) - 5) & "*****"
        rpt.DataDefinition.RecordSelectionFormula.Insert(strCred)

[janis]

You can add formula field in crystal report designer (fields explorer - formula fields) and then add code for that field.

regard j

[EyeTalion]

sorry, didn't explain my problem to well. I was able to mask the credit card number in the report. What I need to do is hide the grouptree or mask the card number in there. Is this possible?

[EyeTalion]

I solved the this problem by masking the card numbers in the group tree. I did this by right clicking on the group, selecting change group, options, then selecting "use formula as group name". I then wrote a formula to mask the first 12 didgits.

thanks for your help

[mabbas110]

on the upper right or top side there is the trr button if u can see then click that button and see if that tree is removed

then just see the properties of contral and turn it off
( i mean the option in contrrol)