Eclipse BIRT Designer Version 2.3.1.v20080911 Build <2.3.1.v20080922-1151> 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 com.mysql.jdbc.Driver jdbc:mysql://localhost:3306/alumni root cVRZRzMyNDE= 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 srcEclipseCon paramConferenceId paramConferenceId integer 1 true false SELECT distinct SubString(c.category, INSTR(c.category, '-') + 2) cat , 'fred' super_cat , SubString(_type, INSTR(_type, '-') + 2) type , count(s.submission_id) cnt , a.short alloc_short , a.long + a.mainstage alloc_long , a.tutorial alloc_tutorial , (select count(*) from submissions ss where ss.tentative_status = 'tentative_accept' and ss._type = s._type and ss._category = s._category) accepted , (select count(*) from submissions ss where ss.tentative_status is null and ss._type = s._type and ss._category = s._category) neutral , (select count(*) from submissions ss where ss.tentative_status = 'tentative_decline' and ss._type = s._type and ss._category = s._category) declined FROM categories c left outer join submissions s on s._category = c.category inner join allocation a on a.category_id = c.category_id where c.conference_id = ? and c.category_id <> 25 and c.category_id <> 9 #and (s.tentative_status = 'tentative_accept' # OR s.tentative_status is null) group by super_cat, cat, SubString(_type, INSTR(_type, '-') + 2) order by super_cat desc, cat desc, type 0.5in 0.5in 0.5in 0.5in false false 0in 0in html new Date()]]> 1.3416666666666666insetSubmissionByType cntSuper integer grpSuper SUM Expression row["cnt"] cntCategory integer grpCategory SUM Expression row["cnt"] cntTutorial integer grpCategory SUM Expression row["cnt"] dataSetRow["type"] == '4 hours' cntShort10 integer grpCategory SUM Expression row["cnt"] dataSetRow["type"] == '10 minutes' cntShort30 integer grpCategory SUM Expression row["cnt"] dataSetRow["type"] == '30 minutes' cntLong integer grpCategory SUM Expression row["cnt"] dataSetRow["type"] == 'one hour' cntShort10Super integer grpSuper SUM Expression row["cnt"] dataSetRow["type"] == '10 minutes' cntShort30Super integer grpSuper SUM Expression row["cnt"] dataSetRow["type"] == '30 minutes' cntLongSuper integer grpSuper SUM Expression row["cnt"] dataSetRow["type"] == 'one hour' cntTutorialSuper integer grpSuper SUM Expression row["cnt"] dataSetRow["type"] == '4 hours' cntShort10All integer SUM Expression row["cnt"] dataSetRow["type"] == '10 minutes' cntShort30All integer SUM Expression row["cnt"] dataSetRow["type"] == '30 minutes' cntLongAll integer SUM Expression row["cnt"] dataSetRow["type"] == 'one hour' cntTutorialAll integer SUM Expression row["cnt"] dataSetRow["type"] == '4 hours' cntAll integer SUM Expression row["cnt"] percentSuper Math.round(row["cntSuper"]/row["cntAll"] * 100) + "%" string percentCategory Math.round(row["cntCategory"]/row["cntAll"] * 100) + "%" string type type dataSetRow["type"] string cnt cnt dataSetRow["cnt"] decimal super_cat super_cat dataSetRow["super_cat"] string cat cat dataSetRow["cat"] string alloc_short alloc_short dataSetRow["alloc_short"] integer alloc_long alloc_long dataSetRow["alloc_long"] decimal alloc_tutorial alloc_tutorial dataSetRow["alloc_tutorial"] integer allocShortHours allocShortHours dataSetRow["alloc_short"] * .2 integer longHours row["cntLong"] integer tutorHours row["cntTutorial"] * 4 integer allocTutorHour row["alloc_tutorial"] * 4 integer allocAll row["allocShortHours"] + dataSetRow["alloc_long"] + row["alloc_tutorial"] * 4 integer reqShortHour row["cntShort10"] * .2 + row["cntShort30"] * .5 float allRequestHour row["reqShortHour"] + row["cntLong"] + row["cntTutorial"] * 4 float percentOver row["allRequestHour"] / row["allocAll"] float cntAllHours row["cntLongAll"] + row["cntShort10All"] * .2 + row["cntShort30All"] * .5 + row["cntTutorialAll"] * 4 float 0.5in true false 2in 1 0.5in 1 0.5in 1 0.5in 1 0.5in 1 0.5in 0.5in center
#E1E1E1 bold bottom 1 1 center center center center #366092 bold bottom 2 1 center center 2 none normal inherit block auto auto auto false cntShort10All center center 2 none normal inherit block auto auto auto false cntShort30All center center 2 none normal inherit block auto auto auto false cntLongAll center center 2 none normal inherit block auto auto auto false cntTutorialAll center 2 none normal inherit block auto auto auto false cntAll
grpSuper none asc row["super_cat"] row["super_cat"] true false auto auto auto
#95B3D7 #000000 2 1 super_cat center 2 none normal inherit block auto auto auto false cntShort10Super center 2 none normal inherit block auto auto auto false cntShort30Super center 2 none normal inherit block auto auto auto false cntLongSuper center 2 none normal inherit block auto auto auto false cntTutorialSuper center 2 none normal inherit block auto auto auto false cntSuper Unformatted percentSuper
grpCategory none asc row["cat"] row["cat"] true false auto auto auto
#FFFFFF eq #F59B9B row["cntCategory"] 0 left cat Custom 0 center 2 none normal inherit block auto auto auto false cntShort10 Custom 0 center 2 none normal inherit block auto auto auto false cntShort30 Custom 0 center 2 none normal inherit block auto auto auto false cntLong 0pt Custom 0 center 2 none normal inherit block auto auto auto false cntTutorial center 2 none normal inherit block auto auto auto false cntCategory Unformatted percentCategory #FFFFFF middle right eq #F59B9B row["cntCategory"] 0 2 1 center 2 none normal 2 smaller inline true allocShortHours smaller none inline true reqShortHour center smaller inline alloc_long smaller Currency ###0;(###0) inline longHours center smaller inline allocTutorHour smaller Currency ###0;(###0) inline tutorHours center smaller inline allocAll smaller inline allRequestHour 1 1 smaller Percent ###0% inline percentOver
always 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