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
 SQL Server 2000 Forums
 SQL Server Development (2000)
 linking two datasets in report designer

Author  Topic 

malcolm
Starting Member

2 Posts

Posted - 2006-03-23 : 01:18:50
Please:

(1) I have created two datasets in Report Designer.

(2) One has a single summary record (for one kind of data) and is identified by a key field.

(3) The other has multiple detail records (for another kind of data) and they too are identified by the same key field.

(4) I now want to create a third dataset that combines the first two by the key field.

(5) How do I do that?

(6) How do I link two datasets together in Report Designer based on a common key field (as I would two tables or two queries in Access, for example . . .)?

Thanks.
   

- Advertisement -