Hi All ,

I just encountered a new requirement and i'm struck here, please help me out in SSRS report in ms crm:

Table 1 

Date Ename

1 jan       arti

2 jan       shubham

3  jan     shan

Table 2

Date         Ename         Post

 3 mar        arti                SE

  4 mar       sheeza         QA

  5 mar       shez             Caller

Result should be in table 1

Date      Ename

1 jan       arti

3 mar     arti

2 jan       shubham

3  jan     shan

Query is if in table 2 any record is present which is present in Table 1 which is arti, so i want to display table 1 record as it is in table 1 and i also want to add one row in table 1 for matching record found in table 2