Home	RDP Sales	Contact Us	Training
RDP Support		Open a Web Support Ticket
RDPWin Knowledge Base	RDP-DOS Knowledge Base	IRM and IRM.Net Knowledge Base	Crystal Knowledge Base

How to Display only Last 5 Digits of Credit Card Number on Crystal Report

Added 3/16/2006 - Article ID#: KC00012

Problem Overview

Due to heightened credit card security, it is recommended that customers display only the last 5 digits of a credit card number when showing the credit card on a Crystal Report. In RDPWin revision 1.220 or higher, all RDP standard reports are displaying the credit card number with only the last 5 digits.

Solution:

In order to display the last 5 digits of a credit card number on custom Crystal reports, use the following steps:

Open the report.
Create a new formula by right-clicking Formula Fields in the Field Explorer and choosing New.
Type the name of the formula. In this example, the formula is named "CCLast5Digits".
Click Use Editor and use the following text as the formula:

            If Len(Trim({HExpense.CreditCardNum})) = 15 Then
                "**********" + Right(Trim({HExpense.CreditCardNum}),5)
            Else If Len(Trim({HExpense.CreditCardNum})) > 0 Then
                "***********" + Right(Trim({HExpense.CreditCardNum}),5)

The above formula is using the CreditCardNum field from the HExpense file. If the credit card number from a different file (like HReserve or Guests) is used, replace the field name in the above formula with the feld name from the correct file.
Click Save and close
Insert the new formula on the report.
If there are any sub-reports that are displaying a credit card number, a new formula must be added to the sub-report as well.

Payment Card Industry (PCI) Compliance
and RDPWin

April, 2008

Payment Card Industry (PCI) compliance is different for every RDP customer based on the volume of credit card transactions. RDP software may not be PCI compliant for all customers. There are many PCI compliance requirements that must be satisfied which have nothing to do with the RDP system. Every RDP customer must carefully examine the full PCI requirements. It is the responsibility of each customer to assure full PCI compliance. RDP is NOT LIABLE for damages or fines related to any level of credit card security. RDP offers no assistance, guarantees, or advice regarding PCI compliance, and cannot be held liable for any damages resulting from customer failure to comply with full PCI compliance standards.

RDP Suggests...

Read and implement all non-RDP requirements, some of which are outlined on Visa’s website at Visa Compliance Validation.
Upgrade to the current version of all RDP products.
Upgrade to the current version of Southern Datacomm Software or contact SDC's Technical Support at (866) 709-7880.
Review data encryption documentation and select Level 3 or 4, which may or may not be PCI compliant, based on your credit card transaction level.