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 cat string 2 super_cat string 3 type string 4 cnt decimal 5 alloc_short integer 6 alloc_long integer 7 alloc_main integer 8 alloc_tutor integer 9 accepted decimal 10 neutral decimal 11 declined decimal 12 aardvark decimal 13 mainstage decimal srcEclipseCon paramConferenceId paramConferenceId integer 1 true false 1 cat cat string 2 super_cat super_cat string 3 type type string 4 cnt cnt decimal 5 alloc_short alloc_short integer 6 alloc_long alloc_long integer 7 alloc_main alloc_main integer 8 alloc_tutor alloc_tutor integer 9 accepted accepted decimal 10 neutral neutral decimal 11 declined declined decimal 12 aardvark aardvark decimal 13 mainstage mainstage decimal SELECT distinct SubString(c.category, INSTR(c.category, '-') + 2) cat , SubString(c.category, 1, INSTR(c.category, '-') - 2) super_cat , SubString(_type, INSTR(_type, '-') + 2) type , count(s.submission_id) cnt , a.short alloc_short , a.long alloc_long , a.mainstage alloc_main , a.tutorial alloc_tutor , (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 , (select count(*) from submissions ss inner join submission_tags st on st.submission_id = ss.submission_id inner join tags t on t.tag_id = st.tag_id where t.tag like 'aardvark' and ss._type = s._type and ss._category = s._category) aardvark , (select count(*) from submissions ss inner join submission_tags st on st.submission_id = ss.submission_id inner join tags t on t.tag_id = st.tag_id where t.tag like 'mainstage' and ss._type = s._type and ss._category = s._category) mainstage 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 <> 9 group by super_cat, cat, SubString(_type, INSTR(_type, '-') + 2) order by super_cat desc, cat desc, type 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 alloc_short decimal 2 alloc_long decimal 3 main_stage decimal 4 alloc_tutor decimal srcEclipseCon paramConferenceId paramConferenceId integer 1 true false 1 alloc_short alloc_short decimal 2 alloc_long alloc_long decimal 3 main_stage main_stage decimal 4 alloc_tutor alloc_tutor decimal SELECT distinct sum(a.short) alloc_short , sum(a.long) + a.mainstage alloc_long , sum(a.mainstage) main_stage , sum(a.tutorial) alloc_tutor FROM allocation a where a.conference_id = ? 0.5in 0.5in 0.5in 0.5in false false 0in 0in html new Date()]]> medium1.3416666666666666insetSubmissionByType cat dataSetRow["cat"] string super_cat dataSetRow["super_cat"] string type dataSetRow["type"] string cnt dataSetRow["cnt"] decimal alloc_short row["alloc_10"] * .2 integer alloc_long dataSetRow["alloc_long"] decimal alloc_tutor alloc_tutor dataSetRow["alloc_tutor"] integer accepted dataSetRow["accepted"] decimal neutral dataSetRow["neutral"] decimal declined dataSetRow["declined"] decimal aardvark dataSetRow["aardvark"] decimal alloc_30 0 integer alloc_10 dataSetRow["alloc_short"] integer submit_10 integer grpCategory SUM Expression row["cnt"] dataSetRow["type"] == "10 minutes" submit_30 integer grpCategory SUM Expression row["cnt"] dataSetRow["type"] == "30 minutes" submit_short row["submit_10"] * .2 + row["submit_30"] * .5 float submit_Long integer grpCategory SUM Expression row["cnt"] dataSetRow["type"] == "one hour" submit_tutor integer grpCategory SUM Expression row["cnt"] dataSetRow["type"] == "4 hours" accept_10 integer grpCategory SUM Expression row["accepted"] dataSetRow["type"] == "10 minutes" accept_30 integer grpCategory SUM Expression row["accepted"] dataSetRow["type"] == "30 minutes" accept_short row["accept_10"] * .2 + row["accept_30"] * .5 float accept_long integer grpCategory SUM Expression row["accepted"] dataSetRow["type"] == "one hour" accept_tutor integer grpCategory SUM Expression row["accepted"] dataSetRow["type"] == "4 hours" decline_tutor integer grpCategory SUM Expression row["declined"] dataSetRow["type"] == "4 hours" decline_long integer grpCategory SUM Expression row["declined"] dataSetRow["type"] == "one hour" decline_30 integer grpCategory SUM Expression row["declined"] dataSetRow["type"] == "30 minutes" decline_10 integer grpCategory SUM Expression row["declined"] dataSetRow["type"] == "10 minutes" decline_short row["decline_10"] * .2 + row["decline_30"] * .5 float neutral_10 integer grpCategory SUM Expression row["neutral"] dataSetRow["type"] == "10 minutes" neutral_30 integer grpCategory SUM Expression row["neutral"] dataSetRow["type"] == "30 minutes" neutral_short row["neutral_10"] * .2 + row["neutral_30"] * .5 float neutral_long integer grpCategory SUM Expression row["neutral"] dataSetRow["type"] == "one hour" neutral_tutor integer grpCategory SUM Expression row["neutral"] dataSetRow["type"] == "4 hours" aardvark_10 integer grpCategory SUM Expression row["aardvark"] dataSetRow["type"] == "10 minutes" aardvark_30 integer grpCategory SUM Expression row["aardvark"] dataSetRow["type"] == "30 minutes" aardvark_short row["aardvark_10"] * .2 + row["aardvark_30"] * .5 float aardvark_long integer grpCategory SUM Expression row["aardvark"] dataSetRow["type"] == "one hour" aardvark_tutor integer grpCategory SUM Expression row["aardvark"] dataSetRow["type"] == "4 hours" alloc_10_all integer SUM Expression row["alloc_short"] alloc_long_all integer SUM Expression row["alloc_long"] alloc_tutor_all integer SUM Expression row["alloc_tutor"] accept_10_all integer SUM Expression row["accepted"] dataSetRow["type"] == "10 minutes" accept_30_all integer SUM Expression row["accepted"] dataSetRow["type"] == "30 minutes" accept_short_all row["accept_10_all"] * .2 + row["accept_30_all"] * .5 float accept_long_all integer SUM Expression row["accepted"] dataSetRow["type"] == "one hour" accept_tutor_all integer SUM Expression row["accepted"] dataSetRow["type"] == "4 hours" alloc_short_all row["alloc_10_all"] * .2 integer alloc_main alloc_main dataSetRow["alloc_main"] integer 0.5in true false 1.5in 1 0.5in 1 0.5in 1 0.5in 1 0.5in 1 0.5in 1 0.5in 1 0.5in 1

