I am trying to add the Project description field to display on the Quote Report and am receiving an Invalid Column Name error.
What I have done.
Created a UD field (ProjLink_c) on the QuoteHed table. Regenerated the database, all looks good.
Customized the the Quote form header tab adding an EpiRetrieverCombo bound to the QuoteHed.ProjLink_c column. Works to display the Project Description on the header tab.
Copied the Quote data definition to a new name. Added the Project table. Created a new relationship from QuoteHed to Project on Company >> Company, ProjLink_c >> ProjectID.
Included Company, ProjectID, Description from the exclusions tab
Test the new report, returns the basic quote information.
Modify the Quote dataset properties query adding T1.ProjectID, T1.Description
Add both as new fields
Try running the report and returns Invalid column Name error. I hav tried various version of column naming but nothing seems to work here (T1.Project_ProjectID, T1.Project_Description).
I haven’t found anything in the other topics that reference “Invalid column Names” to get me past this.