Eclipse BIRT Designer Version 2.3.2.r232_20090202 Build <2.3.2.v20090218-0730> in econ_library.defaultTheme /templates/blank_report.gif ltr lib/econ_library.rptlibrary econ_library dynamic integer simple Select Conference list-box setConference dataSetRow["conference_id"] dataSetRow["name"] false true 3 true Unformatted static integer simple Min Number Of Talks false true list-box false true 4 true Unformatted 1 1 2 2 3 3 4 4 5 5 6 6 7 7 com.mysql.jdbc.Driver jdbc:mysql://localhost:3306/alumni root cVRZRzMyNDE= 1 avail_short decimal 2 avail_long decimal 3 avail_main decimal 4 avail_tutorial decimal srcEclipseCon paramConferenceId paramConferenceId integer 1 true false 1 avail_short avail_short decimal 2 avail_long avail_long decimal 3 avail_main avail_main decimal 4 avail_tutorial avail_tutorial decimal select sum(short) avail_short, sum(a.long) avail_long, sum(mainstage) avail_main, sum(tutorial) avail_tutorial from allocation a where conference_id = ? 1 conference_id integer 2 name string srcEclipseCon 1 conference_id conference_id integer 2 name name string select distinct conference_id, name from conferences 1 conference_id integer 2 cat string 3 10 decimal 4 20 decimal 5 25 decimal 6 30 decimal 7 short decimal 8 longtalk decimal 9 mainstage decimal 10 tutorial decimal srcEclipseCon paramConferenceId paramConferenceId integer 1 true false 1 conference_id conference_id integer 2 cat cat string 3 10 10 decimal 4 20 20 decimal 5 25 25 decimal 6 30 30 decimal 7 short short decimal 8 longtalk longtalk decimal 9 mainstage mainstage decimal 10 tutorial tutorial decimal select * from vw_alloc_flat where conference_id = ? order by cat portrait 0.5in 0.5in 0.5in 0.5in 0in 0in html new Date()]]> 100%setAllocation conference_id conference_id dataSetRow["conference_id"] integer cat cat dataSetRow["cat"] string 10 10 dataSetRow["10"] decimal 20 20 dataSetRow["20"] decimal 25 25 dataSetRow["25"] decimal 30 30 dataSetRow["30"] decimal short short dataSetRow["short"] decimal longtalk longtalk dataSetRow["longtalk"] decimal mainstage mainstage dataSetRow["mainstage"] decimal tutorial tutorial dataSetRow["tutorial"] decimal sum10 float SUM Expression row["10"] sum20 float SUM Expression row["20"] sum25 float SUM Expression row["25"] sum30 float SUM Expression row["30"] sumCurated float SUM Expression row["short"] sumLong float SUM Expression row["longtalk"] sumMain float SUM Expression row["mainstage"] sumTutorial float SUM Expression row["tutorial"] 1.5in 0.6in 0.6in 0.6in 0.6in 0.6in 0.6in 0.6in 0.6in
cat 10 20 25 30 short longtalk mainstage tutorial
green_circle.svg.png iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAABmJLR0QA/wD/AP+gvaeTAAAAB3RJTUUH 1wwaEScpvCg/gwAAA89JREFUeJztmz+IFFccxz9vZvQKRcUEcyBGTJEQkWP/iEc6TbALKIKpLHKQsBdI 7K6yuUabdCrcHgYuRaochIC2SezCCbN7iF5ICsVIYBPNoeEsNs7Mz2KnkDhvdmZu3sxubj7tvvfb7/fL 25m3b34DFRUVFVsYVdQXTS1M7XMc54jy1dsoDirUXhHZAaCUeibIOsIDseU3z/Pu3P7s9l9F6DIXwDxW fbJ+Qil1WqHeBw6nrLAmyI8i8n231/2JeQITMnMP4NjVY6/5jn8excfAmzmV/R3ha9uzL9/6/NbfOdUE cgygtlTbY/ftCyhmgZ151f0PGwhtf8K/uDqz+iSPgrkE0Gg3zimlvgQm86iXgJ6IzHVmO99sttCmApi+ PL3Lm/C+As5uVkhGlp2+88nK+ZV/shbIHEC9XT9sKesGcChrjZy4H0jwYXe2u5ZlcqYA6u36e6H5vVnm G2A9DOHntBNTB9BcbE4DPwA70s41zDPgA7flrqSZZKUZfHTh6BHgOqNnHgaarocaE5N4BTQXm7uBDvBW SmFFcw9ouC33aZLBaVbANUbfPAw0Xks6OFEAjXbjHOXd6rJwNtQ8lKE/gdpSbY/9r/0LxW1y8qLnb/ff HbZjHLoC7L59gfEzDzAZao8ldgU0F5uvA/cxt7c3zQZwyG25j3UD4leA8AXjax5gZ+hBiz6AeSwUM7lL KhrFDPN6n9oPGvsbx4EDJjQVzIHQSyT6ZALrjBE5JRDnRRuAIMeNqCmBOC+Rd4Gphal926xtfxpTVALP g+dvRB20Rq4Ax3FS/aEYB3SeIgNQgXrHrJzi0XmKvgYoDhpVUwYaT9EBCLuMiikDjSfdXWC3QSllEekp 1YnQ/xFdAIlOU8aMSE+6i2Dmc/aRReNJdxF8YFRMGWg8RQYglvxqVk3x6DxFBuB53h2zcopH5ykygHDP fNeoomK5q2u40N4GFeqmMTkFE+dFG0BgBd8ZUVMCcV60AXT+6NwEHpoQVDAPQy+RxJ0JBghLJhQVirAU 118UvxVWXGFwtDyubIQetMQG4LbcxwjtfDUViNCOeyYACf4M+RP+RaCXm6ji6IXaYxkawOrM6hMRmctH U3GIyFySTrI0/QHfMj5PiJfdlvtRkoFpzgM+ZdB8MOrcY6A1EYkDcFvuUxWoU8CjLKoK4pEK1Kmk3SFQ NUmlPxJzW+5KIMFJYD3tXIOsBxKcTGseqkbJ7Iei3dnumtN3asBy1ho5sOz0nVpW81A1S49fu7xCLXjb vUsj1S7/Mlv2hYlX2KqvzOgY1ZemKioqKrY0LwD9A2mxJ5MYDQAAAABJRU5ErkJggg== double_black_diamond.svg.png iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAABmJLR0QA/wD/AP+gvaeTAAAAB3RJTUUH 1wwaEScqJSFuOQAAAnxJREFUeJzt2z1IHFEUhuHXGIOCKUxhCkkhNmIh6cRKsAkIdoKVYCfYCXZiJ9gJ dmIldoKN2Al2YhlsglWsYhGEIERQxLgpPHddzezOz/1ZwjkfnEZ35/musro7cwcsFovFL1+U2gAMArfA aBvsUbEH22DXswPUgIM22Adi77TBBmAYeJASj8BYQntMzJp0GE5o17MnBdwcJbSPXtl7CW0APvP8G2ic iQT2RIb7KJ2S5TCjRA04SWCfNLEPE9gAjDcp4GYqoj2VY49HtOs5zinxFeiI4HbIsVvZxxHcF5nMKeBm JoI9U9CejGDXc1qwxDegM6DbKccsYp8GdF9kumABN3MB7bmS9nRAG3h6/Z2VLPEd6Apgd8mxythnBP47 NFuygJuFAPZCRXs2gA3AW+C8YokfQLeH3S3HqGKfS3fvzFcs4GbJw17ytOc9bADeAReeJX4CvRXsXnmu j30ha6icRc8CblYq2CuB7MUKNgA9wGWgEr+AvhJ2nzwnhH0paymd5UAF3KyVsNcC28tlF/8euApc4jfQ X8Dul8eGtK9kTYWzGriAm40C9kYke7Xo4j8A15FK3AIDLewBeUwM+1rWlpv1SAXcbLWwtyLb63mL/wjc RC5xDwxl2EPyvZj2jayxaTYjF3Czm2HvJrI3my3+E3CXqMQfYKTBHpGvpbDvZK3/ZDtRATf7DfZ+Ynvb wW+yfhJao/4lAMr/CIL9GwSUvxECeysMKP8wBPZxGFB+QgTslBig/KQo2GlxQPmFEbBLY4Dyi6Ngl8cB 5RskXFRvkQHbJAUo3yYHtlESUL5VFmyzNKB8uzzYDROA8ltmwG6aApTfNmexWP7v/AUuh/8gxX8XyAAA AABJRU5ErkJggg== black_diamond.svg.png iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAABmJLR0QA/wD/AP+gvaeTAAAAB3RJTUUH 1wwaEScpvCg/gwAAAURJREFUeJzt28ERgzAMRFElDdB/QaGt5MJemJDYYFmrFTujAv7zDDfM7t2L3LJd yS1m9tquHALi39uVQtjHl0I4ii+B8C9eGqE1XhKhN14K4Wy8BMLV+NQIo+JTIoyOT4XgFZ8CwTueGmFW PCXC7HgqhKh4CoTo+FAElvgQBLb4qQis8VMQ2ONdEbLEuyBkix+KkDV+CEL2+EsIKvGnENTiuxBU45sQ 1OO/Ijx3CI8jHaH9bFzMbLX4V/K61Rq/A4oITfGqCF3xagin4lUQLsVnRxgSnxVhaHw2BJd4jB3BNR5j RZgSj7EhTI3HWBBC4rFohNB4LAqBIh6bjUAVj81CoIzHvBGo4zEvhBTx2GiEVPHYKISU8dhVhNTx2FkE iXisF0EqHmtFkIzH/iFIx2NHCCXisT1CqXgMCCXjsdK/zt5j2Adbv3kbxAK+QwAAAABJRU5ErkJggg== blue_square.svg.png iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAABmJLR0QA/wD/AP+gvaeTAAAAB3RJTUUH 1wwaEScpvCg/gwAAAMhJREFUeJzt27ENwkAUBNE9y4IMXKVjAppBSFRDIXTyaQBMgm8seV76ddJo80sk Sdqttnidb68kpy4la6p2zX1+fDqNP55OSc7/L+qs1fHbaejZsUUOQAfQHIAOoDkAHUBzADqA5gB0AM0B 6ACaA9ABNAegA2gOQAfQHIAOoDkAHUBzADqA5gB0AM0B6ACaA9ABNAegA2gOQAfQHIAOoDkAHUBzADqA 5gB0AM0B6ACaA9ABtN0PsPxhotolQx06tayonnSBJGmL3ugmCspNlflZAAAAAElFTkSuQmCC