Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
 Posted - 2008-09-16 : 00:50:38
|
| I am working on reports which use charts. I have found a way to show a variable number of series plotted on the chart by setting the "Values" to a null string depending on a parameter. But the legend is still created for the series even when I dynamically set the "Series label" to Nothing, an empty string or " ". It defaults to "Series 1", "Series 2" etc.Does anyone know how to over-ride this or hide series in the legend? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-16 : 01:11:29
|
| change the sereies label to field value and try putting expression to set it to blank when nothing. |
 |
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-09-16 : 02:32:50
|
| Hi Visakh, Thanks. If I have understood you correctly, this is what I have tried. eg <=iif(isNothing(Parameters!series_name.Value(2)),"",Parameters!series_name.Value(2))>, but this defaults to Series 1, Series 2 etc when Parameters!series_name.Value(x) = Nothing |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-16 : 02:58:03
|
quote:
Originally posted by dexter.knudson
Hi Visakh, Thanks. If I have understood you correctly, this is what I have tried. eg <=iif(isNothing(Parameters!series_name.Value(2)),"",Parameters!series_name.Value(2))>, but this defaults to Series 1, Series 2 etc when Parameters!series_name.Value(x) = Nothing
is series name a multivalued parameter? |
|
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-09-16 : 17:10:18
|
| Yes |
|
|
|
|
|
|
|
|
Dynamic number of series on chart