I'm using an SQL version of Sage, and use Sage 100 Premium. I'm having an issue with a report in Sage Intelligence.
I have a copy of the Sales, Customer Sales report that I had copied into another folder. When I try to click on it, it immediately produces an error 'The function GetDataValue can only service SQL calls that result in a single return value. Please modify the SQL statement accordingly. The SQAL statement supplied was: - SELECT entity_id FROM report entity WHERE report _id = 180 AND report_entity_type_id =1'
I can't delete the report, and I can't run the report. I tried going under 'Home', right clicking, switch output mode to SQL debug, but I still can't run the report for it to debug. It looks to me like it is trying to use an old report ID that no longer exists, so it ends up trying to use an ID of another report. I've looked in the templates folder on our server, and I do not see a template with the same name as the messed up report. I've tried linking it to a report of it's own, but no success. The report renames itself to another report with another ID number.