Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Combining data from 2 datasources in 1 tablix Expand / Collapse
Posted Tuesday, October 8, 2013 3:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 24, 2013 12:47 AM
Points: 4, Visits: 27
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?
Post #1502505
Posted Wednesday, October 9, 2013 1:13 PM


Group: General Forum Members
Last Login: Friday, November 18, 2016 8:05 AM
Points: 103, Visits: 582
There is not a way to relate 2 tablixes.

An option is to use subreports. For more info, check out these sites:

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.
Post #1503271
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse