October 8, 2013 at 3:21 am
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:
First(Fields!TaxCode.value, "SalesOrderHeaderFooterDS")
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?
October 9, 2013 at 1:13 pm
There is not a way to relate 2 tablixes.
An option is to use subreports. For more info, check out these sites:
http://technet.microsoft.com/en-us/library/ms160348(v=sql.100).aspx
http://www.youtube.com/watch?v=k_V4lam_5I0
http://technet.microsoft.com/en-us/library/ms160348(v=sql.100).aspx
On the subreport, create a parameter for the value that links the 2 reports. When you configure the subreport, pass in the field from the main report to the parameter on the subreport.
If you have any questions, let me know.
Sarah
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply