How to use SAP Crystal Reports

1. Install Sage 50 Data Functions

1. Open your company.
2. Select Maintain, Users, Setup Security.
3. Select the Data Access/Crystal Reports tab.
4. Select Install Sage 50 Data Functions.
5. Select OK on the confirmation message.
6. Under Access From Outside Sage 50, select With the following login information.
7. Keep the user name Peachtree.
8. Select Change.
9. Enter the desired New password. This password must be exactly seven characters long and include a number.
10. Select OK.
11. Select Close.

2. Set Up Crystal Reports Connection

1. Open Crystal Reports Designer.
2. Select Blank Report.
3. Expand Create New Connection.
4. Expand OLE DB (ADO).
    NOTE: If an OLE DB (ADO) connection already exists, you’ll need to click Make New Connection. 
5. Check Use Data Link File.
6. Select Browse button at the end of the Microsoft Data Link File box.
7. Browse to your company directory, select CrystalReports.udl, and then click OK.
8. Select Next.
9. Enter User ID (Peachtree), and then enter your Password.
10. Select Finish.
11. Select Update.

3. Connecting Sage 50 company data to Crystal Reports

1. If company data is still not populating in the report, open up a custom report in crystal reports.
2. Browse to Database, Database Expert.
3. Browse out to the OLE DB (ADO) connection set up earlier and select it.
4. Check Use Data Link File, and then browse to the CrystalReports.udl file in Microsoft Data Link File.
5. Uncheck Use Data Link File, and then select Pervasive PSQL OLE DB Provider under Provider.
6. Select Next, and enter the password for user ID; click Next and then Finish.
7. Verify that the custom crystal report loads up data from your company in Sage 50.