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).

The command

=join(Parameters!Report_Parameter_0.Value, "-")

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.

=join(ReportItems("mess").Value, "-")

=join(Fields!fau_mes.Value, "-")

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.

Thank you

Jason Shaw