Editing MS12001
Template Fileswww.jgroptics.com

Editing MS12001 Template Files
How to use ComponentOne Studio VSView Reporting Edition:• Go to ‘Start’ -> ‘All Programs’ -> ComponentOne Studio -> VSVIEW 8.0 > Reporting Edition -> Report Designer• This will open up the window below, double-click vsrpt8.exe

www.jgroptics.com

Editing MS12001 Template Files
Open Windows Explorer and press ‘Alt’ to show the menu bar• Click ‘Tools->’Folder Options->View’• Check the button beside ‘Show hidden files..’ (this only needsto be done once). Then Click ‘ok’.
In VSReport click ‘Open’ and browse to the following location:• C:\ProgramData\JGR\MS12001\Templates• Scroll until you find Report.xml and click Open.

www.jgroptics.com

Editing MS12001 Template Files
Double click ‘Tabular Report Standard’ and then click on the‘Design’ icon to start editing that template.

www.jgroptics.com

Editing MS12001 Template Files
This brings up the design window.

www.jgroptics.com

Editing MS12001 Template Files

Note that there are ‘Headers’ and ‘Details’:• Headers have the ‘Calculated’ property ‘False’and Details have the ‘Calculated’ property ‘True’.
• Headers will be displayed on the report as they
are written in the designer.
• Details will pull specific data from the databaseand display that on the final report instead.
To edit a detail, double click on it to bring up the‘Field Properties’ (shown left).
• A non-exhaustive list of possible ‘details’ isshown on the next slide.

www.jgroptics.com

Editing MS12001 Template Files
Possible Data Fields:• [Fixed Serial Number]• [Incremental Serial Number]• [Wavelength 1]• [Wavelength 2]• [Measurement Date]• [Fiber Number]• [IL Wavelength 1]• [IL Wavelength 2]• [IL EndA Wavelength 1]• [IL EndA Wavelength 2]• [IL EndB Wavelength 1]• [IL EndB Wavelength 2]• [IL Status]• [IL]• [IL EndA]• [IL EndA Status]• [Reflectance Wavelength 1]• [Reflectance Wavelength 2]• [Reflectance EndA Wavelength 1]• [Reflectance EndA Wavelength 2]• [Reflectance EndB Wavelength 1]• [Reflectance EndB Wavelength 2]• [Reflectance Status]• [Reflectance]
www.jgroptics.com• [Reflectance EndA Status]• [Reflectance EndB Status]• [Custom Field 1]• [Custom Field 2]• [Custom Field 3]• [Custom Title 1]• [Custom Title 2]• [Custom Title 3]• [Customer Name]• [Operator Name]• [Test Name]• [Test Type]• [Test Reflectance]• [Test IL]• [DUT Description]• [DUT Length]• [DUT Part Number]• [DUT Manufacturer]• [DUT Mode]• [DUT Device Type]• [DUT Mandrel-Free]• [Workstation ID]• [Global Test Status]• [EndA Connector Name]• [EndA IL Pass Limit]• [EndA IL Warning Limit]• [EndA Reflectance Pass Limit]• [EndA Reflectance WarningLimit]• [EndB Connector Name]• [EndB IL Pass Limit]• [EndB IL Warning Limit]• [EndB Reflectance Pass Limit]• [EndB Reflectance WarningLimit]

Editing MS12001 Template Files
The Text fields work with simple Visual Basic (VB6) commands. For example,to set up the detail ‘Serial Number’, double click on the appropriate text field tobring up the ‘Field Properties’ box.

www.jgroptics.com

Editing MS12001 Template Files
Now we can edit the ‘Text’ using VisualBasic to do some logic and formatting.
The current text field contains thecommand:IIf([Fixed Serial Number] = "", [Incremental
Serial Number], [Fixed Serial Number] & "-"& [Incremental Serial Number])
Here we are saying If the database field[Fixed Serial Number] is nothing (“”) thenjust use the database field [Incremental
Serial Number]. Otherwise use the Fixedand Incremental Serial Numbers (&).

www.jgroptics.com

Editing MS12001 Template Files• Let’s assume we want to add a field for ‘Operator Name’.
• To do this we must first make some space on the report. Drag a box aroundeverything past the ‘Part Number’ field to select it.
• Now click and drag the selection to the right so it looks like the picture below.
We now have some space between ‘Part number’ and ‘Serial Number’.

www.jgroptics.com

Editing MS12001 Template Files
Insert a new Label in the blank space by selecting the ‘Label’command in the toolbar and then drawing the label to theappropriate size.

www.jgroptics.com

Editing MS12001 Template Files• Double-click on the new label andedit the ‘Text’ field to say ‘OperatorName’.
• Note that the ‘Calculated’ field is setto false since this is just a label.

www.jgroptics.com

Editing MS12001 Template Files• Now go to the ‘Details’section and insert
another label asshown.
• Bring up the properties
window by doubleclicking and changethe ‘Text’ field to[Operator Name] andthe ‘Calculated’ field to‘True’

www.jgroptics.com

Editing MS12001 Template Files
We have now successfully added a new field to the report. Unfortunately this also
pushes the last field off the page. (The page is as wide as the ‘Test report’ bar)
To rectify this simply shrink the size of the ‘Part number’ and ‘Serial Number’ fields.
Then move the fields so they are all adjacent as shown below.

www.jgroptics.com

Editing MS12001 Template Files
Finally, save the new report into the same folder as the original
template.
(File-> Save As)

The new report template is now available to select in the MS12001
software.
www.jgroptics.com