[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Newsgroup Home]
|
[news.eclipse.birt] Re: Functions in beforeFactory not available in JBOSS
|
- From: mreynolds@xxxxxxxxxxxxxxxx (Mike )
- Date: Mon, 3 Nov 2008 19:40:07 +0000 (UTC)
- Newsgroups: eclipse.birt
- Organization: Eclipse
- User-agent: NewsPortal/0.36 (http://florian-amrhein.de/newsportal)
<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design"; version="3.2.16"
id="1">
<property name="createdBy">Eclipse BIRT Designer Version
2.3.0.v20080606 Build <2.3.0.v20080618-0630></property>
<property name="units">in</property>
<property name="comments">Copyright (c) 2007 <<Your Company Name
here>></property>
<html-property name="description">Creates a blank report with no
predefined content.</html-property>
<method
name="initialize"><![CDATA[importPackage(Packages.java.util.logging);
importPackage(Packages.logging);
var fileHandler = new FileHandler("javascript.log", false);
fileHandler.setFormatter(new SimpleFormatter());
var rootLogger = Logger.getLogger("");
rootLogger.addHandler(fileHandler);
function log ( str ){
Logger.getAnonymousLogger().info(str);
}
reportContext.setPersistentGlobalVariable("log", log);
log("Initialize");]]></method>
<method name="beforeFactory"><![CDATA[importPackage(
Packages.javax.xml.parsers);
importPackage( Packages.org.xml.sax);
importPackage( Packages.org.w3c.dom);
importPackage( Packages.java.io);
function findFirstNodeByAttrib(node_list, attribute, expected_value){
node_count = node_list.getLength()
ret = null
for(i=0; i<node_count; i++){
node = node_list.item(i)
if(node.getAttribute(attribute).toString() == expected_value){
return node
}
}
}
function buildDocFromXML(xml_string){
factory = DocumentBuilderFactory.newInstance();
builder = factory.newDocumentBuilder();
return builder.parse( new InputSource( new StringReader( xml_string )) );
}
function getTagValue(xml_string, node_type, identifying_attrib,
identifying_attrib_value) {
document = buildDocFromXML(xml_string)
node_list = document.getElementsByTagName(node_type);
if(node_list != null){
node = findFirstNodeByAttrib(node_list, identifying_attrib,
identifying_attrib_value)
return node.getAttribute("value")//node.getValue().toString()
}
}
//o Manufacturer, Lot #, expiration date from med completion outline
function getManufacturer(xml_string){
document = buildDocFromXML(xml_string);
node_list = document.getElementsByTagName("item");
item_count = node_list.getLength();
//log("itemcount="+item_count);
for(i=0; i<item_count; i++){
item_node = node_list.item(i);
//log("item_node="+item_node+"item_node name="+getName(item_node)+" item
node selected="+item_node.getAttribute("selected"));
parent_node = item_node.getParentNode();
//log("parent=" + parent_node+" parent name="+getName(parent_node));
if(getName(parent_node)=="Manufacturer" &&
item_node.getAttribute("selected")=="true"){
return getName(item_node);
}
}
}
function getLotNumber(xml_string){
return getTagValue(xml_string, "WORD", "name", "Lot Number")
}
function getExpirationDate(xml_string){
return getTagValue(xml_string, "DATE", "name", "Expiration Date")
}
function getImmAdministrator(xml_string){
return getTagValue(xml_string, "WORD", "name", "personAdministeringMed")
}
function getName(node){
return node.getAttribute("name")
}]]></method>
<method name="afterFactory"><![CDATA[var hdls =
Logger.getLogger("").getHandlers();
for (i = 0; i < hdls.length; i++)
{
Logger.getLogger("").removeHandler(hdls[i]);
hdls[i].close();
}]]></method>
<property name="theme">NW-General.NW Report - Display</property>
<text-property name="displayName">Blank Report</text-property>
<property name="iconFile">/templates/blank_report.gif</property>
<list-property name="libraries">
<structure>
<property name="fileName">NW-General.rptlibrary</property>
<property name="namespace">NW-General</property>
</structure>
</list-property>
<parameters>
<scalar-parameter name="StartDate" id="310">
<property name="valueType">static</property>
<property name="dataType">dateTime</property>
<property name="paramType">simple</property>
<text-property name="promptText">Start Date</text-property>
<property name="concealValue">false</property>
<property name="isRequired">true</property>
<property name="controlType">text-box</property>
<property name="defaultValue">1900-01-01 00:00:00</property>
<property name="distinct">true</property>
<structure name="format">
<property name="category">Custom</property>
<property name="pattern">MM/dd/yyyy hh:mm:ss</property>
</structure>
</scalar-parameter>
<scalar-parameter name="EndDate" id="311">
<property name="valueType">static</property>
<property name="dataType">dateTime</property>
<property name="paramType">simple</property>
<text-property name="promptText">End Date</text-property>
<property name="concealValue">false</property>
<property name="isRequired">true</property>
<property name="controlType">text-box</property>
<property name="defaultValue">2100-01-01 00:00:00</property>
<property name="distinct">true</property>
<structure name="format">
<property name="category">Custom</property>
<property name="pattern">MM/dd/yyyy hh:mm:ss</property>
</structure>
</scalar-parameter>
<scalar-parameter name="Authorizing Provider" id="314">
<property name="valueType">dynamic</property>
<property name="dataType">decimal</property>
<property name="controlType">list-box</property>
<property name="dataSetName">ProviderList</property>
<expression name="valueExpr">dataSetRow["PRO_ID"]</expression>
<expression
name="labelExpr">dataSetRow["PRO_NAME"]</expression>
<property name="mustMatch">true</property>
<property name="fixedOrder">false</property>
<property name="defaultValue">0</property>
<property name="distinct">false</property>
<property name="sortBy">label</property>
<property name="sortDirection">asc</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="Site" id="316">
<property name="valueType">dynamic</property>
<property name="dataType">decimal</property>
<text-property name="promptText">Site</text-property>
<property name="controlType">list-box</property>
<property name="dataSetName">SiteList</property>
<expression
name="valueExpr">dataSetRow["PRAC_LOC_ID"]</expression>
<expression
name="labelExpr">dataSetRow["DISPLAYNAME"]</expression>
<property name="mustMatch">true</property>
<property name="fixedOrder">false</property>
<property name="defaultValue">0</property>
<property name="distinct">false</property>
<property name="sortBy">label</property>
<property name="sortDirection">asc</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="NW Reporting DB"
id="6"
extends="NW-General.NW Reporting DB"/>
</data-sources>
<data-sets>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet"
name="ProviderList" id="313">
<list-property name="columnHints">
<structure>
<property name="columnName">PRO_ID</property>
<property name="displayName">PRO_ID</property>
</structure>
<structure>
<property name="columnName">PRO_NAME</property>
<property name="displayName">PRO_NAME</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">PRO_ID</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">PRO_NAME</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">NW Reporting DB</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">PRO_ID</property>
<property name="nativeName">PRO_ID</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">2</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">PRO_NAME</property>
<property name="nativeName">PRO_NAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<property name="queryText">select pro.PRO_ID,
pro.LAST_NAME+', '+pro.FIRST_NAME as PRO_NAME
from NWRptUsr.NW_PROVIDERS pro
where PRO_ACCESS_LEVEL <> 'Admin'</property>
</oda-data-set>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet"
name="SiteList" id="315">
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">PRAC_LOC_ID</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">DISPLAYNAME</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">NW Reporting DB</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">PRAC_LOC_ID</property>
<property name="nativeName">PRAC_LOC_ID</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">2</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">DISPLAYNAME</property>
<property name="nativeName">DISPLAYNAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<property name="queryText">select PRAC_LOC_ID, DISPLAYNAME
from NWRptUsr.NW_PRAC_LOC_INDEX
where DISPLAYNAME <> 'Unknown'</property>
</oda-data-set>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet"
name="RX" id="358">
<list-property name="computedColumns">
<structure>
<property name="name">MedType</property>
<expression name="expression">if(row["order_type"] ==
""){
"RX"
}else{
row["order_type"]
}</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<list-property name="columnHints">
<structure>
<property name="columnName">order_date</property>
<property name="displayName">order_date</property>
</structure>
<structure>
<property name="columnName">pat_name</property>
<property name="displayName">pat_name</property>
</structure>
<structure>
<property name="columnName">mrn</property>
<property name="displayName">mrn</property>
</structure>
<structure>
<property name="columnName">address</property>
<property name="displayName">address</property>
</structure>
<structure>
<property name="columnName">dob</property>
<property name="displayName">dob</property>
</structure>
<structure>
<property name="columnName">med_desc</property>
<property name="displayName">med_desc</property>
</structure>
<structure>
<property name="columnName">quantity</property>
<property name="displayName">quantity</property>
</structure>
<structure>
<property name="columnName">refills</property>
<property name="displayName">refills</property>
</structure>
<structure>
<property name="columnName">instr</property>
<property name="displayName">instr</property>
</structure>
<structure>
<property name="columnName">disposition</property>
<property name="displayName">disposition</property>
</structure>
<structure>
<property name="columnName">order_auth</property>
<property name="displayName">order_auth</property>
</structure>
<structure>
<property name="columnName">site_id</property>
<property name="displayName">site_id</property>
</structure>
<structure>
<property name="columnName">order_type</property>
<property name="displayName">order_type</property>
</structure>
<structure>
<property name="columnName">pro_name</property>
<property name="displayName">pro_name</property>
</structure>
<structure>
<property name="columnName">history_xml</property>
<property name="displayName">history_xml</property>
</structure>
<structure>
<property name="columnName">exam_xml</property>
<property name="displayName">exam_xml</property>
</structure>
</list-property>
<list-property name="filter">
<structure>
<property name="operator">is-true</property>
<expression name="expr">if (params["Authorizing
Provider"] == 0){
true
}
else{
params["Authorizing Provider"] == row["order_auth"]
}</expression>
<simple-property-list name="value1"/>
</structure>
<structure>
<property name="operator">is-true</property>
<expression name="expr">if (params["Site"] == 0){
true
}
else{
params["Site"] == row["site_id"]
}</expression>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">order_date</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">pat_name</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">mrn</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">address</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">dob</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">med_desc</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">quantity</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">refills</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">instr</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">disposition</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">order_auth</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">site_id</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">order_type</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">pro_name</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">history_xml</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">exam_xml</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">MedType</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">NW Reporting DB</property>
<list-property name="parameters">
<structure>
<property name="name">param_1</property>
<property name="paramName">StartDate</property>
<property name="nativeName"></property>
<property name="dataType">dateTime</property>
<property name="nativeDataType">1</property>
<property name="position">1</property>
<property name="isOptional">false</property>
<property name="allowNull">false</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param_2</property>
<property name="paramName">EndDate</property>
<property name="nativeName"></property>
<property name="dataType">dateTime</property>
<property name="nativeDataType">1</property>
<property name="position">2</property>
<property name="isOptional">false</property>
<property name="allowNull">false</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">order_date</property>
<property name="nativeName">order_date</property>
<property name="dataType">date-time</property>
<property name="nativeDataType">93</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">pat_name</property>
<property name="nativeName">pat_name</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">mrn</property>
<property name="nativeName">mrn</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">address</property>
<property name="nativeName">address</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">dob</property>
<property name="nativeName">dob</property>
<property name="dataType">date-time</property>
<property name="nativeDataType">93</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">med_desc</property>
<property name="nativeName">med_desc</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">quantity</property>
<property name="nativeName">quantity</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">refills</property>
<property name="nativeName">refills</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">instr</property>
<property name="nativeName">instr</property>
<property name="dataType">string</property>
<property name="nativeDataType">2005</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">disposition</property>
<property name="nativeName">disposition</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">order_auth</property>
<property name="nativeName">order_auth</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">2</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">site_id</property>
<property name="nativeName">site_id</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">2</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">order_type</property>
<property name="nativeName">order_type</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">pro_name</property>
<property name="nativeName">pro_name</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">history_xml</property>
<property name="nativeName">history_xml</property>
<property name="dataType">string</property>
<property name="nativeDataType">2005</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">exam_xml</property>
<property name="nativeName">exam_xml</property>
<property name="dataType">string</property>
<property name="nativeDataType">2005</property>
</structure>
</list-property>
<property name="queryText">select ORDERED_DATE_TIME as
order_date,
pat.LAST_NAME+', '+pat.FIRST_NAME as pat_name,
pat.pid as mrn,
pat.HOME_ADDRESS1+' '+pat.HOME_ADDRESS2+', '+pat.HOME_CITY+',
'+pat.HOME_STATE+' '+pat.HOME_ZIP_CODE as address,
pat.DATE_OF_BIRTH_TIME as dob,
med.DESCRIPTION as med_desc,
MED_QUANTITY as quantity,
MED_REFILL_COUNT as refills,
MED_SIG as instr,
med.DISPOSITION as disposition,
ORDER_AUTHORIZER_ID as order_auth,
ENC_SITE_ID as site_id,
ORDER_TYPE as order_type,
pro.prefix+' '+pro.last_name+', '+pro.first_name as pro_name,
history_xml,
exam_xml
from nwrptusr.nw_medications med,
nwrptusr.nw_patients pat,
nwrptusr.nw_encounter enc,
nwrptusr.nw_providers pro,
nwrptusr.nw_order_outline_info oi,
nwrptusr.nw_order_outline_data od
where med.patient_id = pat.pat_id
and med.orig_enc_id = enc.enc_id
and pro.pro_id = order_authorizer_id
and oi.med_id = med.med_id
and oi.oi_id = od.outline_id
and order_type = 'Samples'
and ordered_date_time between ? and ?</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>1.0</Version>
<design:DataSetParameters>
<design:parameterDefinitions>
<design:inOutMode>In</design:inOutMode>
<design:attributes>
<design:name></design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>1</design:nativeDataTypeCode>
<design:precision>38</design:precision>
<design:scale>0</design:scale>
<design:nullability>Unknown</design:nullability>
</design:attributes>
</design:parameterDefinitions>
<design:parameterDefinitions>
<design:inOutMode>In</design:inOutMode>
<design:attributes>
<design:name></design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>1</design:nativeDataTypeCode>
<design:precision>38</design:precision>
<design:scale>0</design:scale>
<design:nullability>Unknown</design:nullability>
</design:attributes>
</design:parameterDefinitions>
</design:DataSetParameters>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>order_date</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>93</design:nativeDataTypeCode>
<design:precision>23</design:precision>
<design:scale>3</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>order_date</design:label>
<design:formattingHints>
<design:displaySize>23</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>pat_name</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>512</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>pat_name</design:label>
<design:formattingHints>
<design:displaySize>512</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>mrn</design:name>
<design:position>3</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>255</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>mrn</design:label>
<design:formattingHints>
<design:displaySize>255</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>address</design:name>
<design:position>4</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>286</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>address</design:label>
<design:formattingHints>
<design:displaySize>286</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>dob</design:name>
<design:position>5</design:position>
<design:nativeDataTypeCode>93</design:nativeDataTypeCode>
<design:precision>23</design:precision>
<design:scale>3</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>dob</design:label>
<design:formattingHints>
<design:displaySize>23</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>med_desc</design:name>
<design:position>6</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>3000</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>med_desc</design:label>
<design:formattingHints>
<design:displaySize>3000</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>quantity</design:name>
<design:position>7</design:position>
<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>quantity</design:label>
<design:formattingHints>
<design:displaySize>50</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>refills</design:name>
<design:position>8</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>255</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>refills</design:label>
<design:formattingHints>
<design:displaySize>255</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>instr</design:name>
<design:position>9</design:position>
<design:nativeDataTypeCode>2005</design:nativeDataTypeCode>
<design:precision>2147483647</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>instr</design:label>
<design:formattingHints>
<design:displaySize>2147483647</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>disposition</design:name>
<design:position>10</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>20</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>disposition</design:label>
<design:formattingHints>
<design:displaySize>20</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
</data-sets>
<styles>
<style name="crosstab-cell" id="4">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
<style name="crosstab" id="5">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
</styles>
<page-setup>
<simple-master-page name="NW MasterPage" id="7"
extends="NW-General.NW MasterPage">
<property name="orientation">landscape</property>
<property name="topMargin">0.25in</property>
<property name="leftMargin">0.25in</property>
<property name="bottomMargin">0.25in</property>
<property name="rightMargin">0.25in</property>
<overridden-values>
<ref-entry baseId="25" name="HeaderGrid" id="25">
<property name="textAlign">right</property>
<property name="height">1.1145833333in</property>
<property name="width">8.8958333333in</property>
</ref-entry>
<ref-entry baseId="319" id="584"/>
<ref-entry baseId="82" id="82">
<property name="width">8.8958333333in</property>
</ref-entry>
<ref-entry baseId="129" id="129"/>
<ref-entry baseId="318" id="585"/>
<ref-entry baseId="144" id="144"/>
<ref-entry baseId="317" name="NewImage" id="317"/>
<ref-entry baseId="155" name="FooterGrid" id="155"/>
<ref-entry baseId="156" id="156"/>
<ref-entry baseId="321" id="321"/>
<ref-entry baseId="157" id="157"/>
<ref-entry baseId="158" id="158"/>
<ref-entry baseId="309" name="NewText" id="309"/>
<ref-entry baseId="320" id="586"/>
<ref-entry baseId="322" name="NewGrid" id="587"/>
<ref-entry baseId="334" id="588"/>
<ref-entry baseId="323" id="589"/>
<ref-entry baseId="324" id="324"/>
<ref-entry baseId="325" id="325"/>
<ref-entry baseId="326" id="590"/>
<ref-entry baseId="333" id="333"/>
<ref-entry baseId="335" name="NewLabel" id="591"/>
<ref-entry baseId="327" id="592"/>
<ref-entry baseId="328" name="NewAutoText" id="593"/>
<ref-entry baseId="329" id="329"/>
<ref-entry baseId="330" name="NewText1" id="594"/>
<ref-entry baseId="331" id="595"/>
<ref-entry baseId="332" name="NewAutoText1" id="596"/>
</overridden-values>
<property name="headerHeight">0.25in</property>
<property name="footerHeight">0.25in</property>
</simple-master-page>
</page-setup>
<body>
<table id="359">
<property name="width">10in</property>
<property name="dataSet">RX</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">order_date</property>
<expression
name="expression">dataSetRow["order_date"]</expression>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="name">pat_name</property>
<expression
name="expression">dataSetRow["pat_name"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">mrn</property>
<expression
name="expression">dataSetRow["mrn"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">address</property>
<expression
name="expression">dataSetRow["address"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">dob</property>
<expression
name="expression">dataSetRow["dob"]</expression>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="name">med_desc</property>
<expression
name="expression">dataSetRow["med_desc"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">quantity</property>
<expression
name="expression">dataSetRow["quantity"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">refills</property>
<expression
name="expression">dataSetRow["refills"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">instr</property>
<expression
name="expression">dataSetRow["instr"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">disposition</property>
<expression
name="expression">dataSetRow["disposition"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">order_auth</property>
<expression
name="expression">dataSetRow["order_auth"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">site_id</property>
<expression
name="expression">dataSetRow["site_id"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">order_type</property>
<expression
name="expression">dataSetRow["order_type"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">pro_name</property>
<expression
name="expression">dataSetRow["pro_name"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">history_xml</property>
<expression
name="expression">dataSetRow["history_xml"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">exam_xml</property>
<expression
name="expression">dataSetRow["exam_xml"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">MedType</property>
<expression
name="expression">dataSetRow["MedType"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">admin</property>
<property name="displayName">admin</property>
<expression
name="expression">getImmAdministrator(dataSetRow["history_xml"])</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">admin_pro</property>
<expression
name="expression">getImmAdministrator(dataSetRow["history_xml"])</expression>
</structure>
<structure>
<property name="name">auth_pro</property>
<expression
name="expression">dataSetRow["pro_name"]</expression>
</structure>
<structure>
<property name="name">lot_num</property>
<expression
name="expression">getLotNumber(dataSetRow["history_xml"])</expression>
<property name="dataType">any</property>
</structure>
<structure>
<property name="name">expr_date</property>
<expression
name="expression">getExpirationDate(dataSetRow["history_xml"])</expression>
</structure>
<structure>
<property name="name">manufacturer</property>
<expression
name="expression">getManufacturer(dataSetRow["history_xml"])</expression>
</structure>
</list-property>
<property name="pageBreakInterval">50</property>
<column id="387"/>
<column id="388"/>
<column id="389"/>
<column id="391">
<property name="width">1in</property>
</column>
<column id="556">
<property name="width">1in</property>
</column>
<header>
<row id="360">
<cell id="361">
<property name="colSpan">5</property>
<property name="rowSpan">1</property>
<grid id="318">
<property
name="borderBottomWidth">0px</property>
<property name="borderLeftWidth">0px</property>
<property
name="borderRightWidth">0px</property>
<property name="borderTopWidth">0px</property>
<property name="marginTop">0pt</property>
<property name="marginBottom">1mm</property>
<property name="width">10in</property>
<column id="319">
<property name="width">25%</property>
</column>
<column id="320">
<property name="width">25%</property>
</column>
<column id="343">
<property name="width">25%</property>
</column>
<column id="348">
<property name="width">25%</property>
</column>
<row id="322">
<cell id="323">
<property name="colSpan">4</property>
<property name="rowSpan">1</property>
<label id="334">
<property
name="backgroundColor">#FFFFFF</property>
<property
name="fontSize">x-large</property>
<property
name="fontWeight">bold</property>
<text-property
name="text">Medication Dispensing Report</text-property>
</label>
</cell>
</row>
<row id="326">
<cell id="327">
<label id="335">
<text-property name="text">Start
Date:</text-property>
</label>
</cell>
<cell id="328">
<data id="353">
<structure name="dateTimeFormat">
<property
name="category">Custom</property>
<property
name="pattern">MM/dd/yyyy hh:mm:ss</property>
</structure>
<list-property
name="boundDataColumns">
<structure>
<property
name="name">StartDate</property>
<expression
name="expression">params["StartDate"]</expression>
</structure>
</list-property>
<property
name="resultSetColumn">StartDate</property>
</data>
</cell>
<cell id="340">
<label id="349">
<text-property name="text">End
Date:</text-property>
</label>
</cell>
<cell id="345">
<data id="354">
<structure name="dateTimeFormat">
<property
name="category">Custom</property>
<property
name="pattern">MM/dd/yyyy hh:mm:ss</property>
</structure>
<list-property
name="boundDataColumns">
<structure>
<property
name="name">EndDate</property>
<expression
name="expression">params["EndDate"]</expression>
</structure>
</list-property>
<property
name="resultSetColumn">EndDate</property>
</data>
</cell>
</row>
<row id="330">
<cell id="331">
<label id="350">
<text-property
name="text">Provider:</text-property>
</label>
</cell>
<cell id="332">
<data id="355">
<list-property
name="boundDataColumns">
<structure>
<property
name="name">Authorizing Provider</property>
<expression
name="expression">if(params["Authorizing Provider"]==0){
"All"
}else{
params["Authorizing Provider"].displayText
}</expression>
<property
name="dataType">any</property>
</structure>
</list-property>
<property
name="resultSetColumn">Authorizing Provider</property>
</data>
</cell>
<cell id="341">
<label id="351">
<text-property
name="text">Site:</text-property>
</label>
</cell>
<cell id="346">
<data id="356">
<list-property
name="boundDataColumns">
<structure>
<property
name="name">Site</property>
<expression
name="expression">if(params["Site"]==0){
"All"
}else{
params["Site"].displayText
}</expression>
<property
name="dataType">any</property>
</structure>
</list-property>
<property
name="resultSetColumn">Site</property>
</data>
</cell>
</row>
</grid>
</cell>
</row>
</header>
<group id="445">
<property name="groupName">AdministeringProvider</property>
<property name="interval">none</property>
<property name="sortDirection">asc</property>
<expression name="keyExpr">row["pro_name"]</expression>
<structure name="toc">
<expression
name="expressionValue">row["pro_name"]</expression>
</structure>
<property name="repeatHeader">true</property>
<property name="hideDetail">false</property>
<property name="pageBreakAfter">always</property>
<property name="pageBreakBefore">auto</property>
<property name="pageBreakInside">auto</property>
<header>
<row id="446">
<cell id="447">
<property name="colSpan">5</property>
<property name="rowSpan">1</property>
<data id="458">
<property name="fontSize">medium</property>
<property name="fontWeight">bold</property>
<property
name="resultSetColumn">pro_name</property>
</data>
</cell>
</row>
</header>
<footer>
<row id="452">
<cell id="453">
<property name="drop">none</property>
<label id="492">
<text-property name="text">Provider
Signature:</text-property>
</label>
</cell>
<cell id="454">
<property name="colSpan">4</property>
<property name="rowSpan">1</property>
<label id="493">
<property
name="style">data-table</property>
<property
name="backgroundColor">#FFFFFF</property>
<property name="marginTop">0pt</property>
<text-property name="text">
</text-property>
</label>
</cell>
</row>
<row id="494">
<cell id="495">
<label id="597">
<text-property name="text">
</text-property>
</label>
</cell>
<cell id="496">
<property name="colSpan">4</property>
<property name="rowSpan">1</property>
<data id="500">
<property
name="fontSize">x-small</property>
<property
name="fontWeight">normal</property>
<property
name="resultSetColumn">pro_name</property>
</data>
</cell>
</row>
</footer>
</group>
<group id="472">
<property name="groupName">MedTypeGroup</property>
<property name="interval">none</property>
<property name="sortDirection">asc</property>
<expression name="keyExpr">row["MedType"]</expression>
<structure name="toc">
<expression
name="expressionValue">row["MedType"]</expression>
</structure>
<property name="repeatHeader">true</property>
<property name="hideDetail">false</property>
<property name="pageBreakAfter">auto</property>
<property name="pageBreakBefore">auto</property>
<property name="pageBreakInside">auto</property>
<header>
<row id="473">
<cell id="474">
<property name="colSpan">5</property>
<property name="rowSpan">1</property>
<data id="485">
<property
name="style">data-table-header</property>
<property name="fontSize">small</property>
<property name="fontWeight">bold</property>
<property name="textAlign">left</property>
<property
name="resultSetColumn">MedType</property>
</data>
</cell>
</row>
<row id="486">
<cell id="487">
<label id="395">
<text-property name="text">Order Date
Description</text-property>
</label>
</cell>
<cell id="488">
<label id="397">
<text-property name="text">Patient
Quantity</text-property>
</label>
</cell>
<cell id="489">
<label id="528">
<list-property name="visibility">
<structure>
<property
name="format">all</property>
<expression
name="valueExpr">row["MedType"]=="RX"</expression>
</structure>
</list-property>
<text-property name="text">MRN
Instructions</text-property>
</label>
</cell>
<cell id="491">
<label id="403">
<text-property name="text">DOB
Lot Number</text-property>
</label>
</cell>
<cell id="550">
<label id="557">
<text-property name="text">Manufacturer
Expiration Date</text-property>
</label>
</cell>
</row>
</header>
<footer>
<row id="479">
<cell id="480"/>
<cell id="481"/>
<cell id="482"/>
<cell id="484"/>
<cell id="553"/>
</row>
</footer>
</group>
<detail>
<row id="369">
<cell id="370">
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1px</property>
<data id="396">
<property
name="resultSetColumn">order_date</property>
</data>
</cell>
<cell id="371">
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1px</property>
<data id="398">
<property
name="resultSetColumn">pat_name</property>
</data>
</cell>
<cell id="372">
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1px</property>
<data id="400">
<property name="resultSetColumn">mrn</property>
</data>
</cell>
<cell id="374">
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1px</property>
<data id="404">
<property name="resultSetColumn">dob</property>
</data>
</cell>
<cell id="551">
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1px</property>
<data id="559">
<property
name="resultSetColumn">manufacturer</property>
</data>
</cell>
</row>
<row id="405">
<cell id="406">
<property
name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1px</property>
<data id="414">
<property name="textAlign">right</property>
<property
name="resultSetColumn">med_desc</property>
</data>
</cell>
<cell id="407">
<property
name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1px</property>
<data id="415">
<property
name="resultSetColumn">quantity</property>
</data>
</cell>
<cell id="408">
<property
name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1px</property>
<data id="417">
<property
name="resultSetColumn">instr</property>
</data>
</cell>
<cell id="410">
<property
name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1px</property>
<data id="546">
<property
name="resultSetColumn">lot_num</property>
</data>
</cell>
<cell id="552">
<property
name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1px</property>
<data id="558">
<property
name="resultSetColumn">expr_date</property>
</data>
</cell>
</row>
</detail>
</table>
</body>
</report>