April 22, 2015 at 2:25 pm
I have a requirement that I'm trying to solve using a tooltip. My report is a 4 level grouping, and includes a distinct count of job numbers.
What I would like to do is within the group is have a tooltip display the list of job numbers in that group. Something like this:
123456
234567
345678
I can get a single job number to display by just using Fields!JobNum.Value. I've looked at the Lookup and LookupSet functions but I don't believe it will work correctly in my situation as I have the 4 grouping levels to consider.
Has anyone done something similar?
Thanks.
Bill
April 23, 2015 at 9:05 am
Just wanted to post a solution I've implemented with help from:
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply