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() ) > 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 ;-)
