Conditional Rendering a Baseline?

[noonie]

Hello everyone!
I have a chart with a baseline.  However its possible the value associated with the baseline could be zero.  Is it possible to turn off the baseline if a zero value is returned?

Thanks,
Noonie

[anjan]

Hi,

for the quick sol, have two charts, one with base line and one with out base line,assign a render variable based on baseline value.

Hope this helps.

Thanks

[noonie]

Thanks Anjan,

Ideally, it would be alot of work to implement that.  The report has up to 20 pages and this target line appears in all of them.  If there was a way to build it into the query calculation or something like that, it would be alot better.

Noonie

[Lynn]

There is a render variable property associated with a baseline. Would that work for your situation?

[noonie]

Hi Lynn,

I can't see that in my properties.  There is only a render variable property on the chart itself. 
I'm using 10.1.
That would be exactly what I'd need. Otherwise, I will have to copy the chart and use a conditional block.

thanks,
Noonie

[MFGF]

Hi Lynn,

I can't see that in my properties.  There is only a render variable property on the chart itself. 
I'm using 10.1.
That would be exactly what I'd need. Otherwise, I will have to copy the chart and use a conditional block.

thanks,
Noonie

It's the very first property in the Baseline properties dialog:



Make sure you are not using the legacy charting engine still - go to Tools > Options and onto the Advanced tab, and make sure that "Use Legacy Chart Authoring" is not checked. If it is, you will need to uncheck it, close and reopen Report Studio, remove the chart and bring in a new chart from the newer charting engine.

Cheers!

MF.

[noonie]

Yeah the Legacy Chart was still ticked so that property wasn't appearing for me.
Thanks!