Does anyone know the best way to join fields from several tables onto a single report in SSRS 2005 and 2008????
Ed English
As Tara says, you need to design the backend query in such a way to pull the required tables after joining them on related fields. There's no other shortcut to it.
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
What if you need to join the tables from different databases which would mean different data sources?
Ed English
You don't need different data sources for this. Just use the three part naming convention in the query for the other databases. If some are on a different server, then you could choose to use the four part naming convention via a linked server.
What if you need to join the tables from different databases which would mean different data sources?
Ed English
you cant join data from multiple datasources inside report unless you're applying some aggregation. So you should do it in backend queries exactly as Tara suggested
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
SSRS
Posted - 03/12/2012 : 13:51:47
