• Just wanted to post a solution I've implemented with help from:

    http://www.bidn.com/blogs/DevinKnight/ssis/2899/ssrs-%E2%80%93-using-lookup-function-for-multiple-column-join

    and

    http://www.sqldbpros.com/2012/05/create-a-list-in-your-ssrs-tooltip-not-impossible/

    The first link explains a method to create a 'KeyField' that joins multiple values into a searchable field. The second post uses the Lookupset function to gather the job numbers from the dataset.

    Hope this helps someone.

    Bill