SQL Server Performance Forum – Threads Archive
Select & Where Clause in RS
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? RegardsToni Chaffin
aka Toni
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…
OK, Noted, thanks for your suggestion. Regards
Toni Chaffin
aka Toni
]]>