Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Reporting Services List Formating -- horizontal formatting Expand / Collapse
Posted Sunday, August 2, 2009 11:21 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, December 14, 2009 9:17 PM
Points: 9, Visits: 63
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
Post #763893
Posted Monday, August 3, 2009 3:22 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, January 25, 2016 3:41 AM
Points: 44, Visits: 147
Hi Sanjay,

did you try

 =Join(yourcolumn, "delimiter")

Post #763950
Posted Thursday, January 26, 2012 9:19 AM


Group: General Forum Members
Last Login: Wednesday, August 26, 2015 3:16 AM
Points: 126, Visits: 334
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
Post #1242284
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse