WIP will bring a custom report which can include nesting features to you at the click of a button. You can easily view your data in custom defined dataset, sorted out by just the data you are interested in. Afterward, feel free to download your data to a spreadsheet or simply email it to yourself or others.
Configuration
Create a new Data Report Object. Following this, you can now choose the different configuration options for your oOnClick Data Report.
- Data Report Name: Parts In Flows - WIP
- Provide a name for this Report Object
- Data Report Number: DR14-000000003
- You can autogenerate the Report Number or type in your own manually.
- Revision: A
- Provide the revision value for this Data Report
- Description: This report will open a listbox that contains filtered Parts and Data Entry Values
- Optional: Describe what this Data Report is doing.
- Report Type: WIP
- select which type of Report Type you will be using.
- Report Defaults: false
- This pulls values from
- JSON Input Object: Download Sample JSON oOnClick Data
- This JSON input value tells the oOnClick function what data to display, filter, columns, etc. It is best to read the JSON Input Object explanation later in this help page.
JSON Input Object Example
You can download the sampel JSON oOnClick Data
Each WIP JSON Input Object will always contain the following objects.
- sTitle
- iReportTime
- bShowPrefix
- iLevelCollapsed
- sObjFlowName
- sObjPrefix
- bAddObjToTree
- bAddExcelParentColumns
- arGroupBy
- arCheckVals
- arColumns
- arHeaders
- oJobTypeCBg
Only the values of each of these attributes should change according to your report configuration.
Line 02: "sTitle": "Parts In Flow - WIP", Is the report main header text
Line 03: "iReportTime": 0, this value is in millisecond time. It is the snapshot of WIP report for that specified moment of time. 0 value is now.
Line 04: "bShowPrefix": true, Shows Prefix before the Item. i.e. FD, PR, etc
Line 05: "iLevelCollapsed": 10, Will initiate with this level opened. A value of 0 initiates will all items collapsed.
Line 06: "sObjFlowName": "PR_Flow", This is the main object that all attributes derive from
Line 07: "sObjPrefix": "PR", Prefix of main object. Two Character limit.
Line 08: "bAddObjToTree": true, Will add the main object to the tree for expanding. False will not display the main object as a tree.
Line 09: "bAddExcelParentColumns": false, Child excel sheet will include its parents columns based on this boolean.
Line 11-13: "arGroupBy": , This is an Array of items on how they will be grouped. You can add items to this for additional Trees,
i.e. {sNM, sPrefix, sTyp},{sNM, sPrefix, sTyp},{sNM, sPrefix, sTyp}, etc
- "sNM" = the EZ-MES Attribute name based on the Main Object.
- "sPrefix" = Prefix of this object. Two Character limit.
- "sTyp" = Jobname will convert the internal EZ-MES id into the
Line 15-20: "arCheckVals": , arCheckVals is an array of check vals. They are the query parameters for which data will be pulled from the PR_Flow.
Line 22-26: "arColumns": , This is an array of column data you want to add to the report.
- "iW" = width of column
- "sVal" = Column Header
- "sHA1" = Horizontal alignment of data.
- "sFW" = Font weight
- "sCBG" = background color
- "bTotal" = Sums the values from the count
- "sType" = used to configure the Number data type
- "sSpecialOperation" = Count is the operation needed for the sum
- "sTT" = tooltip display on mouseover
- "arJbConv" = Job Conversion may be needed to get nested attributes from the parent object.
Line 28-32: "arHeaders": , This is an array of column headers. They will be present over the arColumn data previously configured.
- "iW" = width of column
- "sVal" = Column Header
- "sHA1" = Horizontal alignment of data.
- "sFW" = Font weight
- "sCBG" = background color
Sample JSON Input Object Files
Executing the Data Report Object
There are a number of ways to perform the Data Report Execution of the Data Report Object.