January 28, 2015 at 8:47 am
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????????
January 28, 2015 at 9:03 am
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
January 28, 2015 at 9:17 am
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,"," )
January 28, 2015 at 9:22 am
No there no parameter set up.
It gives everything in one chart.so I cannot use the parameter expression.
January 29, 2015 at 6:49 am
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