x Want to participate? Join the group to interact
Options
  • Replies 6 replies
  • Subscribers 117 subscribers
  • Views 7617 views
  • Users 0 members are here
Browse Forums
Announcements
289
topics
370
replies
Business Object Interface
1k
topics
7k
replies
Core Financial Modules
2k
topics
8k
replies
Customization and Productivity
3k
topics
12k
replies
Distribution, Manufacturing, and Applications
2k
topics
7k
replies
General Discussion
1k
topics
3k
replies
Partner Cloud
43
topics
90
replies
Payroll, Time Tracking, and Job Cost
775
topics
1k
replies
Reporting and Analytics
960
topics
3k
replies
Sage CRM for Sage 100
164
topics
357
replies
Technical and Installation
2k
topics
9k
replies
Year-end Forum
89
topics
237
replies
adev77

Can I add Custom Crystal Reports which connect to SQL?

Posted By

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?

 

  • I was told by Sage that MAS does not like internal reports linked to outside tables. I put it in the Custom Reports folder and it wouldn't work. I added it as a task on the menu.

     

    Skip 

  • 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.

  • BL,

    That's exactly what happened when I tried to run it.

     

    Skip 

  • Can you use MS Access to link to your SQL tables? If so, you should be able to add a report to the Custom Reports menus that links to the MS Access database using the "Database Files" method instead of "ODBC (RDO)" method. 

     

    SOTAMAS90 is the only ODBC source allowed, but a different source can be used by manually changing the Keywords field in "Summary Info..." to say "Converted to version 4.30".

  • I've tried adding ODBC data sources other than SOTAMAS90, but they would not work inside MAS90 at run time.  With what ODBC data sources other than SOTAMAS90 have you been successful?

  • For ODBC datasources other than SOTAMAS90, I link them inside an Access database. Then in Crystal, I base my report off of a "DATABASE FILE" not an ODBC datasource and pick the Access database -- which I choose from a UNC path so that it is fully accessible. 

     

    Then I can change the keyword to "Converted to version 4.30" and put it on the MAS menu.

     

    Dawn

*Community Hub is the new name for Sage City