COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: noonie on 16 Apr 2014 09:04:29 AM

Title: Conditional Rendering a Baseline?
Post by: noonie on 16 Apr 2014 09:04:29 AM
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
Title: Re: Conditional Rendering a Baseline?
Post by: anjan on 16 Apr 2014 09:07:53 AM
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
Title: Re: Conditional Rendering a Baseline?
Post by: noonie on 16 Apr 2014 09:14:36 AM
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
Title: Re: Conditional Rendering a Baseline?
Post by: Lynn on 16 Apr 2014 03:19:34 PM
There is a render variable property associated with a baseline. Would that work for your situation?
Title: Re: Conditional Rendering a Baseline?
Post by: noonie on 17 Apr 2014 06:11:41 AM
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
Title: Re: Conditional Rendering a Baseline?
Post by: MFGF on 17 Apr 2014 06:26:03 AM
Quote from: noonie on 17 Apr 2014 06:11:41 AM
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:

(https://image.ibb.co/m8Kb7v/Baseline_zps291b8fc4.png)

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.
Title: Re: Conditional Rendering a Baseline?
Post by: noonie on 17 Apr 2014 08:03:39 AM
Yeah the Legacy Chart was still ticked so that property wasn't appearing for me.
Thanks!