Multiple values

  • I am working on a chart and on the title I want to show a field which actual has multiple values.

    If I use the syntax

    = "Trend for Departments " & Fields!department.value

    It gives me only one department

    However if I use the syntax

    = "Trend for Departments" & Join(Fields!department.value, ",")

    It gives me #Error

    Any ideas????????

  • I presume you already have a parameter set up to distinguish all the individual Department Codes

    try using Parameters! instead of Fields! and specify which parameter you would like to take the value from

  • quickly tested if you have parameter set up this should work 😀 with Department being whatever you called the department parameter on the report.

    ="Trend For Departments " & Join(Parameters!Department.Label,"," )

  • No there no parameter set up.

    It gives everything in one chart.so I cannot use the parameter expression.

  • If you directly use data field in the chart title, it will only use =First(Fields!Department.Value)

    And JOIN() function can only be used on joining values in an array so that it will show #ERROR when you put in the data field.

    In this scenario, I suggest you fill the data filed into a parameter, then use Join(Parameter!param1.VALUE,",")

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply