Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Can I add Custom Crystal Reports which connect to SQL?

Posted By adev77 over 15 years ago

All my current Crystal Reports in MAS 200 pull from the ODBC datasource. I have an SQL server with some tables in it. I created a report which pulls data from the SQL database it runs fine outside of MAS. However I cannot seem to run it within MAS. Any ideas?

Parents

BigLouie over 15 years ago

One of the issues is that when you try to run it the report engine will attempt to update the report to the current version. Since the report is not based on MAS tables this will fail. You can try putting in the key words "Converted to version 4.30" in the Summay Information area. This will stop the program from attempting to upgrade and MIGHT allow you to run the report.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Reply

BigLouie over 15 years ago

One of the issues is that when you try to run it the report engine will attempt to update the report to the current version. Since the report is not based on MAS tables this will fail. You can try putting in the key words "Converted to version 4.30" in the Summay Information area. This will stop the program from attempting to upgrade and MIGHT allow you to run the report.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Children

No Data

Sage 100

Can I add Custom Crystal Reports which connect to SQL?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING