The Point is Forms also have data source properties, but we only have to configure the property “LinkType”, i think it have the same functionality as the property “JoinMode” of query, but why we don’t have to configure the relations for the Form data source ?
Hi Martin, thanks a lot for you reply, i met i tricky problem like below:
i have two tables “GeneralJournalEntry” and “LedgerEntryJournal”. i have to create the relation between these two tables. the join mode is “OutJoin”.
if i set the Join mode as “OutJoin” and set the “relations” as “Yes”. there is a join create automatically under “relations” which is called “LedgerEntryJournal”, i have no idea where the system defines this one.
i set the relations as “No” and define the relations by my self (GeneraJournalEntry.LedgerEntryJournal == LedgerEntryJournal.RecId). the query can be compiled, but when i tried to use this query in the SSRS project. i got the error information as below:
I met this kind of problem in the Dynamics AX 2012 R2 system, The tricky is this can work in the Dynamics AX 2012 System. The VS can invoke the query without any problem.
If you guys who also has the 2012 R2 system, can you please help me to verify this , many thanks.
You should have described the problem on the beginning; we wouldn’t have to waste time discussing unrelated things.
I agree that there is a problem - I managed to reproduce it in AX 2012 R3. But I don’t agree that it’s related to the type of join or the Relations property. The same happens if I use inner join. And it works if I keep Relations to No and create the right relation.
The difference is whether the relation is defined by or JoinRelation = LedgerEntryJournal (which works) or by Field = LedgerEntryJournal and RelatedField = RecId (which leads to Object reference not set to an instance of an object).
Because I don’t see anything wrong with the relation, I suggest sending a support request to Microsoft.
By the way, LedgerEntryJournal relation is defined on GeneralJournalEntry table.