Post reply

Using lookup in SSRS or array formula

  • April 18, 2013 at 2:07 am

    #271290

    Hi community

    I am hoping you can assist me with this one.

    I have two datasets in my report which I want to 'combine'.

    One dataset has a set of managers with their staff and the other has manager, staff, booked time.

    Here is an example:

    Dataset1:

    Manager Staff

    Mngr1 staff1

    Mngr1 staff2

    Mngr1 staff3

    Dataset2:

    Manager Staff BookedTime

    Mngr1 Staff1 20

    Mngr1 Staff2 10

    Required view:

    Manager Staff BookedTime

    Mngr1 Staff1 20

    Mngr1 Staff2 10

    Mngr1 Staff3 0

    So basically I want to lookup the manager in Dataset2 from Dataset1 and return ALL the manager's employees.

    If the employee has not booked time I will then have 0 under the time.

    Is this possible in SSRS?

    I tried using the Lookup function but I am not getting it right (by the way I am using MS SQL 2008 R2).

    Thank you

  • April 19, 2013 at 7:16 am

    #1608198

    I solved this issue.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply