Chart in Reporting Services

hey all

I am using RS 2005

I have a report with chart

parameters = value1, value2, value3, all

How can I make the chart only show when all is selected?

cheers

jewel

Hi,

The chart component has a Visibility property.

In this property you can use an expression which checks the value of the parameter.
For example: when setting the Visibility.Hidden property to

=IIF(Parameters!MyParameter.Value = "All", false, true)

The chart will only be displayed when the value of the MyParameter is All.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

thanks for your answer Geert but

when I add that line I get this error

[rsParameterReference] The Hidden expression for the 'chart1' refers to a non-existing report parameter 'MyParameter'.

I also tried with 'Select All' which is the actual wording of my parameter but still get the same message.

These values are specified in the available values - non queried part of the report parameters.

not sure what I am missing here?

thanks

jewel

|||

The MyParameter refers to a report parameter. This was just an example. You need to change the name of to one of your report parameters.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

sorry about that Geert

Must be a slow reaction to being back at work after a break. Absolutely right!

cheers for this

jewel