Reporting Services List Formating -- horizontal formatting

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » Reporting Services List Formating --...

Reporting Services List Formating -- horizontal formatting

Rate Topic

Display Mode

Topic Options

Author

Message

Sanjay Rama Swamy

Posted Sunday, August 02, 2009 11:21 PM

Forum 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

bendy1999

Posted Monday, August 03, 2009 3:22 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, March 04, 2013 2:57 AM
Points: 44, Visits: 118

Hi Sanjay,

did you try

 =Join(yourcolumn, "delimiter")

Post #763950

jasonshaw

Posted Thursday, January 26, 2012 9:19 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 09, 2013 8:25 AM
Points: 124, Visits: 320

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 »

Permissions