Support Article
Report Editor: Drag&Drop "property does not exist/unoptimized"
SA-35464
Summary
When trying to drag and drop an unoptimized property getting an error.
Error Messages
Error 1:
ValidatePropertyName 'IsNotAValidField'
Error 2:
"HandOverToOperationsDate" this property does not exist or has no column mapping
body:""pySQLFunction: ** An invalid column has been entered as a parameter in [Date Value] for a calculation: pxDay. The column does not exist, or is optimised."
Steps to Reproduce
- When creating a new report for the AGCS-LI-Work-AltQuote class, all the properties defined in this work class and in all the classes mentioned in the inheritance can be found through the search.
- But for the embedded page (pagelist, pagegroup) properties there is an issue.
- For example, as shown below, I have a page property .EMailPage of class AGCS-Data-Email in the parent class of AGCS-LI-Work-AltQuote class. Then for this page property I can only see in the Report Editor the properties created directly in the AGCS-Data-Email class. So no inherited properties of AGCS-Data-Email class are available.
- Observe: drag and drop an unoptimized property gets an error.
Root Cause
Since the report definition was not saved it was still referring the context of pyDefaultReport. So, it is not able to validate the properties.
Resolution
There are two solutions for this issue:
- The user has to save as pyDefaultReport in Work- Class to their application ruleset and has to enable "Display Unoptimized Properties" in data access tab to display unoptimized properties in data explorer of the report editor.
- The user can also first save the report and then again open the same report from report browser and then drag and drop the property.
Published April 7, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.