I am having some problems getting this to work on Reporting Services 2005.
I am trying to produce a key in the footer of a report, of possible values and descriptions (job codes).
works as expected to join the parameters in to a list, but I can not get it to work with the data I have in my Dataset whatever I try I am getting an error. I have tried to use field values and reportitems method but nothing seems to work.
I have started a new report and tried the commands in the table footer rather than the page footer but it does not seem to make any difference.