Crystal Reports Connection Issue

SUGGESTED

I'm attempting to connect crystal reports to Sage 50 (2023) so that we can perform an export of all customer ship to addresses in the company (not sure if this is possible from within Sage 50?).  I followed the instructions in KB article 223924350032954:

How to use SAP Crystal Reports with release Sage 50—U.S. Edition 2015 or higher

But when I get to the point of choosing the data link file in Crystal, and specifying the 'Peachtree' username (and password configured within Sage 50):

I get:

Any assistance would be greatly appreciated!

Parents
  • 0
    SUGGESTED

    Within the Company that you need to connect the Crystal Report to, go into Maintain then Users and Setup Security. Client on the Data Access/Crystal Reports tab and choose the second option on the left. Click on the Change button to set the password that you'd like to use with Crystal Reports. When done, on the right side of the screen, with Crystal Reports closed, click on the hyperlink Install Sage 50 Data Functions. Once you receive the confirmation that this has been done, click on the Save and Close button at the bottom of the screen. Open Crystal Reports and when the system asks you for the User Name, it will prepopulate Peachtree, and then fill in the Password that you specified in Sage 50 for Crystal Reports.

    Tammi M. Ermerins ([email protected])

    Certified Sage 50/Peachtree Accounting & Crystal Reports Consultant & Trainer

    800-780-0700 / 954-961-0600, Visit Us on the Web at https://pcosupport.com

Reply
  • 0
    SUGGESTED

    Within the Company that you need to connect the Crystal Report to, go into Maintain then Users and Setup Security. Client on the Data Access/Crystal Reports tab and choose the second option on the left. Click on the Change button to set the password that you'd like to use with Crystal Reports. When done, on the right side of the screen, with Crystal Reports closed, click on the hyperlink Install Sage 50 Data Functions. Once you receive the confirmation that this has been done, click on the Save and Close button at the bottom of the screen. Open Crystal Reports and when the system asks you for the User Name, it will prepopulate Peachtree, and then fill in the Password that you specified in Sage 50 for Crystal Reports.

    Tammi M. Ermerins ([email protected])

    Certified Sage 50/Peachtree Accounting & Crystal Reports Consultant & Trainer

    800-780-0700 / 954-961-0600, Visit Us on the Web at https://pcosupport.com

Children