I get this error after executing a report:
An unexpected event has occurred: Exception: The field does not exist, or is not a report field, or you are not permitted to use it: oppo_opportunityid
This is the view:
CREATE OR ALTER VIEW vProjectInfOppos AS
SELECT
PROJECT.*,
OPPORTUNITY.*,
projectinfluencer.*,
COMPANY.*,
null as orde_orderquoteid
FROM PROJECT
LEFT OUTER JOIN OPPORTUNITY ON (Oppo_ProjectId=proj_ProjectID)
LEFT OUTER JOIN projectinfluencer ON proj_ProjectID=prin_projectid
LEFT OUTER JOIN Company ON prin_CompanyId = Comp_CompanyId
WHERE
proj_deleted IS NULL
AND prin_deleted IS NULL
AND comp_deleted IS NULL
AND Oppo_Deleted IS NULL
Any ideas?
Hope to get help soon.