Custom Crystal report in Sage 100 2022 Premium. Main report calls a stored procedure that populates a number of tables, and then there is a subreport with the data from a view. There is an existing report on the same system with the same structure which works fine. MAS_Reports has been granted execute rights on the stored procedure and select on the view. The report runs fine in the Designer, but when added to the custom reports menu gives this error:
"The database login failed. Error in File InvDemand custom 13096_9820_{F75E3B83-CF63-4DAD-9762-F31D022CE798}.rpt: The table could
not be found."
Any ideas?
------------------------------
Phil McIntosh
Friendly Systems
------------------------------