Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  Reporting Services Development  Select & Where Clause in RS

Author  Topic  Tonic Starting Member 26 Posts Posted - 2006-05-22 : 05:15:32 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 C aka Talisa