Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How do I reference the same file more than once?
Spoke too soon - it works in the query test but then gives me an error message when I try to save it: "An item with the same key has already been added." SELECT DISTINCT csori#, cscas#, oacas#, csstat, oaofic, oaasst, oaasby, oaaymd, tedesc, e.ombdg#, e.omlnam, e.omfnam, s.ombdg#...- steved45
- Post #4
- Forum: Microsoft SQL Server: Reporting Services
-
How do I reference the same file more than once?
Works perfectly - THanks!- steved45
- Post #3
- Forum: Microsoft SQL Server: Reporting Services
-
How do I reference the same file more than once?
Please bear with me I'm very new to SQL / Server and am jumping in to a project. I'm building a report in MS Report Builder 3.0. In the Dataset Query to assemble the fields I'll use I have to join 4 files / tables (this is on an i5 DB2400 in ODBC). In the database there is one personnel file...- steved45
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Reporting Services
