Display timestamp even if there is no entry

Hi,

We would like to display timestamp on x-axis even if there is no entry on that date. Right now when we select a date range , say Dec 1, 2009 to Dec 10, 2009, it just displays the date when it finds a hit but I would like to display other dates aswell with a null entry.

Any suggestions is appreciated.

Thanks,
Bharath

Find more posts tagged with

Comments

mwilliams

Hi Bharath,

You could create a scripted dataSource or a flat file dataSource that has all the dates in your range listed and then create a joint dataSet within BIRT to use for your chart, using a null or 0 value for the dates with no value in your data.

Hope this helps.

Bharath406

Thanks for the reply Michael. Is there any code sample that I can refer to? Because I never created a scripted dataSource. Also, I'm not comfortable with joint datasets.

Thanks,
Bharath

mwilliams

Bharath,<br />
<br />
I found this example in the devShare. It should help you out. Let me know if you have any questions.<br />
<br />
<a class='bbc_url' href='http://www.birt-exchange.org/devshare/designing-birt-reports/1006-add-missing-dates-to-chart-category-table/#description'>Add missing dates to chart category / table - Designs & Code - BIRT Exchange</a>

Bharath406

Hi Michael,

I tried that code sample. But got this error while trying to preview the results.

can't find method java.util.Calendar.setTime(number)

Any idea?

--Bharath

Bharath406

Sorry, my bad. I dont see the error now.

--Bharath

mwilliams

Bharath,

So, everything is working as expected now?