Report column from other Tabelle

Hello Everbody,

i have create the Report below with the "VI_Reporting_DefaultTemplate" Template

<DatabaseExportDefinition BaseTable="ADSAccount">
<WhereClause>
uid_person in
(
Select ad.UID_person
from adsaccount ad
left join Person p on p.uid_person = ad.uid_person
where (DATEDIFF(m, ad.LastLogon, GETUTCDATE() ) &gt; 6)
AND
ad.AccountDisabled = 0
)
</WhereClause>
<Columns>
<Column ExportDisplay="True" ColumnName="surname" TableName="ADSAccount"/>
<Column ExportDisplay="True" ColumnName="givenname" TableName="ADSAccount"/>
<Column ExportDisplay="True" ColumnName="Samaccountname" TableName="ADSAccount"/>
<Column ExportDisplay="True" ColumnName="distinguishedname" TableName="ADSAccount"/>
<Column ExportDisplay="True" ColumnName="lastlogon" TableName="ADSAccount"/>
<Column ExportDisplay="True" ColumnName="canonicalname" TableName="ADSAccount"/>
<Column ExportDisplay="True" ColumnName="UID_Person" TableName="ADSAccount">
<Column ExportDisplay="True" ColumnName="internalname" TableName="Person"/>
</Column>
</Columns>
</DatabaseExportDefinition>


So long so good top report is running, but i need a further Column from the Person Tabelle.


If i set all Column by the End with / and delete </Column> i get the error below

Datenbankfehler 207: Invalid column name 'internalname'.
Invalid column name 'internalname'.

If i set the the <Column ExportDisplay="True" ColumnName="person.internalname" TableName="ADSAccount"/>

I get the error:
Datenbankfehler 209: Ambiguous column name 'InternalName'.
Ambiguous column name 'InternalName'.


Now how will be able to set a furthermore Column from the Person Tabelle?

german answers welcome ;-)

Parents Reply Children
No Data