I'm currently working on custom reports for Dynamics 2012. Now i need to design a Salesinvoice report with a tablix in the body which has to show multiple order lines from two different data sources.
It needs to be able to show different order lines from the SalesInvoiceDS and multiple lines from the SalesOrderHeaderFooterDS. The specified data source for the tablix is SalesInvoiceDS, which means you can only show information from other data source in the tablix using the First or Sum aggregation in which you specify another data source, like this:
Is there a way to show multiple lines from different data sources in the same tablix? Or do i have to create multiple tablixes and fit them together so it will show as 1 table when it is printed?