When I put more than one data source at the same level, I’m having a problem where the fields for one of the data sources have their records offset by one record on the report.
for example, I setup the following data sources where CustTable and InventTable are both children of SalesLine
SalesLine
— CustTable
— InventTable
The report displays the sales order, line number, customer name, and item name.
The sales order, line number, and customer name all show up fine in the report, but the item name column is all off by one record.
Try setting fetchMode to 1:1 on both child datasources.
This might help
When I try that, I get the following error message:
The total, internal size of the records in your joined SELECT statement is 25006 bytes, but Microsoft Dynamics is by default performance-tuned not to exceed 24576 bytes.
In SQL terms, what I’m trying to get is something like
Select SalesLine.SalesId, SalesLine.ItemId, CustTable.Name, InventTable.ItemName from SalesLine
join CustTable on SalesLine.CustAccount = CustTable.AccountNum
join InventTable on SalesLine.ItemId = InventTable.ItemId
Since I’m having trouble with setting up the data sources, I’ve also looked into overriding the fetch method and using a SQL statement instead, but I can’t figure out a way to send a record that contains all the data from all three tables. All the examples I’ve seen use the send method to return data from one table.
Well, the message you are getting - take a look at the Database Tuning Tab in your Dynamics AX Server Configuration Utility. Someone put a too small of a number there in the Max.Buffer size.
I just tried building the same report as you (based on the query you posted here), and it works like a charm.
You can download and try it out from here:
http://www.axaptapedia.com/images/0/07/Report_Report1.xpo