SQL Server Performance

Link two datasets

Discussion in 'SQL Server Reporting Services' started by Toni, May 22, 2006.

  1. Toni New Member

    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
  2. smy New Member

    why don't you link both datasets' query into a single sql statement and create this one dataset for usage?
  3. Toni New Member

    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
  4. smy New Member

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

Share This Page