Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
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.