Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
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
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 8:37 AM
Points: 42, Visits: 318
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
Post #1503271
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse