Eclipse Community Forums: BIRT » Display asterisk for null values in Bar chart

Home » Archived » BIRT » Display asterisk for null values in Bar chart

Display asterisk for null values in Bar chart [message #889825]

Tue, 19 June 2012 15:37

Eclipse User

I am using 2.6.2 and our requirement is to display asterisk in place of missing bars. I tried replacing null values with asterisk in afterDatasetFilled function, but chart does not display non-numerical characters.

Replacing the null value with zero and suffixing it with asterisk in the chart option produced a bar with height 1, which was not acceptable.

Attached is a screenshot of how the chart needs to look based on our requirement.

Thanks in advance

Attachment: Asterisk_null_bar.png
(Size: 10.13KB, Downloaded 193 times)

Re: Display asterisk for null values in Bar chart [message #890304 is a reply to message #889825]

Thu, 21 June 2012 16:22

Eclipse User

Any ideas?

Re: Display asterisk for null values in Bar chart [message #890571 is a reply to message #890304]

Fri, 22 June 2012 11:28

Eclipse User

If you can replace the null value with a value that will not show up in
your dataset then you could use a bit of script to hide the bar and
replace the label with an *. Take a look at the attached example.

If you want you could also use this feature:
http://www.eclipse.org/birt/phoenix/project/notable2.6.php#jump_8
set your null values to 0 and then use the same script in the above
example to hide the bar and change the label.

Jason

On 6/21/2012 4:22 PM, S K wrote:
> Any ideas?

Attachment: nullsbar.zip
(Size: 4.85KB, Downloaded 228 times)
Attachment: 2.6.2nullsbar.rptdesign.zip
(Size: 4.90KB, Downloaded 221 times)

Re: Display asterisk for null values in Bar chart [message #890719 is a reply to message #890571]

Fri, 22 June 2012 18:47

Eclipse User

Thanks. This would work for us.

Previous Topic:	Suppress group headers based on condition
Next Topic:	How to hide the first line in cross table

Goto Forum:

-=] Back to Top [=-

Current Time: Mon Jul 07 09:26:40 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter