Link two datasets | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Link two datasets

Hi I have two datasets that deliver information to a report in Reporting Services. How can I, by way of an expression link the common fields (dataset1.site_ref) & (dataset2.site_ref) and then display dataset2.specificfield.value to report cell/field? I aksed a similar question earlier but think that the repsonse I got relating to somethign else was more about join tables in T-SQL rather than linking datasets in SSRS. Regards
Toni Chaffin
aka Toni
why don’t you link both datasets’ query into a single sql statement and create this one dataset for usage?
Ummmm, ok. I will go away and look at that. smy, are you turning into my personal tutor I wonder? Kindest Regards Toni Chaffin
aka Toni
i also begin to wonder…had been suggesting alot on your doubts.. [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />but still, hope my suggestions do help you up.. [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |