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=’:)‘ />]