FormerMember

Need Help in connecting sage50 to crystal report

Posted By FormerMember

Hi, 

I need help in connecting sage50 to crystal report. I have some problem in configuring the ODBC Administrator in the crystal report.

I noticed that before, in the ODBC Administrator window, you can easily choose options such as Sage50: Last opened, Sage50 : <filename>.SAI

Simply Compatible : <filename>.SAI; Simply Accounting : <filename>.SAI;

But this time they are not showing. I don't know what went wrong. 

I am using Windows 7; 

and my simply accounting/ sage50 is 2013 version 4

Can anyone help me? 

thank you.

Regards,

Jesher Go 

Philippines

  • 0

    As far as I know, it should still be working for you if it worked the last time you used it.  Without knowing more about the settings (eg. are there a lot of Sage 50: xxxx.sai files listed?) and what you are trying to accomplish (eg. design or running a report or running a form) it's hard to tell you exactly what to do.

    However, assuming you are just trying to run a report, you should use the MS Office Documents program on the Reports menu.  It will automatically connect you with the appropriate open database.  Just follow the prompts to select the correct path to the report, database if it is not already selected, and enter the proper username and password.