Dynamic GRID elements

newbie_12

<p>Hi All,</p><p> </p><p>One query -</p><p> </p><p>I have divided my grid in 2 panes - left and right.</p><p> </p><p>On the left pane, I have multiple items and if I click any of them, each of the link should show different table information or grid elements on the right pane.</p><p> </p><p>For ex:</p><p> </p><p>Link A -> Displays data from table A</p><p>Link B - > Displays data from table B and graph.</p><p>Link C - > Displays data from table C and graphs.</p><p> </p><p>One more issue here - Based on the no. of columns retrived from each of the table, the no. of charts to be plotted should change automatically - </p><p> </p><p>For ex:</p><p> </p><p>If table B fetches 10 columns then 10 graphs should get plotted automatically</p><p>If table C fetches 5 columns then only 5 graphs should get plotted automatically.</p><p> </p><p> </p><p>Any help ?</p><p> </p><p>Thanks</p><p>Mangalam</p><p> </p><p> </p><p> </p><p> </p><p> </p><p> </p><p> </p>

johnw

<p>There are several different ways to do this.</p><p> </p><p>-Single Report</p><p>-Mashup</p><p>-Dashboard</p><p> </p><p>Each has it's own pros and cons that you will need to weigh. Personally for this type of request I'd go with a Mashup, but I will just stick with the single report. It will require re-running the report each time you click on the left hand link. Basically it is just a parameterized report with a default value that will call itself as a drill down each time you click on a link with the new value. </p><pre class="_prettyXprint _lang-"><?xml version="1.0" encoding="UTF-8"?><report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.23" id="1"> <property name="author">Paul Clenahan</property> <property name="comments">Copyright (c) 2006 &lt;&lt;Your Company Name here>></property> <property name="createdBy">Eclipse BIRT Designer Version 4.2.1.v201209101448 Build &lt;4.2.1.v20120912-1721></property> <text-property name="title">Top Selling Products</text-property> <property name="units">in</property> <property name="layoutPreference">auto layout</property> <parameters> <scalar-parameter name="NewParameter" id="173"> <property name="hidden">true</property> <property name="valueType">dynamic</property> <property name="isRequired">false</property> <property name="dataSetName">setGetOffices</property> <expression name="valueExpr" type="javascript">dataSetRow["OFFICECODE"]</expression> <expression name="labelExpr" type="javascript">dataSetRow["CITY"]</expression> <expression name="sortByColumn">dataSetRow["CITY"]</expression> <property name="sortDirection">asc</property> <property name="dataType">string</property> <property name="distinct">true</property> <simple-property-list name="defaultValue"> <value type="constant">7</value> </simple-property-list> <list-property name="selectionList"/> <property name="paramType">simple</property> <property name="controlType">list-box</property> <property name="mustMatch">false</property> <property name="fixedOrder">false</property> <structure name="format"> <property name="category">Unformatted</property> </structure> </scalar-parameter> </parameters> <data-sources> <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Classic Models" id="4"> <text-property name="displayName">Classic Models</text-property> <property name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver</property> <property name="odaURL">jdbc:classicmodels:sampledb</property> <property name="odaUser">ClassicModels</property> </oda-data-source> </data-sources> <data-sets> <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Employees" id="48"> <list-property name="columnHints"> <structure> <property name="columnName">EMPLOYEENUMBER</property> <property name="analysis">measure</property> <text-property name="displayName">EMPLOYEENUMBER</text-property> <text-property name="heading">EMPLOYEENUMBER</text-property> </structure> <structure> <property name="columnName">LASTNAME</property> <property name="analysis">dimension</property> <text-property name="displayName">LASTNAME</text-property> <text-property name="heading">LASTNAME</text-property> </structure> <structure> <property name="columnName">FIRSTNAME</property> <property name="analysis">dimension</property> <text-property name="displayName">FIRSTNAME</text-property> <text-property name="heading">FIRSTNAME</text-property> </structure> <structure> <property name="columnName">EXTENSION</property> <property name="analysis">dimension</property> <text-property name="displayName">EXTENSION</text-property> <text-property name="heading">EXTENSION</text-property> </structure> <structure> <property name="columnName">EMAIL</property> <property name="analysis">dimension</property> <text-property name="displayName">EMAIL</text-property> <text-property name="heading">EMAIL</text-property> </structure> <structure> <property name="columnName">OFFICECODE</property> <property name="analysis">dimension</property> <text-property name="displayName">OFFICECODE</text-property> <text-property name="heading">OFFICECODE</text-property> </structure> <structure> <property name="columnName">REPORTSTO</property> <property name="analysis">measure</property> <text-property name="displayName">REPORTSTO</text-property> <text-property name="heading">REPORTSTO</text-property> </structure> <structure> <property name="columnName">JOBTITLE</property> <property name="analysis">dimension</property> <text-property name="displayName">JOBTITLE</text-property> <text-property name="heading">JOBTITLE</text-property> </structure> </list-property> <list-property name="parameters"> <structure> <property name="name">param_1</property> <property name="paramName">NewParameter</property> <property name="nativeName"></property> <property name="dataType">string</property> <property name="nativeDataType">12</property> <property name="position">1</property> <property name="isOptional">true</property> <property name="allowNull">true</property> <property name="isInput">true</property> <property name="isOutput">false</property> </structure> </list-property> <structure name="cachedMetaData"> <list-property name="resultSet"> <structure> <property name="position">1</property> <property name="name">EMPLOYEENUMBER</property> <property name="dataType">integer</property> </structure> <structure> <property name="position">2</property> <property name="name">LASTNAME</property> <property name="dataType">string</property> </structure> <structure> <property name="position">3</property> <property name="name">FIRSTNAME</property> <property name="dataType">string</property> </structure> <structure> <property name="position">4</property> <property name="name">EXTENSION</property> <property name="dataType">string</property> </structure> <structure> <property name="position">5</property> <property name="name">EMAIL</property> <property name="dataType">string</property> </structure> <structure> <property name="position">6</property> <property name="name">OFFICECODE</property> <property name="dataType">string</property> </structure> <structure> <property name="position">7</property> <property name="name">REPORTSTO</property> <property name="dataType">integer</property> </structure> <structure> <property name="position">8</property> <property name="name">JOBTITLE</property> <property name="dataType">string</property> </structure> </list-property> </structure> <property name="dataSource">Classic Models</property> <list-property name="resultSet"> <structure> <property name="position">1</property> <property name="name">EMPLOYEENUMBER</property> <property name="nativeName">EMPLOYEENUMBER</property> <property name="dataType">integer</property> <property name="nativeDataType">4</property> </structure> <structure> <property name="position">2</property> <property name="name">LASTNAME</property> <property name="nativeName">LASTNAME</property> <property name="dataType">string</property> <property name="nativeDataType">12</property> </structure> <structure> <property name="position">3</property> <property name="name">FIRSTNAME</property> <property name="nativeName">FIRSTNAME</property> <property name="dataType">string</property> <property name="nativeDataType">12</property> </structure> <structure> <property name="position">4</property> <property name="name">EXTENSION</property> <property name="nativeName">EXTENSION</property> <property name="dataType">string</property> <property name="nativeDataType">12</property> </structure> <structure> <property name="position">5</property> <property name="name">EMAIL</property> <property name="nativeName">EMAIL</property> <property name="dataType">string</property> <property name="nativeDataType">12</property> </structure> <structure> <property name="position">6</property> <property name="name">OFFICECODE</property> <property name="nativeName">OFFICECODE</property> <property name="dataType">string</property> <property name="nativeDataType">12</property> </structure> <structure> <property name="position">7</property> <property name="name">REPORTSTO</property> <property name="nativeName">REPORTSTO</property> <property name="dataType">integer</property> <property name="nativeDataType">4</property> </structure> <structure> <property name="position">8</property> <property name="name">JOBTITLE</property> <property name="nativeName">JOBTITLE</property> <property name="dataType">string</property> <property name="nativeDataType">12</property> </structure> </list-property> <xml-property name="queryText"><![CDATA[select *from CLASSICMODELS.EMPLOYEESwhere CLASSICMODELS.EMPLOYEES.OFFICECODE = ?]]></xml-property> <xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?><model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel"> <Version>2.0</Version> <DataSetParameters> <parameter> <design:ParameterDefinition> <design:inOutMode>In</design:inOutMode> <design:attributes> <design:identifier> <design:name></design:name> <design:position>1</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> <design:precision>10</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> </design:attributes> <design:inputAttributes> <design:elementAttributes> <design:optional>true</design:optional> </design:elementAttributes> </design:inputAttributes> </design:ParameterDefinition> </parameter> </DataSetParameters> <design:ResultSets derivedMetaData="true"> <design:resultSetDefinitions> <design:resultSetColumns> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>EMPLOYEENUMBER</design:name> <design:position>1</design:position> </design:identifier> <design:nativeDataTypeCode>4</design:nativeDataTypeCode> <design:precision>10</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> </design:attributes> <design:usageHints> <design:label>EMPLOYEENUMBER</design:label> <design:formattingHints> <design:displaySize>11</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>LASTNAME</design:name> <design:position>2</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> <design:precision>50</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> </design:attributes> <design:usageHints> <design:label>LASTNAME</design:label> <design:formattingHints> <design:displaySize>50</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>FIRSTNAME</design:name> <design:position>3</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> <design:precision>50</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> </design:attributes> <design:usageHints> <design:label>FIRSTNAME</design:label> <design:formattingHints> <design:displaySize>50</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>EXTENSION</design:name> <design:position>4</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> <design:precision>10</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> </design:attributes> <design:usageHints> <design:label>EXTENSION</design:label> <design:formattingHints> <design:displaySize>10</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>EMAIL</design:name> <design:position>5</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> <design:precision>100</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> </design:attributes> <design:usageHints> <design:label>EMAIL</design:label> <design:formattingHints> <design:displaySize>100</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>OFFICECODE</design:name> <design:position>6</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> <design:precision>10</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> </design:attributes> <design:usageHints> <design:label>OFFICECODE</design:label> <design:formattingHints> <design:displaySize>10</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>REPORTSTO</design:name> <design:position>7</design:position> </design:identifier> <design:nativeDataTypeCode>4</design:nativeDataTypeCode> <design:precision>10</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> </design:attributes> <design:usageHints> <design:label>REPORTSTO</design:label> <design:formattingHints> <design:displaySize>11</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>JOBTITLE</design:name> <design:position>8</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> <design:precision>50</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> </design:attributes> <design:usageHints> <design:label>JOBTITLE</design:label> <design:formattingHints> <design:displaySize>50</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> </design:resultSetColumns> </design:resultSetDefinitions> <design:resultSetDefinitions> <design:resultSetColumns> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>EMPLOYEENUMBER</design:name> <design:position>1</design:position> </design:identifier> <design:nativeDataTypeCode>4</design:nativeDataTypeCode> </design:attributes> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>LASTNAME</design:name> <design:position>2</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> </design:attributes> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>FIRSTNAME</design:name> <design:position>3</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> </design:attributes> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>EXTENSION</design:name> <design:position>4</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> </design:attributes> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>EMAIL</design:name> <design:position>5</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> </design:attributes> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>OFFICECODE</design:name> <design:position>6</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> </design:attributes> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>REPORTSTO</design:name> <design:position>7</design:position> </design:identifier> <design:nativeDataTypeCode>4</design:nativeDataTypeCode> </design:attributes> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>JOBTITLE</design:name> <design:position>8</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> </design:attributes> </design:resultColumnDefinitions> </design:resultSetColumns> </design:resultSetDefinitions> </design:ResultSets></model:DesignValues>]]></xml-property> </oda-data-set> <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="setGetOffices" id="172"> <list-property name="columnHints"> <structure> <property name="columnName">OFFICECODE</property> <property name="analysis">dimension</property> <text-property name="displayName">OFFICECODE</text-property> <text-property name="heading">OFFICECODE</text-property> </structure> <structure> <property name="columnName">CITY</property> <property name="analysis">dimension</property> <text-property name="displayName">CITY</text-property> <text-property name="heading">CITY</text-property> </structure> </list-property> <structure name="cachedMetaData"> <list-property name="resultSet"> <structure> <property name="position">1</property> <property name="name">OFFICECODE</property> <property name="dataType">string</property> </structure> <structure> <property name="position">2</property> <property name="name">CITY</property> <property name="dataType">string</property> </structure> </list-property> </structure> <property name="dataSource">Classic Models</property> <list-property name="resultSet"> <structure> <property name="position">1</property> <property name="name">OFFICECODE</property> <property name="nativeName">OFFICECODE</property> <property name="dataType">string</property> <property name="nativeDataType">12</property> </structure> <structure> <property name="position">2</property> <property name="name">CITY</property> <property name="nativeName">CITY</property> <property name="dataType">string</property> <property name="nativeDataType">12</property> </structure> </list-property> <xml-property name="queryText"><![CDATA[select CLASSICMODELS.OFFICES.OFFICECODE, CLASSICMODELS.OFFICES.CITYfrom CLASSICMODELS.OFFICES ]]></xml-property> <xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?><model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel"> <Version>2.0</Version> <design:ResultSets derivedMetaData="true"> <design:resultSetDefinitions> <design:resultSetColumns> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>OFFICECODE</design:name> <design:position>1</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> <design:precision>10</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>OFFICECODE</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>OFFICECODE</design:label> <design:formattingHints> <design:displaySize>10</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>CITY</design:name> <design:position>2</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> <design:precision>50</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>CITY</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>CITY</design:label> <design:formattingHints> <design:displaySize>50</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> </design:resultSetColumns> <design:criteria/> </design:resultSetDefinitions> </design:ResultSets></model:DesignValues>]]></xml-property> </oda-data-set> </data-sets> <styles> <style name="table-footer" id="102"> <property name="backgroundColor">#5C6C7B</property> <property name="fontFamily">sans-serif</property> <property name="fontSize">small</property> <property name="fontWeight">bold</property> <property name="color">#DEDCD3</property> </style> <style name="table-header" id="103"> <property name="backgroundColor">#5C6C7B</property> <property name="fontFamily">sans-serif</property> <property name="fontSize">small</property> <property name="fontWeight">bold</property> <property name="color">#DEDCD3</property> </style> <style name="table-detail" id="104"> <property name="backgroundColor">#DEDCD3</property> <property name="fontFamily">sans-serif</property> <property name="fontSize">x-small</property> <property name="color">#1C515A</property> <property name="borderBottomColor">#859CA1</property> <property name="borderBottomStyle">solid</property> <property name="borderBottomWidth">thin</property> <property name="borderLeftColor">#859CA1</property> <property name="borderLeftStyle">solid</property> <property name="borderLeftWidth">thin</property> <property name="borderRightColor">#859CA1</property> <property name="borderRightStyle">solid</property> <property name="borderRightWidth">thin</property> <property name="borderTopColor">#859CA1</property> <property name="borderTopStyle">solid</property> <property name="borderTopWidth">thin</property> </style> <style name="group1-header" id="105"> <property name="backgroundColor">#859CA1</property> <property name="fontFamily">sans-serif</property> <property name="fontSize">small</property> <property name="fontWeight">bold</property> <property name="color">#F5F5DC</property> </style> <style name="group1-footer" id="106"> <property name="backgroundColor">#859CA1</property> <property name="fontFamily">sans-serif</property> <property name="fontSize">small</property> <property name="fontWeight">bold</property> <property name="color">#F5F5DC</property> </style> </styles> <page-setup> <simple-master-page name="Simple MasterPage" id="2"> <property name="topMargin">0.5in</property> <property name="leftMargin">0.5in</property> <property name="bottomMargin">0.5in</property> <property name="rightMargin">0.5in</property> </simple-master-page> </page-setup> <body> <grid id="23"> <property name="backgroundColor">#D2D2D2</property> <property name="width">100%</property> <column id="24"> <property name="width">1.604in</property> </column> <column id="25"> <property name="width">3.197in</property> </column> <column id="26"> <property name="width">2.687in</property> </column> <row id="27"> <cell id="28"> <property name="textAlign">center</property> <property name="verticalAlign">middle</property> <image name="Logo" id="35"> <property name="borderBottomColor">#C0C0C0</property> <property name="borderBottomStyle">solid</property> <property name="borderBottomWidth">thin</property> <property name="borderLeftColor">#C0C0C0</property> <property name="borderLeftStyle">solid</property> <property name="borderLeftWidth">thin</property> <property name="borderRightColor">#C0C0C0</property> <property name="borderRightStyle">solid</property> <property name="borderRightWidth">thin</property> <property name="borderTopColor">#C0C0C0</property> <property name="borderTopStyle">solid</property> <property name="borderTopWidth">thin</property> <property name="source">embed</property> <property name="imageName">Classic-Models-Minimal-S.jpg</property> </image> </cell> <cell id="29"> <label name="Report Title" id="36"> <property name="fontSize">16pt</property> <property name="fontWeight">bold</property> <property name="textAlign">center</property> <text-property name="text">Employee List</text-property> </label> </cell> <cell id="30"> <property name="verticalAlign">middle</property> <label name="Classic Models Name" id="39"> <property name="fontSize">18pt</property> <property name="fontWeight">bold</property> <property name="color">#004080</property> <text-property name="text">Classic Models Inc.</text-property> </label> <text id="41"> <property name="contentType">plain</property> <text-property name="content"><![CDATA[701 Gateway Blvd,South San Francisco, CA 94080]]></text-property> </text> </cell> </row> <row id="31"> <property name="backgroundColor">#FFFFFF</property> <cell id="32"/> <cell id="33"/> <cell id="34"/> </row> </grid> <grid id="42"> <property name="width">100%</property> <column id="43"/> <column id="44"/> <row id="45"> <cell id="46"> <property name="borderBottomColor">#C0C0C0</property> <property name="borderBottomStyle">solid</property> <property name="borderBottomWidth">medium</property> <property name="borderLeftColor">#C0C0C0</property> <property name="borderLeftStyle">solid</property> <property name="borderLeftWidth">medium</property> <property name="borderRightColor">#C0C0C0</property> <property name="borderRightStyle">solid</property> <property name="borderRightWidth">medium</property> <property name="borderTopColor">#C0C0C0</property> <property name="borderTopStyle">solid</property> <property name="borderTopWidth">medium</property> <property name="verticalAlign">top</property> <table id="174"> <property name="dataSet">setGetOffices</property> <list-property name="boundDataColumns"> <structure> <property name="name">OFFICECODE</property> <text-property name="displayName">OFFICECODE</text-property> <expression name="expression" type="javascript">dataSetRow["OFFICECODE"]</expression> <property name="dataType">string</property> </structure> <structure> <property name="name">CITY</property> <text-property name="displayName">CITY</text-property> <expression name="expression" type="javascript">dataSetRow["CITY"]</expression> <property name="dataType">string</property> </structure> </list-property> <column id="188"/> <column id="189"/> <header> <row id="175"> <cell id="176"> <label id="177"> <text-property name="text">OFFICECODE</text-property> </label> </cell> <cell id="178"> <label id="179"> <text-property name="text">CITY</text-property> </label> </cell> </row> </header> <detail> <row id="180"> <cell id="181"> <data id="182"> <property name="resultSetColumn">OFFICECODE</property> <list-property name="action"> <structure> <property name="linkType">drill-through</property> <property name="reportName">EmployeeAfter.rptdesign</property> <property name="targetWindow">_self</property> <property name="targetFileType">report-design</property> <list-property name="paramBindings"> <structure> <property name="paramName">NewParameter</property> <simple-property-list name="expression"> <value type="javascript">row["OFFICECODE"]</value> </simple-property-list> </structure> </list-property> </structure> </list-property> </data> </cell> <cell id="183"> <data id="184"> <property name="resultSetColumn">CITY</property> <list-property name="action"> <structure> <property name="linkType">drill-through</property> <property name="reportName">EmployeeAfter.rptdesign</property> <property name="targetWindow">_self</property> <property name="targetFileType">report-design</property> <list-property name="paramBindings"> <structure> <property name="paramName">NewParameter</property> <simple-property-list name="expression"> <value type="javascript">row["OFFICECODE"]</value> </simple-property-list> </structure> </list-property> </structure> </list-property> </data> </cell> </row> </detail> <footer> <row id="185"> <cell id="186"/> <cell id="187"/> </row> </footer> </table> </cell> <cell id="47"> <property name="borderBottomColor">#C0C0C0</property> <property name="borderBottomStyle">solid</property> <property name="borderBottomWidth">medium</property> <property name="borderLeftColor">#C0C0C0</property> <property name="borderLeftStyle">solid</property> <property name="borderLeftWidth">medium</property> <property name="borderRightColor">#C0C0C0</property> <property name="borderRightStyle">solid</property> <property name="borderRightWidth">medium</property> <property name="borderTopColor">#C0C0C0</property> <property name="borderTopStyle">solid</property> <property name="borderTopWidth">medium</property> <property name="verticalAlign">top</property> <table id="190"> <property name="dataSet">Employees</property> <list-property name="boundDataColumns"> <structure> <property name="name">EMPLOYEENUMBER</property> <text-property name="displayName">EMPLOYEENUMBER</text-property> <expression name="expression" type="javascript">dataSetRow["EMPLOYEENUMBER"]</expression> <property name="dataType">integer</property> </structure> <structure> <property name="name">LASTNAME</property> <text-property name="displayName">LASTNAME</text-property> <expression name="expression" type="javascript">dataSetRow["LASTNAME"]</expression> <property name="dataType">string</property> </structure> <structure> <property name="name">FIRSTNAME</property> <text-property name="displayName">FIRSTNAME</text-property> <expression name="expression" type="javascript">dataSetRow["FIRSTNAME"]</expression> <property name="dataType">string</property> </structure> <structure> <property name="name">EXTENSION</property> <text-property name="displayName">EXTENSION</text-property> <expression name="expression" type="javascript">dataSetRow["EXTENSION"]</expression> <property name="dataType">string</property> </structure> <structure> <property name="name">EMAIL</property> <text-property name="displayName">EMAIL</text-property> <expression name="expression" type="javascript">dataSetRow["EMAIL"]</expression> <property name="dataType">string</property> </structure> <structure> <property name="name">OFFICECODE</property> <text-property name="displayName">OFFICECODE</text-property> <expression name="expression" type="javascript">dataSetRow["OFFICECODE"]</expression> <property name="dataType">string</property> </structure> <structure> <property name="name">REPORTSTO</property> <text-property name="displayName">REPORTSTO</text-property> <expression name="expression" type="javascript">dataSetRow["REPORTSTO"]</expression> <property name="dataType">integer</property> </structure> <structure> <property name="name">JOBTITLE</property> <text-property name="displayName">JOBTITLE</text-property> <expression name="expression" type="javascript">dataSetRow["JOBTITLE"]</expression> <property name="dataType">string</property> </structure> </list-property> <column id="234"/> <column id="235"/> <column id="236"/> <header> <row id="191"> <cell id="192"> <label id="193"> <text-property name="text">EMPLOYEENUMBER</text-property> </label> </cell> <cell id="194"> <label id="195"> <text-property name="text">LASTNAME</text-property> </label> </cell> <cell id="196"> <label id="197"> <text-property name="text">FIRSTNAME</text-property> </label> </cell> </row> </header> <detail> <row id="208"> <cell id="209"> <data id="210"> <property name="resultSetColumn">EMPLOYEENUMBER</property> </data> </cell> <cell id="211"> <data id="212"> <property name="resultSetColumn">LASTNAME</property> </data> </cell> <cell id="213"> <data id="214"> <property name="resultSetColumn">FIRSTNAME</property> </data> </cell> </row> </detail> <footer> <row id="225"> <cell id="226"/> <cell id="227"/> <cell id="228"/> </row> </footer> </table> </cell> </row> </grid> </body> <list-property name="images"> <structure> <property name="name">Classic-Models-Minimal-S.jpg</property> <property name="data"> /9j/4AAQSkZJRgABAgEBLAEsAAD/4QEuRXhpZgAATU0AKgAAAAgABwESAAMAAAABAAEAAAEaAAUAAAAB AAAAYgEbAAUAAAABAAAAagEoAAMAAAABAAIAAAExAAIAAAAUAAAAcgEyAAIAAAAUAAAAhodpAAQAAAAB AAAAnAAAAMgAAAEsAAAAAQAAASwAAAABQWRvYmUgUGhvdG9zaG9wIDcuMAAyMDA1OjA0OjA1IDE2OjI2 OjQ1AAAAAAOgAQADAAAAAf//AACgAgAEAAAAAQAAAI2gAwAEAAAAAQAAAFIAAAAAAAAABgEDAAMAAAAB AAYAAAEaAAUAAAABAAABFgEbAAUAAAABAAABHgEoAAMAAAABAAIAAAIBAAQAAAABAAABJgICAAQAAAAB AAAAAAAAAAAAAABIAAAAAQAAAEgAAAAB/+0FvlBob3Rvc2hvcCAzLjAAOEJJTQQlAAAAAAAQAAAAAAAA AAAAAAAAAAAAADhCSU0D7QAAAAAAEAEsAAAAAQABASwAAAABAAE4QklNBCYAAAAAAA4AAAAAAAAAAAAA P4AAADhCSU0EDQAAAAAABAAAAB44QklNBBkAAAAAAAQAAAAeOEJJTQPzAAAAAAAJAAAAAAAAAAABADhC SU0ECgAAAAAAAQAAOEJJTScQAAAAAAAKAAEAAAAAAAAAAThCSU0D9QAAAAAASAAvZmYAAQBsZmYABgAA AAAAAQAvZmYAAQChmZoABgAAAAAAAQAyAAAAAQBaAAAABgAAAAAAAQA1AAAAAQAtAAAABgAAAAAAAThC SU0D+AAAAAAAcAAA/////////////////////////////wPoAAAAAP////////////////////////// //8D6AAAAAD/////////////////////////////A+gAAAAA/////////////////////////////wPo AAA4QklNBAgAAAAAABAAAAABAAACQAAAAkAAAAAAOEJJTQQeAAAAAAAEAAAAADhCSU0EGgAAAAADZQAA AAYAAAAAAAAAAAAAAFIAAACNAAAAGABDAGwAYQBzAHMAaQBjAC0ATQBvAGQAZQBsAHMALQBNAGkAbgBp AG0AYQBsAC0AUwAAAAEAAAAAAAAAAAAAAAAAAAAAAAAAAQAAAAAAAAAAAAAAjQAAAFIAAAAAAAAAAAAA AAAAAAAAAQAAAAAAAAAAAAAAAAAAAAAAAAAQAAAAAQAAAAAAAG51bGwAAAACAAAABmJvdW5kc09iamMA AAABAAAAAAAAUmN0MQAAAAQAAAAAVG9wIGxvbmcAAAAAAAAAAExlZnRsb25nAAAAAAAAAABCdG9tbG9u ZwAAAFIAAAAAUmdodGxvbmcAAACNAAAABnNsaWNlc1ZsTHMAAAABT2JqYwAAAAEAAAAAAAVzbGljZQAA ABIAAAAHc2xpY2VJRGxvbmcAAAAAAAAAB2dyb3VwSURsb25nAAAAAAAAAAZvcmlnaW5lbnVtAAAADEVT bGljZU9yaWdpbgAAAA1hdXRvR2VuZXJhdGVkAAAAAFR5cGVlbnVtAAAACkVTbGljZVR5cGUAAAAASW1n IAAAAAZib3VuZHNPYmpjAAAAAQAAAAAAAFJjdDEAAAAEAAAAAFRvcCBsb25nAAAAAAAAAABMZWZ0bG9u ZwAAAAAAAAAAQnRvbWxvbmcAAABSAAAAAFJnaHRsb25nAAAAjQAAAAN1cmxURVhUAAAAAQAAAAAAAG51 bGxURVhUAAAAAQAAAAAAAE1zZ2VURVhUAAAAAQAAAAAABmFsdFRhZ1RFWFQAAAABAAAAAAAOY2VsbFRl eHRJc0hUTUxib29sAQAAAAhjZWxsVGV4dFRFWFQAAAABAAAAAAAJaG9yekFsaWduZW51bQAAAA9FU2xp Y2VIb3J6QWxpZ24AAAAHZGVmYXVsdAAAAAl2ZXJ0QWxpZ25lbnVtAAAAD0VTbGljZVZlcnRBbGlnbgAA AAdkZWZhdWx0AAAAC2JnQ29sb3JUeXBlZW51bQAAABFFU2xpY2VCR0NvbG9yVHlwZQAAAABOb25lAAAA CXRvcE91dHNldGxvbmcAAAAAAAAACmxlZnRPdXRzZXRsb25nAAAAAAAAAAxib3R0b21PdXRzZXRsb25n AAAAAAAAAAtyaWdodE91dHNldGxvbmcAAAAAADhCSU0EEQAAAAAAAQEAOEJJTQQUAAAAAAAEAAAAGThC SU0EIQAAAAAAVQAAAAEBAAAADwBBAGQAbwBiAGUAIABQAGgAbwB0AG8AcwBoAG8AcAAAABMAQQBkAG8A YgBlACAAUABoAG8AdABvAHMAaABvAHAAIAA3AC4AMAAAAAEAOEJJTQQGAAAAAAAHAAgAAQABAQD/4RJI aHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wLwA8P3hwYWNrZXQgYmVnaW49J++7vycgaWQ9J1c1TTBN cENlaGlIenJlU3pOVGN6a2M5ZCc/Pgo8P2Fkb2JlLXhhcC1maWx0ZXJzIGVzYz0iQ1IiPz4KPHg6eGFw bWV0YSB4bWxuczp4PSdhZG9iZTpuczptZXRhLycgeDp4YXB0az0nWE1QIHRvb2xraXQgMi44LjItMzMs IGZyYW1ld29yayAxLjUnPgo8cmRmOlJERiB4bWxuczpyZGY9J2h0dHA6Ly93d3cudzMub3JnLzE5OTkv MDIvMjItcmRmLXN5bnRheC1ucyMnIHhtbG5zOmlYPSdodHRwOi8vbnMuYWRvYmUuY29tL2lYLzEuMC8n PgoKIDxyZGY6RGVzY3JpcHRpb24gYWJvdXQ9J3V1aWQ6ZmY3ZjU0MjMtYTYyOS0xMWQ5LWFlNDUtYzVi ZTU4MDBkZTdhJwogIHhtbG5zOnhhcE1NPSdodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvbW0vJz4K ICA8eGFwTU06RG9jdW1lbnRJRD5hZG9iZTpkb2NpZDpwaG90b3Nob3A6OTAxNmVjMjQtYTYyNi0xMWQ5 LWFlNDUtYzViZTU4MDBkZTdhPC94YXBNTTpEb2N1bWVudElEPgogPC9yZGY6RGVzY3JpcHRpb24+Cgo8 L3JkZjpSREY+CjwveDp4YXBtZXRhPgogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAK ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAog ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAg