SQL Server Performance

Select & Where Clause in RS

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

  1. Toni New Member

    Is it possible in RS 2005 to have linked fields on a report. I have one dataset that contains one section on information, I then have a seperate dataset which contains some different information.

    site_ref is the common link between the two datasets. I will write the sort of syntax I would expect to see in plain english and then perhaps someone could point me in a direction of the correct syntax to use if it is possible to do

    The following Assumptions made, two datasets containing a link on site_ref

    result textbox = show dataset2.budgetnetrent where dataset1.site_ref = dataset2.site_ref

    Does that make sense?

    Regards


    Toni Chaffin
    aka Toni
  2. smy New Member

    i don't think it works though..you can use sql query to join the tables in order to archieve the result without the usage of two datasets, instead, one dataset will be just nice...
  3. Toni New Member

    OK, Noted, thanks for your suggestion.

    Regards


    Toni Chaffin
    aka Toni

Share This Page