Hi All,
I have created simple list report with below xml in manager.
When preview report I get error. Same report execute without any error on my sandbox environment.
[810117] Value UID_PersonHead was not found.
<DatabaseExportDefinition BaseTable="ITShopOrgHasQERResource" TimeZone="UTC"> <WhereClause>XObjectKey IN ( SELECT y.XObjectKey FROM ITShopOrgHasQERResource y LEFT JOIN ITShopOrg iso ON y.UID_ITShopOrg = iso.UID_ITShopOrg LEFT JOIN Department d ON iso.UID_Department = d.UID_Department LEFT JOIN Department dp ON d.UID_ParentDepartment = dp.UID_Department WHERE dp.DepartmentName = 'DERDE' ) </WhereClause> <Columns> <Column TableName="ITShopOrgHasQERResource" ColumnName="UID_QERResource" ExportDisplay="True"> <Column TableName="QERResource" ColumnName="Ident_QERResource" ExportDisplay="True" /> </Column> <Column TableName="ITShopOrgHasQERResource" ColumnName="UID_ITShopOrg" ExportDisplay="True"> <Column TableName="ITShopOrg" ColumnName="UID_Department" ExportDisplay="True"> <Column TableName="Department" ColumnName="DepartmentName" ExportDisplay="True" /> </Column> </Column> <Column TableName="ITShopOrgHasQERResource" ColumnName="UID_ITShopOrg" ExportDisplay="True"> <Column TableName="ITShopOrg" ColumnName="UID_Department" ExportDisplay="True"> <Column TableName="Department" ColumnName="UID_ParentDepartment" ExportDisplay="True"> <Column TableName="Department" ColumnName="DepartmentName" ExportDisplay="True" /> </Column> </Column> </Column> <Column TableName="ITShopOrgHasQERResource" ColumnName="UID_ITShopOrg" ExportDisplay="True"> <Column TableName="ITShopOrg" ColumnName="UID_Department" ExportDisplay="True"> <Column TableName="Department" ColumnName="CustomProperty01" ExportDisplay="False" /> </Column> </Column> <Column TableName="ITShopOrgHasQERResource" ColumnName="UID_ITShopOrg" ExportDisplay="True"> <Column TableName="ITShopOrg" ColumnName="UID_Department" ExportDisplay="True"> <Column TableName="Department" ColumnName="UID_PersonHead" ExportDisplay="True" /> </Column> </Column> </Columns> </DatabaseExportDefinition>
Do you have any idea how to resolve this error.
Thank you.
Kind Regards,
Dnyandev