August 2, 2009 at 11:21 pm
Hi I am Working Reporting Services. I'm trying to format a list of values horizontally as opposed to vertically. I create my list to display the values returned in my query, and they display like this:
Value 1
Value 2
Value 3
What I want it to do it display them like this.
Value 1, Value 2, Value 3
This report is actually display the Values Horizontal, so the horizontal formatting is necessary for it to fit correctly.
I can't seem to find a list property to control this. My thought was that I could write some custom code to loop through the DataSet and append each value to a string. Then in the text box, just display the entire string. But so far I have not been able to figure out the syntax to do this.
Please Any one help out Form this Issue.
thank U
August 3, 2009 at 3:22 am
Hi Sanjay,
did you try
=Join(yourcolumn, "delimiter")
January 26, 2012 at 9:19 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply