View source for Adding Item Repair Equipment to Order Item Report

If you add the equipment on the Item Repair tab on an order, you can show that equipment on an Order Item Report.<br>
<br>

== Duplicate the Standard Order Ticket - Order Item report ==
<br>1. Go to '''Reports''' module > '''Customize reports'''
<br>2. Search the standard reports for the '''Standard Order Ticket - Order Item''' report.
<br>3. Click '''Duplicate Report.'''
<br>4. Enter a new '''short name''' for the report.
<br>5. Click '''Save'''
<br>6. Click '''Open Report Designer'''
<br>7. Click '''File''' > '''Save As'''
<br>8. In the '''File Name''' field, enter a name for the report and click '''Save'''.
<br>9. Close the Report Designer
<br>10. Click the box to the right of the '''filename''' field and select the file you saved in step 8 above.
<br>[[File:ReportFilenameField.png]]

== Edit the Details Specifier Tab ==
<br>1. Click the '''Detail Specifiers''' tab.
<br>2. In the '''Detail Table''' field, select '''Repairs'''. In the''' Detail Index''' field, select '''OrderUID'''. In the '''Master Table''' field, select '''UID''' (image below)
<br>[[File:DetailsSpecifierTab.png]]
<br>3. Click '''Accept'''.
<br>4. Click '''Save'''.


== Add the fields to the report ==
<br>1. Click '''Open Report Designer'''
<br>2. Expand the Group Footer section to make room for the repair equipment.
<br>[[File:GroupFooter.png]]
<br>3. Use the text tool to enter the labels as shown in the image below.
<br>[[File:RepairEQ_AddLabels.png]]
<br>4. Add the repair data (see image below)
<br> - 1. Click '''DBText''' tool (1 in image below)
<br> - 2. Click your cursor where you want the data field (2 in image below)
<br> - 3. Select '''Repairs''' in the upper left corner drop down (3 in image below)
<br> - 4. Select the data you want in the field you are working on (4 in image below) (e.g. ItemName, ItemDesc, SerialNumber, PartNumber)
<br>[[File:AddRepairData.png]]
<br>5. Add the rest of the equipment data.
<br>6. Click''' File''' > '''Save'''.