Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
how to use value of connection pofile nodes in property Binding of Data Source
Rajan_Arx
My Profile Contains the csv Folder path as shown below. <br />
For Every report, the csv name will be dynamically assigned. I have created one report parameter named "csvName".<br />
I am trying to set the FILE URI by adding the "csvName" with "HOME"[which is in connection profile]. I am not able to find a way how to access the "home" which resides in my connection profile File. <br />
<br />
Is it Possible ? What is best way to doing it as this is quite common requirement? I am bit new in BIRT. <br />
<br />
<?xml version="1.0" encoding="UTF-8" standalone="no"?><DataTools.ServerProfiles version="1.0"><br />
<profile autoconnect="No" desc="" id="d94ab000-a0de-11e1-9c21-e8d84269d77c"<br />
name="FlatFileConnectionProfile"<br />
providerID="org.eclipse.datatools.connectivity.oda.flatfile"><br />
<br />
<baseproperties><br />
<strong class='bbc'><property name="HOME" value="E:\OfficialWork\Client Receivables\Reports\CSV_formats"/></strong><br />
<property name="INCLCOLUMNNAME" value="YES"/><br />
<property name="INCLTYPELINE" value="NO"/><br />
<property name="DELIMTYPE" value="COMMA"/><br />
<property name="TRAILNULLCOLS" value="NO"/><br />
<property name="CHARSET" value="UTF-8"/><br />
</baseproperties>
Find more posts tagged with
Comments
mwilliams
You can access the "HOME" value of your dataSource in the beforeFactory with the following line of code:
reportContext.getDesignHandle().findDataSource("Data Source1").getStringProperty("HOME");
Is this what you're wanting access to? If not, let me know.
Rajan_Arx
Thanks for your reply.
What I intend to do is get the DataSource Home folder path from connection profile as mentioned above.
Moreover, I want to override it dynamically by report parameter as shown in the screenshot.
But I am doing by via report parameter , it goes to same home folder as mentioned in connection profile. Just to test where is the problem, when I remove <property name="HOME" value="E:\OfficialWork\Client Receivables\Reports\CSV_formats"/> from connection profile, it goes to new location as set in report parameter.
Where am I doing mistake . Please help !
Thank,
Rajan
mwilliams
Sorry for the delay. Have you solved this issue? If not, can you create an example that shows what you're doing, so I can test on it? Thanks!
Rajan_Arx
I am still struggling to override the Home value of connection Profile by using Property Binding and report parameter. It still goes to the path set in connection Profile .<br />
<br />
Appreciate your Help ! <br />
<br />
<br />
This page is not allowing me to upload connection Profile and sample CSV . SO I am putting it as below.<br />
<br />
<br />
<strong class='bbc'>Connection Profile</strong><br />
<br />
<?xml version="1.0" encoding="UTF-8" standalone="no"?><DataTools.ServerProfiles version="1.0"><profile autoconnect="No" desc=""<br />
id="fedf9ef0-a653-11e1-9361-f2385e0207f5" name="VirsecCSVSource" providerID="org.eclipse.datatools.connectivity.oda.flatfile"><br />
<baseproperties><br />
<property name="HOME" value="E:\OfficialWork\Virsec Docs\Client Receivables\Reports\CSV_formats\CSV Details"/><br />
<property name="INCLCOLUMNNAME" value="YES"/><property name="INCLTYPELINE" value="NO"/><property name="DELIMTYPE" value="COMMA"/><property name="TRAILNULLCOLS" value="NO"/><property name="CHARSET" value="UTF-8"/></baseproperties><org.eclipse.datatools.connectivity.versionInfo><property name="server.version" value="3.0.0"/><property name="technology.name.org.eclipse.datatools.connectivity.oda.flatfile" value="DTP Open Data Access"/><property name="server.name" value="DTP ODA Flat File Data Source Provider"/><property name="technology.version.org.eclipse.datatools.connectivity.oda.flatfile" value="3.0.6"/></org.eclipse.datatools.connectivity.versionInfo></profile></DataTools.ServerProfiles><br />
<br />
<br />
<br />
<br />
<strong class='bbc'>Sample CSV:</strong><br />
<br />
FnName SrcFileName LineNumber TotalTime HitCount<br />
WndProc virnote.c 211 5.47244 207<br />
WinMain virnote.c 502 4.17796 1<br />
_getptd_noexit NotFound 0 0.138797 655<br />
_RTC_CheckEsp NotFound 0 0.135822 445<br />
_heap_alloc_dbg_impl NotFound 0 0.106095 480<br />
x_ismbbtype_l ismbbyte.c 213 0.10141 124<br />
_getptd NotFound 0 0.0557997 262
rushtonjj
I am completely struggling with my program. I have no idea what imports I need and how to use them for CSV flat file. I created the report below. Nothing in the BIRT documentation talks directly about only generating a report with Java that doesn't include a servlet or HTML. I need this generated from a straight forward Standalone api that will not have access to the Internet. Please help. I'm on a crunch.
<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="
http://www.eclipse.org/birt/2005/design"
; version="3.2.23" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 3.7.2.v20120213 Build <3.7.2.v20120214-1408></property>
<list-property name="propertyBindings">
<structure>
<property name="name">queryText</property>
<property name="id">8</property>
</structure>
<structure>
<property name="name">HOME</property>
<property name="id">7</property>
</structure>
<structure>
<property name="name">URI</property>
<property name="id">7</property>
</structure>
<structure>
<property name="name">DELIMTYPE</property>
<property name="id">7</property>
</structure>
<structure>
<property name="name">CHARSET</property>
<property name="id">7</property>
</structure>
<structure>
<property name="name">INCLCOLUMNNAME</property>
<property name="id">7</property>
</structure>
<structure>
<property name="name">INCLTYPELINE</property>
<property name="id">7</property>
</structure>
<structure>
<property name="name">TRAILNULLCOLS</property>
<property name="id">7</property>
</structure>
<structure>
<property name="name">OdaConnProfileName</property>
<property name="id">7</property>
</structure>
<structure>
<property name="name">OdaConnProfileStorePath</property>
<property name="id">7</property>
</structure>
</list-property>
<property name="units">in</property>
<property name="iconFile">/templates/blank_report.gif</property>
<property name="layoutPreference">fixed layout</property>
<property name="bidiLayoutOrientation">ltr</property>
<property name="imageDPI">120</property>
<data-sources>
<oda-data-source extensionID="org.eclipse.datatools.connectivity.oda.flatfile" name="DataSourceMeterCard" id="7">
<property name="HOME">D:\Documents and Settings\jaime.rushton\workspace\APIs</property>
<property name="DELIMTYPE">COMMA</property>
<property name="CHARSET">UTF-8</property>
<property name="INCLCOLUMNNAME">YES</property>
<property name="INCLTYPELINE">NO</property>
<property name="TRAILNULLCOLS">YES</property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.datatools.connectivity.oda.flatfile.dataSet" name="DataSetMeterCard" id="8">
<property name="nullsOrdering">nulls lowest</property>
<list-property name="columnHints">
<structure>
<property name="columnName">SERVICED_LAB</property>
<property name="analysis">dimension</property>
<text-property name="heading">SERVICED_LAB</text-property>
</structure>
<structure>
<property name="columnName">CUSTOMER_ID</property>
<property name="analysis">dimension</property>
<text-property name="heading">CUSTOMER_ID</text-property>
</structure>
<structure>
<property name="columnName">MODEL_NO</property>
<property name="analysis">dimension</property>
<text-property name="heading">MODEL_NO</text-property>
</structure>
<structure>
<property name="columnName">SERIAL_NO</property>
<property name="analysis">dimension</property>
<text-property name="heading">SERIAL_NO</text-property>
</structure>
<structure>
<property name="columnName">ECN</property>
<property name="analysis">dimension</property>
<text-property name="heading">ECN</text-property>
</structure>
<structure>
<property name="columnName">NOMENCLATURE</property>
<property name="analysis">dimension</property>
<text-property name="heading">NOMENCLATURE</text-property>
</structure>
<structure>
<property name="columnName">SUB_CUSTODIAN</property>
<property name="analysis">dimension</property>
<text-property name="heading">SUB_CUSTODIAN</text-property>
</structure>
<structure>
<property name="columnName">SCHED_LAB</property>
<property name="analysis">dimension</property>
<text-property name="heading">SCHED_LAB</text-property>
</structure>
<structure>
<property name="columnName">METRL_CYCLE</property>
<property name="analysis">dimension</property>
<text-property name="heading">METRL_CYCLE</text-property>
</structure>
<structure>
<property name="columnName">MFR_CD</property>
<property name="analysis">dimension</property>
<text-property name="heading">MFR_CD</text-property>
</structure>
<structure>
<property name="columnName">UIC</property>
<property name="analysis">dimension</property>
<text-property name="heading">UIC</text-property>
</structure>
<structure>
<property name="columnName">PROCEDURE_USED</property>
<property name="analysis">dimension</property>
<text-property name="heading">PROCEDURE_USED</text-property>
</structure>
<structure>
<property name="columnName">VALUE_FIXED</property>
<property name="analysis">dimension</property>
<text-property name="heading">VALUE_FIXED</text-property>
</structure>
<structure>
<property name="columnName">NSN</property>
<property name="analysis">dimension</property>
<text-property name="heading">NSN</text-property>
</structure>
<structure>
<property name="columnName">PART_OF</property>
<property name="analysis">dimension</property>
<text-property name="heading">PART_OF</text-property>
</structure>
<structure>
<property name="columnName">ON_SITE_SERVICE</property>
<property name="analysis">dimension</property>
<text-property name="heading">ON_SITE_SERVICE</text-property>
</structure>
<structure>
<property name="columnName">CAL_STD</property>
<property name="analysis">dimension</property>
<text-property name="heading">CAL_STD</text-property>
</structure>
<structure>
<property name="columnName">SERVICE_LABEL_CD</property>
<property name="analysis">dimension</property>
<text-property name="heading">SERVICE_LABEL_CD</text-property>
</structure>
<structure>
<property name="columnName">PLANT_ACCT</property>
<property name="analysis">dimension</property>
<text-property name="heading">PLANT_ACCT</text-property>
</structure>
<structure>
<property name="columnName">SCAT_CD</property>
<property name="analysis">dimension</property>
<text-property name="heading">SCAT_CD</text-property>
</structure>
<structure>
<property name="columnName">PHASE_ID</property>
<property name="analysis">dimension</property>
<text-property name="heading">PHASE_ID</text-property>
</structure>
<structure>
<property name="columnName">APPROVED_PROCEDURE</property>
<property name="analysis">dimension</property>
<text-property name="heading">APPROVED_PROCEDURE</text-property>
</structure>
<structure>
<property name="columnName">INV_SHOP_NO</property>
<property name="analysis">dimension</property>
<text-property name="heading">INV_SHOP_NO</text-property>
</structure>
<structure>
<property name="columnName">CLASS_STD</property>
<property name="analysis">dimension</property>
<text-property name="heading">CLASS_STD</text-property>
</structure>
<structure>
<property name="columnName">TYPE_STD</property>
<property name="analysis">dimension</property>
<text-property name="heading">TYPE_STD</text-property>
</structure>
<structure>
<property name="columnName">WIP_STATUS</property>
<property name="analysis">dimension</property>
<text-property name="heading">WIP_STATUS</text-property>
</structure>
<structure>
<property name="columnName">EQPMT_TYPE_CD</property>
<property name="analysis">dimension</property>
<text-property name="heading">EQPMT_TYPE_CD</text-property>
</structure>
<structure>
<property name="columnName">ICN</property>
<property name="analysis">dimension</property>
<text-property name="heading">ICN</text-property>
</structure>
<structure>
<property name="columnName">PRINT_METERCARD_FLG</property>
<property name="analysis">dimension</property>
<text-property name="heading">PRINT_METERCARD_FLG</text-property>
</structure>
<structure>
<property name="columnName">EQPMT_STATUS_CD</property>
<property name="analysis">dimension</property>
<text-property name="heading">EQPMT_STATUS_CD</text-property>
</structure>
<structure>
<property name="columnName">DELAY_REASON_CD</property>
<property name="analysis">dimension</property>
<text-property name="heading">DELAY_REASON_CD</text-property>
</structure>
<structure>
<property name="columnName">CONDITION_RECEIVED</property>
<property name="analysis">dimension</property>
<text-property name="heading">CONDITION_RECEIVED</text-property>
</structure>
<structure>
<property name="columnName">SPCL_INSTR_CD</property>
<property name="analysis">dimension</property>
<text-property name="heading">SPCL_INSTR_CD</text-property>
</structure>
<structure>
<property name="columnName">WORKLOAD_NORM_HRS</property>
<property name="analysis">dimension</property>
<text-property name="heading">WORKLOAD_NORM_HRS</text-property>
</structure>
<structure>
<property name="columnName">BIN_LOCATION</property>
<property name="analysis">dimension</property>
<text-property name="heading">BIN_LOCATION</text-property>
</structure>
<structure>
<property name="columnName">DT_SYS</property>
<property name="analysis">dimension</property>
<text-property name="heading">DT_SYS</text-property>
</structure>
<structure>
<property name="columnName">DT_RCVD</property>
<property name="analysis">dimension</property>
<text-property name="heading">DT_RCVD</text-property>
</structure>
<structure>
<property name="columnName">DT_INDUCT</property>
<property name="analysis">dimension</property>
<text-property name="heading">DT_INDUCT</text-property>
</structure>
<structure>
<property name="columnName">DT_DELAY</property>
<property name="analysis">dimension</property>
<text-property name="heading">DT_DELAY</text-property>
</structure>
<structure>
<property name="columnName">DT_REPTD</property>
<property name="analysis">dimension</property>
<text-property name="heading">DT_REPTD</text-property>
</structure>
<structure>
<property name="columnName">DT_LSTCAL</property>
<property name="analysis">dimension</property>
<text-property name="heading">DT_LSTCAL</text-property>
</structure>
<structure>
<property name="columnName">DT_NXT_DUE</property>
<property name="analysis">dimension</property>
<text-property name="heading">DT_NXT_DUE</text-property>
</structure>
<structure>
<property name="columnName">DT_RECALL</property>
<property name="analysis">dimension</property>
<text-property name="heading">DT_RECALL</text-property>
</structure>
<structure>
<property name="columnName">DT_CMPL</property>
<property name="analysis">dimension</property>
<text-property name="heading">DT_CMPL</text-property>
</structure>
<structure>
<property name="columnName">DT_CREATE</property>
<property name="analysis">dimension</property>
<text-property name="heading">DT_CREATE</text-property>
</structure>
<structure>
<property name="columnName">COST</property>
<property name="analysis">dimension</property>
<text-property name="heading">COST</text-property>
</structure>
<structure>
<property name="columnName">CAT_CUS</property>
<property name="analysis">dimension</property>
<text-property name="heading">CAT_CUS</text-property>
</structure>
<structure>
<property name="columnName">CAT_LAB</property>
<property name="analysis">dimension</property>
<text-property name="heading">CAT_LAB</text-property>
</structure>
<structure>
<property name="columnName">LAB_TYPE</property>
<property name="analysis">dimension</property>
<text-property name="heading">LAB_TYPE</text-property>
</structure>
<structure>
<property name="columnName">ACC_CODE</property>
<property name="analysis">dimension</property>
<text-property name="heading">ACC_CODE</text-property>
</structure>
<structure>
<property name="columnName">FLAG_OFFLN</property>
<property name="analysis">dimension</property>
<text-property name="heading">FLAG_OFFLN</text-property>
</structure>
<structure>
<property name="columnName">SITEID</property>
<property name="analysis">dimension</property>
<text-property name="heading">SITEID</text-property>
</structure>
<structure>
<property name="columnName">RCD_STA</property>
<property name="analysis">dimension</property>
<text-property name="heading">RCD_STA</text-property>
</structure>
<structure>
<property name="columnName">RCD_TYPE</property>
<property name="analysis">dimension</property>
<text-property name="heading">RCD_TYPE</text-property>
</structure>
<structure>
<property name="columnName">CUSTOMER</property>
<property name="analysis">dimension</property>
<text-property name="heading">CUSTOMER</text-property>
</structure>
<structure>
<property name="columnName">UIC_1</property>
<property name="analysis">dimension</property>
<text-property name="heading">UIC_1</text-property>
</structure>
<structure>
<property name="columnName">QUAL_CODE</property>
<property name="analysis">dimension</property>
<text-property name="heading">QUAL_CODE</text-property>
</structure>
<structure>
<property name="columnName">CAT_CD</property>
<property name="analysis">dimension</property>
<text-property name="heading">CAT_CD</text-property>
</structure>
<structure>
<property name="columnName">PROC_ONE</property>
<property name="analysis">dimension</property>
<text-property name="heading">PROC_ONE</text-property>
</structure>
<structure>
<property name="columnName">PROC_TWO</property>
<property name="analysis">dimension</property>
<text-property name="heading">PROC_TWO</text-property>
</structure>
<structure>
<property name="columnName">MAIL_CODE</property>
<property name="analysis">dimension</property>
<text-property name="heading">MAIL_CODE</text-property>
</structure>
<structure>
<property name="columnName">COMD_LINE</property>
<property name="analysis">dimension</property>
<text-property name="heading">COMD_LINE</text-property>
</structure>
<structure>
<property name="columnName">ADD_LINE1</property>
<property name="analysis">dimension</property>
<text-property name="heading">ADD_LINE1</text-property>
</structure>
<structure>
<property name="columnName">ADD_LINE2</property>
<property name="analysis">dimension</property>
<text-property name="heading">ADD_LINE2</text-property>
</structure>
<structure>
<property name="columnName">ADD_LINE3</property>
<property name="analysis">dimension</property>
<text-property name="heading">ADD_LINE3</text-property>
</structure>
<structure>
<property name="columnName">ADD_LINE4</property>
<property name="analysis">dimension</property>
<text-property name="heading">ADD_LINE4</text-property>
</structure>
<structure>
<property name="columnName">ADD_LINE5</property>
<property name="analysis">dimension</property>
<text-property name="heading">ADD_LINE5</text-property>
</structure>
<structure>
<property name="columnName">ADD_LINE6</property>
<property name="analysis">dimension</property>
<text-property name="heading">ADD_LINE6</text-property>
</structure>
<structure>
<property name="columnName">ACC_CODE_1</property>
<property name="analysis">dimension</property>
<text-property name="heading">ACC_CODE_1</text-property>
</structure>
<structure>
<property name="columnName">M3_CODE</property>
<property name="analysis">dimension</property>
<text-property name="heading">M3_CODE</text-property>
</structure>
<structure>
<property name="columnName">CHG_CUST</property>
<property name="analysis">dimension</property>
<text-property name="heading">CHG_CUST</text-property>
</structure>
<structure>
<property name="columnName">LAB_TYPE_CD</property>
<property name="analysis">dimension</property>
<text-property name="heading">LAB_TYPE_CD</text-property>
</structure>
<structure>
<property name="columnName">ZIP_CODE</property>
<property name="analysis">dimension</property>
<text-property name="heading">ZIP_CODE</text-property>
</structure>
<structure>
<property name="columnName">LAB_CORR</property>
<property name="analysis">dimension</property>
<text-property name="heading">LAB_CORR</text-property>
</structure>
<structure>
<property name="columnName">LAB2</property>
<property name="analysis">dimension</property>
<text-property name="heading">LAB2</text-property>
</structure>
<structure>
<property name="columnName">LAB3</property>
<property name="analysis">dimension</property>
<text-property name="heading">LAB3</text-property>
</structure>
<structure>
<property name="columnName">LAB4</property>
<property name="analysis">dimension</property>
<text-property name="heading">LAB4</text-property>
</structure>
<structure>
<property name="columnName">SITEID_2</property>
<property name="analysis">dimension</property>
<text-property name="heading">SITEID_2</text-property>
</structure>
<structure>
<property name="columnName">RCD_STA_2</property>
<property name="analysis">dimension</property>
<text-property name="heading">RCD_STA_2</text-property>
</structure>
<structure>
<property name="columnName">RCD_TYPE_2</property>
<property name="analysis">dimension</property>
<text-property name="heading">RCD_TYPE_2</text-property>
</structure>
<structure>
<property name="columnName">CUSTOMER_2</property>
<property name="analysis">dimension</property>
<text-property name="heading">CUSTOMER_2</text-property>
</structure>
<structure>
<property name="columnName">UIC_2</property>
<property name="analysis">dimension</property>
<text-property name="heading">UIC_2</text-property>
</structure>
<structure>
<property name="columnName">QUAL_CODE_2</property>
<property name="analysis">dimension</property>
<text-property name="heading">QUAL_CODE_2</text-property>
</structure>
<structure>
<property name="columnName">CAT_CD_2</property>
<property name="analysis">dimension</property>
<text-property name="heading">CAT_CD_2</text-property>
</structure>
<structure>
<property name="columnName">PROC_ONE_2</property>
<property name="analysis">dimension</property>
<text-property name="heading">PROC_ONE_2</text-property>
</structure>
<structure>
<property name="columnName">PROC_TWO_2</property>
<property name="analysis">dimension</property>
<text-property name="heading">PROC_TWO_2</text-property>
</structure>
<structure>
<property name="columnName">MAIL_CODE_2</property>
<property name="analysis">dimension</property>
<text-property name="heading">MAIL_CODE_2</text-property>
</structure>
<structure>
<property name="columnName">COMD_LINE_2</property>
<property name="analysis">dimension</property>
<text-property name="heading">COMD_LINE_2</text-property>
</structure>
<structure>
<property name="columnName">ADD_LINE1_2</property>
<property name="analysis">dimension</property>
<text-property name="heading">ADD_LINE1_2</text-property>
</structure>
<structure>
<property name="columnName">ADD_LINE2_2</property>
<property name="analysis">dimension</property>
<text-property name="heading">ADD_LINE2_2</text-property>
</structure>
<structure>
<property name="columnName">ADD_LINE3_2</property>
<property name="analysis">dimension</property>
<text-property name="heading">ADD_LINE3_2</text-property>
</structure>
<structure>
<property name="columnName">ADD_LINE4_2</property>
<property name="analysis">dimension</property>
<text-property name="heading">ADD_LINE4_2</text-property>
</structure>
<structure>
<property name="columnName">ADD_LINE5_2</property>
<property name="analysis">dimension</property>
<text-property name="heading">ADD_LINE5_2</text-property>
</structure>
<structure>
<property name="columnName">ADD_LINE6_2</property>
<property name="analysis">dimension</property>
<text-property name="heading">ADD_LINE6_2</text-property>
</structure>
<structure>
<property name="columnName">ACC_CODE_2</property>
<property name="analysis">dimension</property>
<text-property name="heading">ACC_CODE_2</text-property>
</structure>
<structure>
<property name="columnName">M3_CODE_2</property>
<property name="analysis">dimension</property>
<text-property name="heading">M3_CODE_2</text-property>
</structure>
<structure>
<property name="columnName">CHG_CUST_2</property>
<property name="analysis">dimension</property>
<text-property name="heading">CHG_CUST_2</text-property>
</structure>
<structure>
<property name="columnName">LAB_TYPE_CD_2</property>
<property name="analysis">dimension</property>
<text-property name="heading">LAB_TYPE_CD_2</text-property>
</structure>
<structure>
<property name="columnName">ZIP_CODE_2</property>
<property name="analysis">dimension</property>
<text-property name="heading">ZIP_CODE_2</text-property>
</structure>
<structure>
<property name="columnName">LAB_CORR_2</property>
<property name="analysis">dimension</property>
<text-property name="heading">LAB_CORR_2</text-property>
</structure>
<structure>
<property name="columnName">LAB2_2</property>
<property name="analysis">dimension</property>
<text-property name="heading">LAB2_2</text-property>
</structure>
<structure>
<property name="columnName">LAB3_2</property>
<property name="analysis">dimension</property>
<text-property name="heading">LAB3_2</text-property>
</structure>
</list-property>
<list-property name="parameters"/>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">SERVICED_LAB</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CUSTOMER_ID</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">MODEL_NO</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">SERIAL_NO</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">ECN</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">NOMENCLATURE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">SUB_CUSTODIAN</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">SCHED_LAB</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">METRL_CYCLE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">MFR_CD</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">UIC</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">PROCEDURE_USED</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">VALUE_FIXED</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">NSN</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">PART_OF</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">ON_SITE_SERVICE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">CAL_STD</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">SERVICE_LABEL_CD</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">19</property>
<property name="name">PLANT_ACCT</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">20</property>
<property name="name">SCAT_CD</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">21</property>
<property name="name">PHASE_ID</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">22</property>
<property name="name">APPROVED_PROCEDURE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">23</property>
<property name="name">INV_SHOP_NO</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">24</property>
<property name="name">CLASS_STD</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">25</property>
<property name="name">TYPE_STD</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">26</property>
<property name="name">WIP_STATUS</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">27</property>
<property name="name">EQPMT_TYPE_CD</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">28</property>
<property name="name">ICN</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">29</property>
<property name="name">PRINT_METERCARD_FLG</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">30</property>
<property name="name">EQPMT_STATUS_CD</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">31</property>
<property name="name">DELAY_REASON_CD</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">32</property>
<property name="name">CONDITION_RECEIVED</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">33</property>
<property name="name">SPCL_INSTR_CD</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">34</property>
<property name="name">WORKLOAD_NORM_HRS</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">35</property>
<property name="name">BIN_LOCATION</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">36</property>
<property name="name">DT_SYS</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">37</property>
<property name="name">DT_RCVD</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">38</property>
<property name="name">DT_INDUCT</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">39</property>
<property name="name">DT_DELAY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">40</property>
<property name="name">DT_REPTD</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">41</property>
<property name="name">DT_LSTCAL</property>
<property name="dataType">date</property>
</structure>
<structure>
<property name="position">42</property>
<property name="name">DT_NXT_DUE</property>
<property name="dataType">date</property>
</structure>
<structure>
<property name="position">43</property>
<property name="name">DT_RECALL</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">44</property>
<property name="name">DT_CMPL</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">45</property>
<property name="name">DT_CREATE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">46</property>
<property name="name">COST</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">47</property>
<property name="name">CAT_CUS</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">48</property>
<property name="name">CAT_LAB</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">49</property>
<property name="name">LAB_TYPE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">50</property>
<property name="name">ACC_CODE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">51</property>
<property name="name">FLAG_OFFLN</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">52</property>
<property name="name">SITEID</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">53</property>
<property name="name">RCD_STA</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">54</property>
<property name="name">RCD_TYPE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">55</property>
<property name="name">CUSTOMER</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">56</property>
<property name="name">UIC_1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">57</property>
<property name="name">QUAL_CODE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">58</property>
<property name="name">CAT_CD</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">59</property>
<property name="name">PROC_ONE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">60</property>
<property name="name">PROC_TWO</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">61</property>
<property name="name">MAIL_CODE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">62</property>
<property name="name">COMD_LINE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">63</property>
<property name="name">ADD_LINE1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">64</property>
<property name="name">ADD_LINE2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">65</property>
<property name="name">ADD_LINE3</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">66</property>
<property name="name">ADD_LINE4</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">67</property>
<property name="name">ADD_LINE5</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">68</property>
<property name="name">ADD_LINE6</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">69</property>
<property name="name">ACC_CODE_1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">70</property>
<property name="name">M3_CODE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">71</property>
<property name="name">CHG_CUST</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">72</property>
<property name="name">LAB_TYPE_CD</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">73</property>
<property name="name">ZIP_CODE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">74</property>
<property name="name">LAB_CORR</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">75</property>
<property name="name">LAB2</property>
rushtonjj
I managed to get my report running. It was issues with how I had my naming conventions set up. I'm very happy with BIRT. It is less cumbersome than Jasper.