Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Gantt chart multiple timeframes per series
Gantt chart multiple timeframes per series [message #1007103] Mon, 04 February 2013 08:27 Go to previous message
Hauke Luebbers is currently offline Hauke Luebbers
Messages: 4
Registered: November 2012
Junior Member
Hi,

I would like to show more than just one time frame per Y-Axis series of my gantt chart.
For example, on the Y-Axis are hotel rooms and on the X-Axis are the time frames that indicate that the room is blocked.

Sadly BIRT has this bug when it comes to showing multiple time frames in one series with grouping on the Y-axis ( bugs.eclipse.org/bugs/show_bug.cgi?id=376935 ).

So it thought that adding a dynamic number of Y-series depending on the number of time frames could be a workaround.

Now there are two problems for me:

First, my data set looks like this:

Room  |  start  |  end
room1 | 12412341| 12541234
room2 | 12342432| 13341234
room1 | 22345234| 23341234
...


So I think I have to refactor the data set that I looks like this, right?

Room  |  start1  |  end1   | start2  | end2 
room1 | 12412341| 12541234 | 22345234| 23341234
room2 | 12342432| 13341234 | 0       | 0       


This structure would not be possible with SQL as I do not know how many columns I need, but I would have to refactor the data set using Javascript if I am not mistaken.

After that, I would need to add a dynamic number of Y-series to my gantt chart.
Is there some example how to do that for the newer BIRT versions? I only found jasonweathersby.sys-con.com/node/1200405/mobile and could not really get it to work in BIRT 4.2.1

I would be thankful for some input whether my thoughts are correct and maybe an example how I could add a series to a gantt chart?

Thanks in advance, regards,
Hauke
 
Read Message
Read Message
Read Message
Read Message
Previous Topic:Where do I put sqljdbc_auth.dll file so that BIRT sees it?
Next Topic:Custom SQL as a parameter
Goto Forum:
  


Current Time: Sun May 19 05:18:33 EDT 2013

Powered by FUDForum. Page generated in 0.01873 seconds