Eclipse BIRT Designer Version 4.8.0.v201806261756 WEB-INF/classes/messages in /templates/blank_report.gif auto layout ltr styles.css false true /birt/webcontent/birt/styles/redesign_style.css static false integer true 276 simple text-box Unformatted static false integer true simple text-box Unformatted static false string true DE simple text-box Unformatted static false string true simple text-box Unformatted static false string true simple text-box Unformatted static false boolean true false simple check-box static false string true simple text-box Unformatted static string true simple text-box Unformatted static false boolean true True simple check-box static string true simple text-box Unformatted static string true simple text-box Unformatted 1 DATETIME date-time 2 OPENERS_UNIQUE integer 3 OPENINGS_GROSS integer 4 TARGETGROUP string 5 COLUMN_INDEX integer 6 DEVICECLASSID integer DATETIME OPENERS_UNIQUE OPENINGS_GROSS TARGETGROUP COLUMN_INDEX DEVICECLASSID 1 DATETIME date-time 2 OPENERS_UNIQUE integer 3 OPENINGS_GROSS integer 4 TARGETGROUP string 5 COLUMN_INDEX integer 6 DEVICECLASSID integer DummyDataSource 1 name string name 1 name string DummyDataSource 0 shortname string shortname 1 shortname string DummyDataSource 0.25in 0.25in 0.25in 0.25in 3.1354166666666665in 5.145833333333333in 2.1666666666666665in 2.9791666666666665in sans-serif bold tr("report.parameters") tr("settings.Company") CompanyDescriptionDataSet name name dataSetRow["name"] string name tr("Targets") 100%TargetDescriptionDataset shortname dataSetRow["shortname"] string Column Binding dataSetRow["shortname"] string block-table MailingOpenersTimeBasedDataSet DATETIME dataSetRow["DATETIME"] string OPENERS_UNIQUE dataSetRow["OPENERS_UNIQUE"] integer OPENINGS_GROSS dataSetRow["OPENINGS_GROSS"] integer all params["selectedTargets"] != null && params["selectedTargets"] != "" full-width left table report-title center left tr("OpeningsNet") center 2.6.1 Bar Chart Stacked 0.0 0.0 0.0 0.0 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false false ClicksNetto Arial 10.0 true Center Center 255 45 45 47 0 255 255 255 1 255 0 0 0 0.0 2.0 0.0 3.0 true 0.0 0.0 0.0 0.0 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false true 5 5 0 255 0 0 0 false 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 Horizontal 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false true Auto 0 255 0 0 0 false 2.0 2.0 2.0 85.0 Arial 10.0 255 45 45 47 Horizontal Left_Right 1 255 0 0 0 true Below Series Above 0.0 0.0 585.0 254.25 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false 0 255 255 255 true Two_Dimensional Points 10.0 enable.area.alt false 01/05/2000,02/01/2000,04/12/2000,03/12/2000,02/29/2000 10.0,8.0,24.0 0 Center Center 0 255 255 255 1 255 0 0 0 true 0.0 2.0 0.0 3.0 true DateTime Below Linear Left row["DEVICECLASSID"] Text 255 0 113 185 255 0 153 153 255 146 208 79 255 65 100 26 255 255 192 0 true Arial 10.0 true 0.0 255 0 0 0 0 255 255 255 1 255 0 0 0 false 0.0 0.0 0.0 0.0 true row["OPENERS_UNIQUE"] Text Sum ClicksBrutto=OpeningsNetto Orthogonal_Value , Outside true onclick URL_Redirect drill-through hours <structure> <property name="linkType">drill-through</property> <property name="reportName">mailing_openers_progress.rptdesign</property> <property name="targetBookmarkType">bookmark</property> <property name="targetWindow">_self</property> <property name="targetFileType">report-design</property> <list-property name="paramBindings"> <structure> <property name="paramName">companyID</property> <simple-property-list name="expression"> <value type="javascript">"" + params["companyID"]</value> </simple-property-list> </structure> <structure> <property name="paramName">mailingID</property> <simple-property-list name="expression"> <value type="javascript">"" + params["mailingID"]</value> </simple-property-list> </structure> <structure> <property name="paramName">language</property> <simple-property-list name="expression"> <value type="javascript">params["language"].value</value> </simple-property-list> </structure> <structure> <property name="paramName">startDate</property> <simple-property-list name="expression"> <value type="javascript">row["DATETIME"]</value> </simple-property-list> </structure> <structure> <property name="paramName">stopDate</property> <simple-property-list name="expression"> <value type="javascript">row["DATETIME"]</value> </simple-property-list> </structure> <structure> <property name="paramName">hourScale</property> <simple-property-list name="expression"> <value type="javascript">true</value> </simple-property-list> </structure> <structure> <property name="paramName">selectedTargets</property> <simple-property-list name="expression"> <value type="javascript">params["selectedTargets"].value</value> </simple-property-list> </structure> <structure> <property name="paramName">recipientType</property> <simple-property-list name="expression"> <value type="javascript">params["recipientType"]</value> </simple-property-list> </structure> <structure> <property name="paramName">viewChart</property> <simple-property-list name="expression"> <value type="javascript">params["viewChart"]</value> </simple-property-list> </structure> <structure> <property name="paramName">emmsession</property> <simple-property-list name="expression"> <value type="javascript">params["emmsession"].value</value> </simple-property-list> </structure> <structure> <property name="paramName">sec</property> <simple-property-list name="expression"> <value type="javascript">params["sec"].value</value> </simple-property-list> </structure> </list-property> </structure> Menu zIndex:99999;backgroundColor:#FAFFF8;width:auto;height:auto;border:1px solid #333333;filter:progid:DXImageTransform.Microsoft.Shadow(Color:#333333,Direction=120,strength=5) OnMouseOut backgroundColor:#FAFFF8;color:#000000 OnMouseOver backgroundColor:#245DDB;color:#FFFFFF MenuItem color:Black;fontSize:10pt;paddingLeft:10px;paddingRight:10px;paddingTop:2px;paddingBottom:2px Pointer Rectangle false 1.0 Text Sum Descending row["DEVICECLASSID"] Vertical 1 255 0 0 0 false Arial 10.0 255 45 45 47 0 255 255 255 1 255 0 0 0 0.0 2.0 0.0 3.0 true Left 1 255 196 196 196 true Across 1 255 154 154 154 true 1 255 225 225 225 false Across 1 255 225 225 225 false 0.0 5 true Min 0.0 true false 255 80 166 218 255 242 88 106 255 232 172 57 255 128 255 128 255 64 128 128 255 128 128 192 255 170 85 85 255 128 128 0 255 192 192 192 255 255 255 128 255 128 192 128 255 7 146 94 255 0 128 255 255 255 128 192 255 0 255 255 255 255 128 128 255 0 128 192 255 128 128 192 255 255 0 255 255 128 64 64 255 255 128 64 255 80 240 120 255 0 64 128 255 128 0 64 255 255 0 128 255 128 128 64 255 128 128 128 255 255 128 255 255 0 64 0 255 0 0 0 255 255 255 255 255 255 128 0 true 0 255 255 255 1 255 0 0 0 false 0.0 2.0 0.0 3.0 false row["DATETIME"] Orthogonal_Value , Outside false true 1.0 Text Sum Horizontal 1 255 154 154 154 true Arial 10.0 255 45 45 47 0 255 255 255 1 255 0 0 0 0.0 2.0 0.0 3.0 true HH Below 1 255 196 196 196 false Across 1 255 154 154 154 true 1 255 225 225 225 false Across 1 255 225 225 225 false 5 Min 0.0 true true false 0 255 255 255 255 192 192 192 Vertical 50.0 ]]> SVG _self drill-through report-design bookmark mailing_openers_progress.rptdesign companyID "" + params["companyID"] mailingID "" + params["mailingID"] language params["language"].value startDate row["DATETIME"] stopDate row["DATETIME"] hourScale true selectedTargets params["selectedTargets"].value recipientType params["recipientType"] viewChart params["viewChart"] emmsession params["emmsession"].value sec params["sec"].value false "Arial" #707173 320px 780px MailingOpenersTimeBasedDataSet DATETIME dataSetRow["DATETIME"] date-time OPENERS_UNIQUE dataSetRow["OPENERS_UNIQUE"] integer OPENINGS_GROSS dataSetRow["OPENINGS_GROSS"] integer TARGETGROUP dataSetRow["TARGETGROUP"] string DEVICECLASSID dataSetRow["DEVICECLASSID"] integer COLUMN_INDEX dataSetRow["COLUMN_INDEX"] integer true all params["selectedTargets"] == null || params["selectedTargets"] == "" full-width left table report-title center left tr("OpeningsNet") + " (" + tr("report.device.desktop") + ")" center 2.6.1 Bar Chart Side-by-side 0.0 0.0 0.0 0.0 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false false ClicksNetto Arial 10.0 true Center Center 0 255 255 255 1 255 0 0 0 0.0 2.0 0.0 3.0 true 0.0 0.0 0.0 0.0 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false true 5 5 0 255 0 0 0 false 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 Horizontal 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false true 0 255 0 0 0 false 2.0 2.0 2.0 2.0 Arial 10.0 255 45 45 47 Horizontal Left_Right 1 255 0 0 0 true Below Series Above 0.0 0.0 585.0 254.25 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false 0 255 255 255 true Two_Dimensional Points 10.0 enable.area.alt false 01/05/2000,02/01/2000,04/12/2000,03/12/2000,02/29/2000 10.0,8.0,24.0 0 Center Center 0 255 255 255 1 255 0 0 0 true 0.0 2.0 0.0 3.0 true DateTime Below Linear Left row["TARGETGROUP"] Text 255 0 113 185 255 0 155 255 255 99 194 255 255 0 85 138 255 146 208 79 255 105 161 41 255 65 100 26 255 0 153 153 255 0 100 100 255 124 0 168 255 169 26 26 255 223 56 56 255 245 118 14 255 255 192 0 255 255 255 0 true Arial 10.0 true 90.0 255 0 0 0 0 255 255 255 1 255 0 0 0 false 0.0 8.0 0.0 0.0 true row["OPENERS_UNIQUE"] Text Sum ClicksBrutto=OpeningsNetto Orthogonal_Value , Outside false onclick URL_Redirect drill-through hours <structure> <property name="linkType">drill-through</property> <property name="reportName">mailing_openers_progress.rptdesign</property> <property name="targetBookmarkType">bookmark</property> <property name="targetWindow">_self</property> <property name="targetFileType">report-design</property> <list-property name="paramBindings"> <structure> <property name="paramName">companyID</property> <simple-property-list name="expression"> <value type="javascript">"" + params["companyID"]</value> </simple-property-list> </structure> <structure> <property name="paramName">mailingID</property> <simple-property-list name="expression"> <value type="javascript">"" + params["mailingID"]</value> </simple-property-list> </structure> <structure> <property name="paramName">language</property> <simple-property-list name="expression"> <value type="javascript">params["language"].value</value> </simple-property-list> </structure> <structure> <property name="paramName">startDate</property> <simple-property-list name="expression"> <value type="javascript">row["DATETIME"]</value> </simple-property-list> </structure> <structure> <property name="paramName">stopDate</property> <simple-property-list name="expression"> <value type="javascript">row["DATETIME"]</value> </simple-property-list> </structure> <structure> <property name="paramName">hourScale</property> <simple-property-list name="expression"> <value type="javascript">true</value> </simple-property-list> </structure> <structure> <property name="paramName">selectedTargets</property> <simple-property-list name="expression"> <value type="javascript">params["selectedTargets"].value</value> </simple-property-list> </structure> <structure> <property name="paramName">recipientType</property> <simple-property-list name="expression"> <value type="javascript">params["recipientType"]</value> </simple-property-list> </structure> <structure> <property name="paramName">viewChart</property> <simple-property-list name="expression"> <value type="javascript">params["viewChart"]</value> </simple-property-list> </structure> <structure> <property name="paramName">emmsession</property> <simple-property-list name="expression"> <value type="javascript">params["emmsession"].value</value> </simple-property-list> </structure> <structure> <property name="paramName">sec</property> <simple-property-list name="expression"> <value type="javascript">params["sec"].value</value> </simple-property-list> </structure> </list-property> </structure> Menu zIndex:99999;backgroundColor:#FAFFF8;width:auto;height:auto;border:1px solid #333333;filter:progid:DXImageTransform.Microsoft.Shadow(Color:#333333,Direction=120,strength=5) OnMouseOut backgroundColor:#FAFFF8;color:#000000 OnMouseOver backgroundColor:#245DDB;color:#FFFFFF MenuItem color:Black;fontSize:10pt;paddingLeft:10px;paddingRight:10px;paddingTop:2px;paddingBottom:2px Pointer Rectangle false 1.0 Text Sum Ascending row["COLUMN_INDEX"] Vertical 1 255 0 0 0 false Arial 10.0 255 45 45 47 0 255 255 255 1 255 0 0 0 0.0 2.0 0.0 3.0 true Left 1 255 196 196 196 true Across 1 255 154 154 154 true 1 255 225 225 225 false Across 1 255 225 225 225 false 0.0 5 true Min 0.0 true false 255 80 166 218 255 242 88 106 255 232 172 57 255 128 255 128 255 64 128 128 255 128 128 192 255 170 85 85 255 128 128 0 255 192 192 192 255 255 255 128 255 128 192 128 255 7 146 94 255 0 128 255 255 255 128 192 255 0 255 255 255 255 128 128 255 0 128 192 255 128 128 192 255 255 0 255 255 128 64 64 255 255 128 64 255 80 240 120 255 0 64 128 255 128 0 64 255 255 0 128 255 128 128 64 255 128 128 128 255 255 128 255 255 0 64 0 255 0 0 0 255 255 255 255 255 255 128 0 true 0 255 255 255 1 255 0 0 0 false 0.0 2.0 0.0 3.0 false row["DATETIME"] Orthogonal_Value , Outside false true 1.0 Text Sum Horizontal 1 255 154 154 154 true Arial 10.0 255 45 45 47 0 255 255 255 1 255 0 0 0 0.0 2.0 0.0 3.0 true HH Below 1 255 196 196 196 false Across 1 255 154 154 154 true 1 255 225 225 225 false Across 1 255 225 225 225 false 5 Min 0.0 true true false 0 255 255 255 255 192 192 192 Vertical 50.0 ]]> SVG _self drill-through report-design bookmark mailing_openers_progress.rptdesign companyID "" + params["companyID"] mailingID "" + params["mailingID"] language params["language"].value startDate row["DATETIME"] stopDate row["DATETIME"] hourScale true selectedTargets params["selectedTargets"].value recipientType params["recipientType"] viewChart params["viewChart"] emmsession params["emmsession"].value sec params["sec"].value eq row["DEVICECLASSID"] 1 true false "Arial" #707173 320px 780px MailingOpenersTimeBasedDataSet DATETIME dataSetRow["DATETIME"] date-time OPENERS_UNIQUE dataSetRow["OPENERS_UNIQUE"] integer OPENINGS_GROSS dataSetRow["OPENINGS_GROSS"] integer TARGETGROUP dataSetRow["TARGETGROUP"] string DEVICECLASSID dataSetRow["DEVICECLASSID"] integer COLUMN_INDEX dataSetRow["COLUMN_INDEX"] integer false all params["selectedTargets"] == null || params["selectedTargets"] == "" full-width left table report-title center left tr("OpeningsNet") + " (" + tr("report.device.mobile") + ")" center 2.6.1 Bar Chart Side-by-side 0.0 0.0 0.0 0.0 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false false ClicksNetto Arial 10.0 true Center Center 0 255 255 255 1 255 0 0 0 0.0 2.0 0.0 3.0 true 0.0 0.0 0.0 0.0 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false true 5 5 0 255 0 0 0 false 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 Horizontal 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false true 0 255 0 0 0 false 2.0 2.0 2.0 2.0 Arial 10.0 255 45 45 47 Horizontal Left_Right 1 255 0 0 0 true Below Series Above 0.0 0.0 585.0 254.25 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false 0 255 255 255 true Two_Dimensional Points 10.0 enable.area.alt false 01/05/2000,02/01/2000,04/12/2000,03/12/2000,02/29/2000 10.0,8.0,24.0 0 Center Center 0 255 255 255 1 255 0 0 0 true 0.0 2.0 0.0 3.0 true DateTime Below Linear Left row["TARGETGROUP"] Text 255 0 113 185 255 0 155 255 255 99 194 255 255 0 85 138 255 146 208 79 255 105 161 41 255 65 100 26 255 0 153 153 255 0 100 100 255 124 0 168 255 169 26 26 255 223 56 56 255 245 118 14 255 255 192 0 255 255 255 0 true Arial 10.0 true 90.0 255 0 0 0 0 255 255 255 1 255 0 0 0 false 0.0 8.0 0.0 0.0 true row["OPENERS_UNIQUE"] Text Sum ClicksBrutto=OpeningsNetto Orthogonal_Value , Outside false onclick URL_Redirect drill-through hours <structure> <property name="linkType">drill-through</property> <property name="reportName">mailing_openers_progress.rptdesign</property> <property name="targetBookmarkType">bookmark</property> <property name="targetWindow">_self</property> <property name="targetFileType">report-design</property> <list-property name="paramBindings"> <structure> <property name="paramName">companyID</property> <simple-property-list name="expression"> <value type="javascript">"" + params["companyID"]</value> </simple-property-list> </structure> <structure> <property name="paramName">mailingID</property> <simple-property-list name="expression"> <value type="javascript">"" + params["mailingID"]</value> </simple-property-list> </structure> <structure> <property name="paramName">language</property> <simple-property-list name="expression"> <value type="javascript">params["language"].value</value> </simple-property-list> </structure> <structure> <property name="paramName">startDate</property> <simple-property-list name="expression"> <value type="javascript">row["DATETIME"]</value> </simple-property-list> </structure> <structure> <property name="paramName">stopDate</property> <simple-property-list name="expression"> <value type="javascript">row["DATETIME"]</value> </simple-property-list> </structure> <structure> <property name="paramName">hourScale</property> <simple-property-list name="expression"> <value type="javascript">true</value> </simple-property-list> </structure> <structure> <property name="paramName">selectedTargets</property> <simple-property-list name="expression"> <value type="javascript">params["selectedTargets"].value</value> </simple-property-list> </structure> <structure> <property name="paramName">recipientType</property> <simple-property-list name="expression"> <value type="javascript">params["recipientType"]</value> </simple-property-list> </structure> <structure> <property name="paramName">viewChart</property> <simple-property-list name="expression"> <value type="javascript">params["viewChart"]</value> </simple-property-list> </structure> <structure> <property name="paramName">emmsession</property> <simple-property-list name="expression"> <value type="javascript">params["emmsession"].value</value> </simple-property-list> </structure> <structure> <property name="paramName">sec</property> <simple-property-list name="expression"> <value type="javascript">params["sec"].value</value> </simple-property-list> </structure> </list-property> </structure> Menu zIndex:99999;backgroundColor:#FAFFF8;width:auto;height:auto;border:1px solid #333333;filter:progid:DXImageTransform.Microsoft.Shadow(Color:#333333,Direction=120,strength=5) OnMouseOut backgroundColor:#FAFFF8;color:#000000 OnMouseOver backgroundColor:#245DDB;color:#FFFFFF MenuItem color:Black;fontSize:10pt;paddingLeft:10px;paddingRight:10px;paddingTop:2px;paddingBottom:2px Pointer Rectangle false 1.0 Text Sum Ascending row["COLUMN_INDEX"] Vertical 1 255 0 0 0 false Arial 10.0 255 45 45 47 0 255 255 255 1 255 0 0 0 0.0 2.0 0.0 3.0 true Left 1 255 196 196 196 true Across 1 255 154 154 154 true 1 255 225 225 225 false Across 1 255 225 225 225 false 0.0 5 true Min 0.0 true false 255 80 166 218 255 242 88 106 255 232 172 57 255 128 255 128 255 64 128 128 255 128 128 192 255 170 85 85 255 128 128 0 255 192 192 192 255 255 255 128 255 128 192 128 255 7 146 94 255 0 128 255 255 255 128 192 255 0 255 255 255 255 128 128 255 0 128 192 255 128 128 192 255 255 0 255 255 128 64 64 255 255 128 64 255 80 240 120 255 0 64 128 255 128 0 64 255 255 0 128 255 128 128 64 255 128 128 128 255 255 128 255 255 0 64 0 255 0 0 0 255 255 255 255 255 255 128 0 true 0 255 255 255 1 255 0 0 0 false 0.0 2.0 0.0 3.0 false row["DATETIME"] Orthogonal_Value , Outside false true 1.0 Text Sum Horizontal 1 255 154 154 154 true Arial 10.0 255 45 45 47 0 255 255 255 1 255 0 0 0 0.0 2.0 0.0 3.0 true HH Below 1 255 196 196 196 false Across 1 255 154 154 154 true 1 255 225 225 225 false Across 1 255 225 225 225 false 5 Min 0.0 true true false 0 255 255 255 255 192 192 192 Vertical 50.0 ]]> SVG _self drill-through report-design bookmark mailing_openers_progress.rptdesign companyID "" + params["companyID"] mailingID "" + params["mailingID"] language params["language"].value startDate row["DATETIME"] stopDate row["DATETIME"] hourScale true selectedTargets params["selectedTargets"].value recipientType params["recipientType"] viewChart params["viewChart"] emmsession params["emmsession"].value sec params["sec"].value eq row["DEVICECLASSID"] 2 true false "Arial" #707173 320px 780px MailingOpenersTimeBasedDataSet DATETIME dataSetRow["DATETIME"] date-time OPENERS_UNIQUE dataSetRow["OPENERS_UNIQUE"] integer OPENINGS_GROSS dataSetRow["OPENINGS_GROSS"] integer TARGETGROUP dataSetRow["TARGETGROUP"] string DEVICECLASSID dataSetRow["DEVICECLASSID"] integer COLUMN_INDEX dataSetRow["COLUMN_INDEX"] integer false all params["selectedTargets"] == null || params["selectedTargets"] == "" full-width left table report-title center left tr("OpeningsNet") + " (" + tr("report.device.tablet") + ")" center 2.6.1 Bar Chart Side-by-side 0.0 0.0 0.0 0.0 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false false ClicksNetto Arial 10.0 true Center Center 0 255 255 255 1 255 0 0 0 0.0 2.0 0.0 3.0 true 0.0 0.0 0.0 0.0 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false true 5 5 0 255 0 0 0 false 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 Horizontal 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false true 0 255 0 0 0 false 2.0 2.0 2.0 2.0 Arial 10.0 255 45 45 47 Horizontal Left_Right 1 255 0 0 0 true Below Series Above 0.0 0.0 585.0 254.25 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false 0 255 255 255 true Two_Dimensional Points 10.0 enable.area.alt false 01/05/2000,02/01/2000,04/12/2000,03/12/2000,02/29/2000 10.0,8.0,24.0 0 Center Center 0 255 255 255 1 255 0 0 0 true 0.0 2.0 0.0 3.0 true DateTime Below Linear Left row["TARGETGROUP"] Text 255 0 113 185 255 0 155 255 255 99 194 255 255 0 85 138 255 146 208 79 255 105 161 41 255 65 100 26 255 0 153 153 255 0 100 100 255 124 0 168 255 169 26 26 255 223 56 56 255 245 118 14 255 255 192 0 255 255 255 0 true Arial 10.0 true 90.0 255 0 0 0 0 255 255 255 1 255 0 0 0 false 0.0 8.0 0.0 0.0 true row["OPENERS_UNIQUE"] Text Sum ClicksBrutto=OpeningsNetto Orthogonal_Value , Outside false onclick URL_Redirect drill-through hours <structure> <property name="linkType">drill-through</property> <property name="reportName">mailing_openers_progress.rptdesign</property> <property name="targetBookmarkType">bookmark</property> <property name="targetWindow">_self</property> <property name="targetFileType">report-design</property> <list-property name="paramBindings"> <structure> <property name="paramName">companyID</property> <simple-property-list name="expression"> <value type="javascript">"" + params["companyID"]</value> </simple-property-list> </structure> <structure> <property name="paramName">mailingID</property> <simple-property-list name="expression"> <value type="javascript">"" + params["mailingID"]</value> </simple-property-list> </structure> <structure> <property name="paramName">language</property> <simple-property-list name="expression"> <value type="javascript">params["language"].value</value> </simple-property-list> </structure> <structure> <property name="paramName">startDate</property> <simple-property-list name="expression"> <value type="javascript">row["DATETIME"]</value> </simple-property-list> </structure> <structure> <property name="paramName">stopDate</property> <simple-property-list name="expression"> <value type="javascript">row["DATETIME"]</value> </simple-property-list> </structure> <structure> <property name="paramName">hourScale</property> <simple-property-list name="expression"> <value type="javascript">true</value> </simple-property-list> </structure> <structure> <property name="paramName">selectedTargets</property> <simple-property-list name="expression"> <value type="javascript">params["selectedTargets"].value</value> </simple-property-list> </structure> <structure> <property name="paramName">recipientType</property> <simple-property-list name="expression"> <value type="javascript">params["recipientType"]</value> </simple-property-list> </structure> <structure> <property name="paramName">viewChart</property> <simple-property-list name="expression"> <value type="javascript">params["viewChart"]</value> </simple-property-list> </structure> <structure> <property name="paramName">emmsession</property> <simple-property-list name="expression"> <value type="javascript">params["emmsession"].value</value> </simple-property-list> </structure> <structure> <property name="paramName">sec</property> <simple-property-list name="expression"> <value type="javascript">params["sec"].value</value> </simple-property-list> </structure> </list-property> </structure> Menu zIndex:99999;backgroundColor:#FAFFF8;width:auto;height:auto;border:1px solid #333333;filter:progid:DXImageTransform.Microsoft.Shadow(Color:#333333,Direction=120,strength=5) OnMouseOut backgroundColor:#FAFFF8;color:#000000 OnMouseOver backgroundColor:#245DDB;color:#FFFFFF MenuItem color:Black;fontSize:10pt;paddingLeft:10px;paddingRight:10px;paddingTop:2px;paddingBottom:2px Pointer Rectangle false 1.0 Text Sum Ascending row["COLUMN_INDEX"] Vertical 1 255 0 0 0 false Arial 10.0 255 45 45 47 0 255 255 255 1 255 0 0 0 0.0 2.0 0.0 3.0 true Left 1 255 196 196 196 true Across 1 255 154 154 154 true 1 255 225 225 225 false Across 1 255 225 225 225 false 0.0 5 true Min 0.0 true false 255 80 166 218 255 242 88 106 255 232 172 57 255 128 255 128 255 64 128 128 255 128 128 192 255 170 85 85 255 128 128 0 255 192 192 192 255 255 255 128 255 128 192 128 255 7 146 94 255 0 128 255 255 255 128 192 255 0 255 255 255 255 128 128 255 0 128 192 255 128 128 192 255 255 0 255 255 128 64 64 255 255 128 64 255 80 240 120 255 0 64 128 255 128 0 64 255 255 0 128 255 128 128 64 255 128 128 128 255 255 128 255 255 0 64 0 255 0 0 0 255 255 255 255 255 255 128 0 true 0 255 255 255 1 255 0 0 0 false 0.0 2.0 0.0 3.0 false row["DATETIME"] Orthogonal_Value , Outside false true 1.0 Text Sum Horizontal 1 255 154 154 154 true Arial 10.0 255 45 45 47 0 255 255 255 1 255 0 0 0 0.0 2.0 0.0 3.0 true HH Below 1 255 196 196 196 false Across 1 255 154 154 154 true 1 255 225 225 225 false Across 1 255 225 225 225 false 5 Min 0.0 true true false 0 255 255 255 255 192 192 192 Vertical 50.0 ]]> SVG _self drill-through report-design bookmark mailing_openers_progress.rptdesign companyID "" + params["companyID"] mailingID "" + params["mailingID"] language params["language"].value startDate row["DATETIME"] stopDate row["DATETIME"] hourScale true selectedTargets params["selectedTargets"].value recipientType params["recipientType"] viewChart params["viewChart"] emmsession params["emmsession"].value sec params["sec"].value eq row["DEVICECLASSID"] 3 true false "Arial" #707173 320px 780px MailingOpenersTimeBasedDataSet DATETIME dataSetRow["DATETIME"] date-time OPENERS_UNIQUE dataSetRow["OPENERS_UNIQUE"] integer OPENINGS_GROSS dataSetRow["OPENINGS_GROSS"] integer TARGETGROUP dataSetRow["TARGETGROUP"] string DEVICECLASSID dataSetRow["DEVICECLASSID"] integer COLUMN_INDEX dataSetRow["COLUMN_INDEX"] integer false all params["selectedTargets"] == null || params["selectedTargets"] == "" full-width left table report-title center left tr("OpeningsNet") + " (" + tr("report.device.smarttv") + ")" center 2.6.1 Bar Chart Side-by-side 0.0 0.0 0.0 0.0 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false false ClicksNetto Arial 10.0 true Center Center 0 255 255 255 1 255 0 0 0 0.0 2.0 0.0 3.0 true 0.0 0.0 0.0 0.0 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false true 5 5 0 255 0 0 0 false 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 Horizontal 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false true 0 255 0 0 0 false 2.0 2.0 2.0 2.0 Arial 10.0 255 45 45 47 Horizontal Left_Right 1 255 0 0 0 true Below Series Above 0.0 0.0 585.0 254.25 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false 0 255 255 255 true Two_Dimensional Points 10.0 enable.area.alt false 01/05/2000,02/01/2000,04/12/2000,03/12/2000,02/29/2000 10.0,8.0,24.0 0 Center Center 0 255 255 255 1 255 0 0 0 true 0.0 2.0 0.0 3.0 true DateTime Below Linear Left row["TARGETGROUP"] Text 255 0 113 185 255 0 155 255 255 99 194 255 255 0 85 138 255 146 208 79 255 105 161 41 255 65 100 26 255 0 153 153 255 0 100 100 255 124 0 168 255 169 26 26 255 223 56 56 255 245 118 14 255 255 192 0 255 255 255 0 true Arial 10.0 true 90.0 255 0 0 0 0 255 255 255 1 255 0 0 0 false 0.0 8.0 0.0 0.0 true row["OPENERS_UNIQUE"] Text Sum ClicksBrutto=OpeningsNetto Orthogonal_Value , Outside false onclick URL_Redirect drill-through hours <structure> <property name="linkType">drill-through</property> <property name="reportName">mailing_openers_progress.rptdesign</property> <property name="targetBookmarkType">bookmark</property> <property name="targetWindow">_self</property> <property name="targetFileType">report-design</property> <list-property name="paramBindings"> <structure> <property name="paramName">companyID</property> <simple-property-list name="expression"> <value type="javascript">"" + params["companyID"]</value> </simple-property-list> </structure> <structure> <property name="paramName">mailingID</property> <simple-property-list name="expression"> <value type="javascript">"" + params["mailingID"]</value> </simple-property-list> </structure> <structure> <property name="paramName">language</property> <simple-property-list name="expression"> <value type="javascript">params["language"].value</value> </simple-property-list> </structure> <structure> <property name="paramName">startDate</property> <simple-property-list name="expression"> <value type="javascript">row["DATETIME"]</value> </simple-property-list> </structure> <structure> <property name="paramName">stopDate</property> <simple-property-list name="expression"> <value type="javascript">row["DATETIME"]</value> </simple-property-list> </structure> <structure> <property name="paramName">hourScale</property> <simple-property-list name="expression"> <value type="javascript">true</value> </simple-property-list> </structure> <structure> <property name="paramName">selectedTargets</property> <simple-property-list name="expression"> <value type="javascript">params["selectedTargets"].value</value> </simple-property-list> </structure> <structure> <property name="paramName">recipientType</property> <simple-property-list name="expression"> <value type="javascript">params["recipientType"]</value> </simple-property-list> </structure> <structure> <property name="paramName">viewChart</property> <simple-property-list name="expression"> <value type="javascript">params["viewChart"]</value> </simple-property-list> </structure> <structure> <property name="paramName">emmsession</property> <simple-property-list name="expression"> <value type="javascript">params["emmsession"].value</value> </simple-property-list> </structure> <structure> <property name="paramName">sec</property> <simple-property-list name="expression"> <value type="javascript">params["sec"].value</value> </simple-property-list> </structure> </list-property> </structure> Menu zIndex:99999;backgroundColor:#FAFFF8;width:auto;height:auto;border:1px solid #333333;filter:progid:DXImageTransform.Microsoft.Shadow(Color:#333333,Direction=120,strength=5) OnMouseOut backgroundColor:#FAFFF8;color:#000000 OnMouseOver backgroundColor:#245DDB;color:#FFFFFF MenuItem color:Black;fontSize:10pt;paddingLeft:10px;paddingRight:10px;paddingTop:2px;paddingBottom:2px Pointer Rectangle false 1.0 Text Sum Ascending row["COLUMN_INDEX"] Vertical 1 255 0 0 0 false Arial 10.0 255 45 45 47 0 255 255 255 1 255 0 0 0 0.0 2.0 0.0 3.0 true Left 1 255 196 196 196 true Across 1 255 154 154 154 true 1 255 225 225 225 false Across 1 255 225 225 225 false 0.0 5 true Min 0.0 true false 255 80 166 218 255 242 88 106 255 232 172 57 255 128 255 128 255 64 128 128 255 128 128 192 255 170 85 85 255 128 128 0 255 192 192 192 255 255 255 128 255 128 192 128 255 7 146 94 255 0 128 255 255 255 128 192 255 0 255 255 255 255 128 128 255 0 128 192 255 128 128 192 255 255 0 255 255 128 64 64 255 255 128 64 255 80 240 120 255 0 64 128 255 128 0 64 255 255 0 128 255 128 128 64 255 128 128 128 255 255 128 255 255 0 64 0 255 0 0 0 255 255 255 255 255 255 128 0 true 0 255 255 255 1 255 0 0 0 false 0.0 2.0 0.0 3.0 false row["DATETIME"] Orthogonal_Value , Outside false true 1.0 Text Sum Horizontal 1 255 154 154 154 true Arial 10.0 255 45 45 47 0 255 255 255 1 255 0 0 0 0.0 2.0 0.0 3.0 true HH Below 1 255 196 196 196 false Across 1 255 154 154 154 true 1 255 225 225 225 false Across 1 255 225 225 225 false 5 Min 0.0 true true false 0 255 255 255 255 192 192 192 Vertical 50.0 ]]> SVG _self drill-through report-design bookmark mailing_openers_progress.rptdesign companyID "" + params["companyID"] mailingID "" + params["mailingID"] language params["language"].value startDate row["DATETIME"] stopDate row["DATETIME"] hourScale true selectedTargets params["selectedTargets"].value recipientType params["recipientType"] viewChart params["viewChart"] emmsession params["emmsession"].value sec params["sec"].value eq row["DEVICECLASSID"] 4 true false "Arial" #707173 320px 780px MailingOpenersTimeBasedDataSet DATETIME dataSetRow["DATETIME"] date-time OPENERS_UNIQUE dataSetRow["OPENERS_UNIQUE"] integer OPENINGS_GROSS dataSetRow["OPENINGS_GROSS"] integer TARGETGROUP dataSetRow["TARGETGROUP"] string DEVICECLASSID dataSetRow["DEVICECLASSID"] integer COLUMN_INDEX dataSetRow["COLUMN_INDEX"] integer false all params["selectedTargets"] == null || params["selectedTargets"] == "" full-width left table report-title center left tr("OpeningsNet") + " (" + tr("report.device.mixed") + ")" center 2.6.1 Bar Chart Side-by-side 0.0 0.0 0.0 0.0 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false false ClicksNetto Arial 10.0 true Center Center 0 255 255 255 1 255 0 0 0 0.0 2.0 0.0 3.0 true 0.0 0.0 0.0 0.0 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false true 5 5 0 255 0 0 0 false 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 Horizontal 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false true 0 255 0 0 0 false 2.0 2.0 2.0 2.0 Arial 10.0 255 45 45 47 Horizontal Left_Right 1 255 0 0 0 true Below Series Above 0.0 0.0 585.0 254.25 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false 0 255 255 255 true Two_Dimensional Points 10.0 enable.area.alt false 01/05/2000,02/01/2000,04/12/2000,03/12/2000,02/29/2000 10.0,8.0,24.0 0 Center Center 0 255 255 255 1 255 0 0 0 true 0.0 2.0 0.0 3.0 true DateTime Below Linear Left row["TARGETGROUP"] Text 255 0 113 185 255 0 155 255 255 99 194 255 255 0 85 138 255 146 208 79 255 105 161 41 255 65 100 26 255 0 153 153 255 0 100 100 255 124 0 168 255 169 26 26 255 223 56 56 255 245 118 14 255 255 192 0 255 255 255 0 true Arial 10.0 true 90.0 255 0 0 0 0 255 255 255 1 255 0 0 0 false 0.0 8.0 0.0 0.0 true row["OPENERS_UNIQUE"] Text Sum ClicksBrutto=OpeningsNetto Orthogonal_Value , Outside false onclick URL_Redirect drill-through hours <structure> <property name="linkType">drill-through</property> <property name="reportName">mailing_openers_progress.rptdesign</property> <property name="targetBookmarkType">bookmark</property> <property name="targetWindow">_self</property> <property name="targetFileType">report-design</property> <list-property name="paramBindings"> <structure> <property name="paramName">companyID</property> <simple-property-list name="expression"> <value type="javascript">"" + params["companyID"]</value> </simple-property-list> </structure> <structure> <property name="paramName">mailingID</property> <simple-property-list name="expression"> <value type="javascript">"" + params["mailingID"]</value> </simple-property-list> </structure> <structure> <property name="paramName">language</property> <simple-property-list name="expression"> <value type="javascript">params["language"].value</value> </simple-property-list> </structure> <structure> <property name="paramName">startDate</property> <simple-property-list name="expression"> <value type="javascript">row["DATETIME"]</value> </simple-property-list> </structure> <structure> <property name="paramName">stopDate</property> <simple-property-list name="expression"> <value type="javascript">row["DATETIME"]</value> </simple-property-list> </structure> <structure> <property name="paramName">hourScale</property> <simple-property-list name="expression"> <value type="javascript">true</value> </simple-property-list> </structure> <structure> <property name="paramName">selectedTargets</property> <simple-property-list name="expression"> <value type="javascript">params["selectedTargets"].value</value> </simple-property-list> </structure> <structure> <property name="paramName">recipientType</property> <simple-property-list name="expression"> <value type="javascript">params["recipientType"]</value> </simple-property-list> </structure> <structure> <property name="paramName">viewChart</property> <simple-property-list name="expression"> <value type="javascript">params["viewChart"]</value> </simple-property-list> </structure> <structure> <property name="paramName">emmsession</property> <simple-property-list name="expression"> <value type="javascript">params["emmsession"].value</value> </simple-property-list> </structure> <structure> <property name="paramName">sec</property> <simple-property-list name="expression"> <value type="javascript">params["sec"].value</value> </simple-property-list> </structure> </list-property> </structure> Menu zIndex:99999;backgroundColor:#FAFFF8;width:auto;height:auto;border:1px solid #333333;filter:progid:DXImageTransform.Microsoft.Shadow(Color:#333333,Direction=120,strength=5) OnMouseOut backgroundColor:#FAFFF8;color:#000000 OnMouseOver backgroundColor:#245DDB;color:#FFFFFF MenuItem color:Black;fontSize:10pt;paddingLeft:10px;paddingRight:10px;paddingTop:2px;paddingBottom:2px Pointer Rectangle false 1.0 Text Sum Ascending row["COLUMN_INDEX"] Vertical 1 255 0 0 0 false Arial 10.0 255 45 45 47 0 255 255 255 1 255 0 0 0 0.0 2.0 0.0 3.0 true Left 1 255 196 196 196 true Across 1 255 154 154 154 true 1 255 225 225 225 false Across 1 255 225 225 225 false 0.0 5 true Min 0.0 true false 255 80 166 218 255 242 88 106 255 232 172 57 255 128 255 128 255 64 128 128 255 128 128 192 255 170 85 85 255 128 128 0 255 192 192 192 255 255 255 128 255 128 192 128 255 7 146 94 255 0 128 255 255 255 128 192 255 0 255 255 255 255 128 128 255 0 128 192 255 128 128 192 255 255 0 255 255 128 64 64 255 255 128 64 255 80 240 120 255 0 64 128 255 128 0 64 255 255 0 128 255 128 128 64 255 128 128 128 255 255 128 255 255 0 64 0 255 0 0 0 255 255 255 255 255 255 128 0 true 0 255 255 255 1 255 0 0 0 false 0.0 2.0 0.0 3.0 false row["DATETIME"] Orthogonal_Value , Outside false true 1.0 Text Sum Horizontal 1 255 154 154 154 true Arial 10.0 255 45 45 47 0 255 255 255 1 255 0 0 0 0.0 2.0 0.0 3.0 true HH Below 1 255 196 196 196 false Across 1 255 154 154 154 true 1 255 225 225 225 false Across 1 255 225 225 225 false 5 Min 0.0 true true false 0 255 255 255 255 192 192 192 Vertical 50.0 ]]> SVG _self drill-through report-design bookmark mailing_openers_progress.rptdesign companyID "" + params["companyID"] mailingID "" + params["mailingID"] language params["language"].value startDate row["DATETIME"] stopDate row["DATETIME"] hourScale true selectedTargets params["selectedTargets"].value recipientType params["recipientType"] viewChart params["viewChart"] emmsession params["emmsession"].value sec params["sec"].value eq row["DEVICECLASSID"] 0 true false "Arial" #707173 320px 780px MailingOpenersTimeBasedDataSet DATETIME dataSetRow["DATETIME"] date-time OPENERS_UNIQUE dataSetRow["OPENERS_UNIQUE"] integer OPENINGS_GROSS dataSetRow["OPENINGS_GROSS"] integer TARGETGROUP dataSetRow["TARGETGROUP"] string DEVICECLASSID dataSetRow["DEVICECLASSID"] integer COLUMN_INDEX dataSetRow["COLUMN_INDEX"] integer false MailingOpenersTimeBasedDataSet DATETIME DATETIME if (reportContext.getParameterValue("hourScale") == true) { dateformat = new Packages.java.text.SimpleDateFormat("dd.MM.yyyy hh:mm"); dateformat.format(dataSetRow["DATETIME"]); } else { dateformat = new Packages.java.text.SimpleDateFormat("dd.MM.yyyy"); dateformat.format(dataSetRow["DATETIME"]); } string OPENERS_UNIQUE OPENERS_UNIQUE dataSetRow["OPENERS_UNIQUE"] integer TARGETGROUP TARGETGROUP dataSetRow["TARGETGROUP"] string COLUMN_INDEX COLUMN_INDEX dataSetRow["COLUMN_INDEX"] integer DEVICECLASSID DEVICECLASSID dataSetRow["DEVICECLASSID"] integer false row["DATETIME"] asc 0 row["COLUMN_INDEX"] asc 1

tr("Date") auto tr("OpeningsNet") auto tr("Target") auto tr("recipient.deviceType") auto

DATETIME OPENERS_UNIQUE TARGETGROUP all row["DEVICECLASSID"] != 1 tr("report.device.desktop") auto all row["DEVICECLASSID"] != 0 tr("report.device.mixed") auto all row["DEVICECLASSID"] != 2 tr("report.device.mobile") auto all row["DEVICECLASSID"] != 3 tr("report.device.tablet") auto all row["DEVICECLASSID"] != 4 tr("report.device.smarttv") auto