Can I add Custom Crystal Reports which connect to SQL?

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

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

Children
No Data