Eclipse BIRT Designer Version 2.2.1.r22a_v20071101 Build <2.2.1.v20071101-1439> in Copyright (c) 2007 <<Your Company Name here>> Creates a blank report with no predefined content. Blank Report /templates/blank_report.gif com.mysql.jdbc.Driver jdbc:mysql://localhost:3306/ec2008 root cVRZRzMyNDE= dayofweek if (row["date"] == 17) 'Mon.'; else if (row["date"] == 18) 'Tues.'; else if (row["date"] == 19) 'Weds.'; else 'Thurs.'; any pk1 pk1 session_title session_title positive positive negative negative date date time time room room type type type_id type_id percent percent tracks tracks track_id track_id 1 pk1 integer 2 session_title string 3 positive integer 4 negative integer 5 date string 6 time string 7 room string 8 type string 9 type_id integer 10 percent decimal 11 tracks string 12 track_id integer 13 dayofweek any ec2008 1 pk1 pk1 integer 4 2 session_title session_title string 12 3 positive positive integer 4 4 negative negative integer 4 5 date date string 12 6 time time string 12 7 room room string 12 8 type type string 12 9 type_id type_id integer 4 10 percent percent decimal 3 11 tracks tracks string 12 12 track_id track_id integer 4 select distinct et.pk1 , et.title session_title , et.positive , et.negative , s.date , s.bTime time , s.room , t.name type , s.type_id , et.positive / (et.positive + et.negative) percent , ts.name tracks , s.track_id from eval_title et inner join eval_submissions e2s on e2s.eval_pk1 = et.pk1 inner join submissions s on s.id = e2s.submission_id inner join types t on t.id = s.type_id inner join tracks ts on ts.id = s.track_id order by percent DESC NewTabularHierarchy string tracks NewTabularHierarchy1 any dayofweek NewTabularHierarchy2 string type NewTabularHierarchy3 string time dataSetRow["negative"] integer dataSetRow["positive"] integer count decimal setTalks 0.5in 0.5in 0.5in 0.5in html new Date()]]> num_session center num_session grpTracks/tracks center num_session_grpTracks/tracks center num_session_1 grpType/type center num_session_grpType/type Grand Total grpTracks grpTracks/tracks tracks Grand Total grpDayOfWeek grpDayOfWeek/dayofweek dayofweek grpType grpType/type type 0pt dcAll tracks dimension["grpTracks"]["tracks"] string dayofweek dimension["grpDayOfWeek"]["dayofweek"] any num_session measure["num_session"] decimal num_session_grpDayOfWeek/dayofweek measure["num_session"] decimal grpDayOfWeek/dayofweek count num_session_grpTracks/tracks measure["num_session"] decimal grpTracks/tracks count num_session_1 measure["num_session"] decimal count type dimension["grpType"]["type"] string num_session_grpType/type measure["num_session"] decimal grpType/type count