Need to hiding part of the data in one field

[L15a]

I'm using Crystal Reports 9, and I need to produce a report that only partly shows a clients credit card number, for card types equal to 'DC' (all other card types are to be suppressed).

The card numbers are 18 digits long, of which, I need to display the first and last four digits. i.e 1234xxxxxxxxxx1234

I'm quite new to crystal, and SQL code, and I'm trying to work it out. But without much sucess so far.

I'm probably way off the mark, but I was thinking along the following lines, in the 'Display String' editor:

if {ClientCreditCard_TB.Type_FD}='DC' then {ClientCreditCard_TB.CardNumber_FD}='****xxxxxxxxxx****'

Any chance of a clue from anyone.

Thanks
Lisa

[mkrayirath]

U can try like

in to the formulas create a new formula... inthat
left(creditcardfieldname,3) & right(creditcardfieldname,3)

and use this formula where u want to place in reports... it will show first 3 number and last 3 numbers combined ..if u want to put space means u put single quotes with reqd space then close ambersign

it will solve ur probelm

[L15a]

Thank you