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

Help

Home

Home » Eclipse Projects » BIRT » Display asterisk for null values in Bar chart

Show: Today's Messages :: Show Polls :: Message Navigator

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

Tue, 19 June 2012 19:37

S K

Messages: 5
Registered: June 2012

Junior Member

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 155 times)

Report message to a moderator

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

Thu, 21 June 2012 20:22

S K

Messages: 5
Registered: June 2012

Junior Member

Any ideas?

Report message to a moderator

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

Fri, 22 June 2012 15:28

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

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 179 times)
Attachment: 2.6.2nullsbar.rptdesign.zip
(Size: 4.90KB, Downloaded 166 times)