Custom SQL views used in custom reports

I have created numerous custom SQL views in sage company databases and used them in custom reports, added to custom reports, and module forms.  I just did the same for a customer and cannot print/preview the report from the custom report's menu.  The error is that it cannot find the table when trying to generate.  Is there a SQL setting or Sage setting that I am missing?  The report can be generated outside of Sage, but not from menus.     

Parents Reply
  • 0 in reply to Jim Wimsatt

    Don't use a DSN.  That hard codes the company database, and requires all workstations have that DSN to run the report. 

    Using trusted authentication also has been known to cause us problems with custom reports / forms.  Take a functional custom report, do a Verify Database, then use that connection to Set Datasource Location in the new report.