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.
| Author |
Topic |
|
anishap
Yak Posting Veteran
61 Posts |
 Posted - 2012-10-26 : 14:46:14
|
| I'm trying to join 2 datasets in SSRS but I don't know if there is any way to do is.Below is the query Dataset1 SELECT E.FLDID,E.FLDLNAME,E.FLDFNAME,D.FLDDESCR AS DEPT,J.FLDDESCR AS JOB,E.FLDEMAIL,I.FLDDATE,I.FLDTYPE,I.FLDSTATUSFROM EMPLOYEE E LEFT OUTER JOIN IMMUNE ION E.FLDREC_NUM = I.FLDEMPLOYEELEFT OUTER JOIN DEPT DON D.FLDCODE = E.FLDDEPT LEFT OUTER JOIN JOB JON J.FLDCODE = E.FLDJOBWHERE I.FLDDATE >= '2012-07-01' AND I.FLDTYPE IN ('109','111') ORDER BY E.FLDLNAME, E.FLDDEPTDataset 2 (is on Access database)I just want to join the employee table in dataset2 to the above query on dataset1.Is this possible?**********************************For example DATASET1.EMPLOYEE.EID = DATASET2.EMPLOYEE.ID |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-10-26 : 14:56:46
|
| As far as I know, SSRS does not let you do this. You will have to do it at the source (SQL Server or Access) |
 |
|
|
|
|
|
Multiple Datasets