Select & Where Clause in RS | SQL Server Performance Forums

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? Regards
Toni 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
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |