Graphical Representation of Seating

Hi All,
My requirement is to display a seating arrangement graphically. That is, show a grid from 1 to n number of seats and show a number highlighted in green if the seat is occupied.
For example take an airplane seating arrangement, a seat number is to be shown green if the seat is booked/occupied.

Attached a CSV and expected output screenshot (done in excel) The seat column in CSV indicates only the occupied seats.

Can anyone tell me how this can be done in BIRT reports? Or if this can be done at all?
I tried a bit of scripting but it went haywire.

Find more posts tagged with

Comments

mwilliams

Looks like your file didn't get attached.

Giria

Oh! Will attach again. Hope this one Sticks!

And i am supposed to click "Attach file" after selecting it. :wacko:

mwilliams

Yep. It can be kind of confusing!

mwilliams

What's your BIRT version? Will the seating setup always be the same for a given report?

Giria

I am using BIRT with eclipse. 3.7.1
BIRT runtime is also 3.7

Giria

Sorry i dint see the second part of your question.
The seating setup will be the same. As in 45 in Economy, 8 in Business etc.
But the occupied seats will change. That is the CSV will change from report to report.

So if i get Seat 46 as data in CSV then its an error.

mwilliams

Here's one way to do it. Be sure to change the flat file location to where you have this CSV saved, in the flat file data source.

Giria

Thanks a ton for that! It works like a charm. Tried altering the data and that works!

But i couldnt understand one little bit how you got that done. I first need to learn what a Scripted Data source is and then come back with more question!

Thanks a lot again

I will need to learn how to get this done. So please dont close off this topic yet.

mwilliams

What I did was create a scripted dataSet that assigned seat numbers to columns, how the setup is, in economy, first class, and business class. This makes sure that all seats appear. In the beforeOpen of the CSV dataSet, I created 3 arrays to store the "taken seat" numbers. In the onFetch, I checked the seat class and stored the seat value in the appropriate array. In the beforeClose, I assigned each array to a persistentGlobalVariable, for use in the highlight rules. I added a text box bound to the CSV dataSet to force the arrays to be filled. Then, on each detail cell of each of the 3 seating class tables, I added a highlight rule to check if the current seat number was included in the array stored in the PGV. Hopefully this clears up what was done. Let me know!