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
 
				 
		 
					