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.