1. Edit the XML configuration for the Order Item Detail report:
i. Open the
<WC_installdir>\xml\tools\reporting\OrderItemDetailReport.xml file
for editing.
ii. Search for the following section, and add the lines detailed in
red . Ensure that the added entry in the 'select' statement has its
corresponding table in the 'from' clause.
<Reporting>
<Report reportName="OrderItemDetailReport" online="true"
>
<comment></comment>
<SQLvalue>
select
catentry.partnumber,
catentdesc.name,
$DB_DATE_FUNC(estavailtime)$,
ffmcentds.displayname,
fulfillmentstatus,
inventorystatus,
$DB_DATE_FUNC(lastcreate)$,
quantity
from orderitems,
catentry,
catentdesc,
ffmcentds
where orders_id = {Orders_id}
and
catentdesc.catentry_id =
orderitems.catentry_id
and
catentry.catentry_id =
orderitems.catentry_id
and
catentdesc.language_id = {LanguageID}
and
ffmcentds.ffmcenter_id =
orderitems.ffmcenter_id
and
ffmcentds.language_id = {LanguageID}
</SQLvalue>
iii. Search for the following section near the end and make the changes
detailed in red.
Ensure that you add 1 to each <columnKey> for the
other columns.
Ensure that the columns below correspond to the correct order that fields
will be returned from the SELECT statement above. That is, since
catentry.partnumber is added as the first element in our SELECT statement,
it must also be the first column in the table below.
<columns>
<columnKey>C0</columnKey>
<columnName>OrderItemDetailReportPartNumber</columnName>
<columnType>string</columnType>
<columnOptions>ALIGN=LEFT HEIGHT=20
NOWRAP</columnOptions>
</columns>
<columns>
<columnKey>C1</columnKey>
<columnName>OrderItemDetailReportCatentry</columnName>
<columnType>string</columnType>
<columnOptions>ALIGN=LEFT HEIGHT=20
NOWRAP</columnOptions>
</columns>
<columns>
<columnKey>C2</columnKey>
<columnName>OrderItemDetailReportAvailTime</columnName>
<columnType>date</columnType>
<columnOptions>ALIGN=LEFT HEIGHT=20
NOWRAP</columnOptions>
</columns>
<columns>
<columnKey>C3</columnKey>
<columnName>OrderItemDetailReportFMCenter</columnName>
<columnType>string</columnType>
<columnOptions>ALIGN=LEFT HEIGHT=20
NOWRAP</columnOptions>
</columns>
<columns>
<columnKey>C4</columnKey>
<columnName>OrderItemDetailReportFMStatus</columnName>
<columnType>string</columnType>
<columnOptions>ALIGN=LEFT HEIGHT=20
NOWRAP</columnOptions>
</columns>
<columns>
<columnKey>C5</columnKey>
<columnName>OrderItemDetailReportInvenStatus</columnName>
<columnType>string</columnType>
<columnOptions>ALIGN=LEFT HEIGHT=20
NOWRAP</columnOptions>
</columns>
<columns>
<columnKey>C6</columnKey>
<columnName>OrderItemDetailReportTimeCreated</columnName>
<columnType>date</columnType>
<columnOptions>ALIGN=LEFT HEIGHT=20
NOWRAP</columnOptions>
</columns>
<columns>
<columnKey>C7</columnKey>
<columnName>OrderItemDetailReportQuantity</columnName>
<columnType>decimal</columnType>
<columnOptions>ALIGN=LEFT HEIGHT=20
NOWRAP</columnOptions>
</columns>
</userDefinedParameters>
2. Edit the properties file for reports:
i. Open the
<WAS_installdir>\installedApps\<nodename>\WC_<instance>.ear\properties\com\ibm\commerce\tools\reporting\properties\Reports_en_US.properties
file for editing.
ii. Look for the following section and add in the last line to define the
column heading that will be displayed in the table:
# Report output - input criteria
OrderItemDetailReportOutputViewTitle=Order Item Details
Report
OrderItemDetailReportOutputViewRunDateTitle=Order Item Details
Report:
OrderItemDetailReportCatentry=Ordered Item
OrderItemDetailReportAvailTime=Estimated Availability
Date
OrderItemDetailReportFMCenter=Fulfillment
Center
OrderItemDetailReportFMStatus=Fulfillment
Status
OrderItemDetailReportInvenStatus=Inventory
Status
OrderItemDetailReportTimeCreated=Time Orderitem
created
OrderItemDetailReportQuantity=Ouantity
Ordered
OrderItemDetailReportTitle=Order Item Details
Report
OrderItemDetailReportPartNumber=Part Number
|
Segment
| Product
| Component
| Platform
| Version
| Edition
|
Commerce
| WebSphere Commerce Enterprise
| Customization / Application Development
| AIX, i5/OS, Linux, Linux iSeries, Linux pSeries, Linux xSeries, Linux
zSeries, Solaris, Windows, OS/400
| 6.0
|
|
Commerce
| WebSphere Commerce Business Edition
| | AIX, i5/OS, Linux, Linux iSeries, Linux pSeries, Linux xSeries, Linux
zSeries, Solaris, Windows, OS/400
| 6.0
|
|
Commerce
| WebSphere Commerce - Express
| Customization / Application Development
| AIX, i5/OS, Linux, Linux iSeries, Linux pSeries, Linux xSeries, Linux
zSeries, Solaris, Windows, OS/400
| 6.0
|
|
Commerce
| WebSphere Commerce Professional
| Customization / Application Development
| AIX, i5/OS, Linux, Linux iSeries, Linux pSeries, Linux xSeries, Linux
zSeries, Solaris, Windows, OS/400
| 6.0
|
|
Commerce
| WebSphere Commerce Developer Enterprise
| Customization / Application Development
| AIX, i5/OS, Linux, Linux iSeries, Linux pSeries, Linux xSeries, Linux
zSeries, Solaris, Windows, OS/400
| 6.0
|
|
Commerce
| WebSphere Commerce Developer Business Edition
| Customization / Application Development
| AIX, i5/OS, Linux, Linux iSeries, Linux pSeries, Linux xSeries, Linux
zSeries, Solaris, Windows, OS/400
| 6.0
|
|
Commerce
| WebSphere Commerce Developer Professional
| Customization / Application Development
| AIX, i5/OS, Linux, Linux iSeries, Linux pSeries, Linux xSeries, Linux
zSeries, Solaris, Windows, OS/400
| 6.0
|
|
Commerce
| WebSphere Commerce Developer Express
| Customization / Application Development
| AIX, i5/OS, Linux, Linux iSeries, Linux pSeries, Linux xSeries, Linux
zSeries, Solaris, Windows, OS/400
| 6.0
|
|
Commerce
| WebSphere Commerce Business Edition
| Customization / Application Development
| AIX, i5/OS, Linux, Linux iSeries, Linux pSeries, Linux xSeries, Linux
zSeries, Solaris, Windows
| 5.6, 5.6.1
| Business Edition
|
|
Current web document: http://www.ibm.com/support/docview.wss?uid=swg21247526
|