Reporting Services List Formating -- horizontal formatting

  • 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

  • Hi Sanjay,

    did you try

    =Join(yourcolumn, "delimiter")

  • 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