#E1E1E1 bold bottom 1 1 #000000 0pt left Domain #000000 0pt left Category center center #000000 center 10 center #000000 center 30 center #000000 center Short (hours) center #000000 center Long center #000000 center MainStage center #000000 center Tutor #366092 bold bottom 2 1 #FFFFFF left All Categories center center setSubmissionByTypeAll alloc_short dataSetRow["alloc_short"] decimal alloc_long dataSetRow["alloc_long"] decimal main_stage dataSetRow["main_stage"] decimal alloc_tutor dataSetRow["alloc_tutor"] decimal alloc_short_all dataSetRow["alloc_short"] integer alloc_short_all center center setSubmissionByTypeAll alloc_short dataSetRow["alloc_short"] decimal alloc_long dataSetRow["alloc_long"] decimal main_stage dataSetRow["main_stage"] decimal alloc_tutor dataSetRow["alloc_tutor"] decimal alloc_short_all dataSetRow["alloc_short"] *.2 integer alloc_short_all center setSubmissionByTypeAll alloc_short dataSetRow["alloc_short"] decimal alloc_long dataSetRow["alloc_long"] decimal main_stage dataSetRow["main_stage"] decimal alloc_tutor dataSetRow["alloc_tutor"] decimal alloc_long_all dataSetRow["alloc_long"] integer alloc_long_all center setSubmissionByTypeAll alloc_short dataSetRow["alloc_short"] decimal alloc_long dataSetRow["alloc_long"] decimal main_stage dataSetRow["main_stage"] decimal alloc_tutor dataSetRow["alloc_tutor"] decimal alloc_main_all dataSetRow["main_stage"] integer alloc_main_all center setSubmissionByTypeAll alloc_short dataSetRow["alloc_short"] decimal alloc_long dataSetRow["alloc_long"] decimal main_stage dataSetRow["main_stage"] decimal alloc_tutor dataSetRow["alloc_tutor"] decimal alloc_tutor_all dataSetRow["alloc_tutor"] integer alloc_tutor_all #366092 bold bottom center center center center center center center

grpSuper none asc row["super_cat"] row["super_cat"] true false auto auto auto

0.19166666666666668in #95B3D7 #000000 2 1 super_cat

grpCategory none asc row["cat"] row["cat"] true false auto auto auto

#FFFFFF is-true reportContext.getGlobalVariable("alt_grp") altRow eq #F59B9B row["cntCategory"] 0 left cat right block right 2 auto allocated center alloc_10 center alloc_30 center Fixed ###0.0 alloc_short center alloc_long center alloc_main center alloc_tutor #FFFFFF is-true reportContext.getGlobalVariable("alt_grp") altRow eq #F59B9B row["cntCategory"] 0 right block right 2 auto accepted center accept_10 center accept_30 center Fixed ###0.0 accept_short center accept_long center center accept_tutor #FFFFFF is-true reportContext.getGlobalVariable("alt_grp") altRow eq #F59B9B row["cntCategory"] 0 right block right 2 auto submitted center submit_10 center submit_30 center Fixed ###0.0 submit_short center submit_Long center center submit_tutor #FFFFFF is-true reportContext.getGlobalVariable("alt_grp") altRow eq #F59B9B row["cntCategory"] 0 right block right 2 auto rejected center decline_10 center decline_30 center Fixed ###0.0 decline_short center decline_long center center decline_tutor #FFFFFF is-true reportContext.getGlobalVariable("alt_grp") altRow eq #F59B9B row["cntCategory"] 0 right block right 2 auto neutral center neutral_10 center neutral_30 center Fixed ###0.0 neutral_short center neutral_long center center neutral_tutor #FFFFFF middle is-true reportContext.getGlobalVariable("alt_grp") altRow right eq #F59B9B row["cntCategory"] 0 right 2 none normal 2 block auto aardvark 1 1 center 2 none normal 2 aardvark_10 center aardvark_30 center Fixed ###0.0 aardvark_short center aardvark_long center center aardvark_tutor