Reports Output

From UG

(Difference between revisions)
Jump to: navigation, search
("Add more flexibility" completed)
(Figures)
 
(32 intermediate revisions not shown)
Line 1: Line 1:
-
[[Category:Ops Reps Common]]
+
[[Category:OpsRepsMisc]]
== Info ==
== Info ==
Line 20: Line 20:
* Add checkbox on Output Tab provide this option.
* Add checkbox on Output Tab provide this option.
 +
=== BR: Add more flexibility ===
-
=== BR: Make ALL CT fields available for output and filtering  ===
+
* 1) add [[#Option for CT hyper link (BR)]] as an option for every report
 +
* 2) add [[#Lines Per CT Option (LIPCO)]] as an option for every report
-
* make ALL CT fields available for output and filtering:
+
== SD: Systems Design ==
-
** all [[CT]] fields
+
-
** all [[Commodity]] fields
+
-
** all [[Container]] fields
+
-
* should be done only for  [[CT based reports]]. We need this list by the way.
+
=== Standard User Interface ===
-
* How to group so many filters? Additional tabs? Groups on one tab?
+
==== Select From ====
-
** suggest solution
+
See [[#Figure 7. Output tab]]
-
* How to group or order them on Output Tab (Select From panel):
+
==== Selected List ====
-
** now they are not grouped / ordered and when we have a very long list this is an issue
+
See [[#Figure 7. Output tab]]
-
** now we need to select one at a time - this is too slow
+
-
** please suggest alternative designs so we can choose
+
-
* Internal vs Client:
+
=== Show Estimated Date if Actual Date is empty ===
-
** All fields should only be available for internal
+
In some reports we have only one column for given date instead of one for actual and one for estimated. In this case for some reports this logic is applied.
-
* see also [[#SD: Rules for labels]]
+
Example: if "Actual Delivery Date" is empty then display "Estimated Delivery Date" (under "Delivery Date" header)  
-
 
+
-
=== BR: Add more flexibility ===
+
-
 
+
-
* 1) add [[#Option for CT hyper link (BR)]] as an option for every report
+
-
* 2) add [[#Lines Per CT Option (LIPCO)]] as an option for every report
+
-
* 3) add option to turn off [[Hard Coded Conditions]] (or maybe even edit them)
+
-
 
+
-
== SD: Systems Design ==
+
=== Lines Per CT Option (LIPCO) ===
=== Lines Per CT Option (LIPCO) ===
Line 98: Line 87:
=== SD: Make ALL CT fields available for output and filtering ===
=== SD: Make ALL CT fields available for output and filtering ===
-
* Suggested to group all CT fields for filtering on the tabs of "All CT fields report" template. See [[#Figure 0. Main Form General Fields tab | Figure 0]] or [[http://64.115.223.6/proto/1998/MainFiltersWindow.zul ZUL-prototype]].
+
* Suggested to group all CT fields for filtering on the tabs of "All CT fields report" template. See [[#Figure 0. Main Form General Fields tab | Figure 0]].
-
** Non-CT fields that included to report grouped on "Non-CT Fields" tab.
+
* Non-CT fields that included to report grouped on "Non-CT Fields" tab.
-
** List of suggested tabs: "General Fields", "Commodity Fields", "Export/Import Fields", "Date Fields", "Non-CT Fields".
+
* List of suggested tabs for grouped fields: "General Fields", "Commodity Fields", "Export/Import Fields", "Date Fields", "Non-CT Fields".
-
*** List of fields for each tab:
+
* List of fields for each tab:
-
**** "General Fields" - [[TBD]], presumably all fields of [[http://mantis.jaguarfreight.com/wiki/CT_bo#General_Fields CT#GenTab]].
+
** '''General Fields''' - [[TBD]], presumably all fields of [[http://mantis.jaguarfreight.com/wiki/CT_bo#General_Fields CT#GenTab]].
-
**** "Commodity Fields" - [[TBD]], presumably all fields on GontTab of CT.
+
** '''Commodity Fields''' - [[TBD]], presumably all fields on [[http://mantis.jaguarfreight.com/wiki/CT_bo#Containers_and_Commodities CT#ContTab]] of CT.
-
**** "Export/Import Fields" - [[TBD]], presumably all fields of [[http://mantis.jaguarfreight.com/wiki/CT_bo#Export_Fields CT#ExpTab]] and [[http://mantis.jaguarfreight.com/wiki/CT_bo#Import_Fields CT#ImpTab]] exclude their Date Fields. This tab is allowed only for CT with appropriate MOT.
+
** '''Export Fields''' - [[TBD]], presumably all fields of [[http://mantis.jaguarfreight.com/wiki/CT_bo#Export_Fields CT#ExpTab]] exclude their Date Fields. This tab is allowed only for CT with appropriate MOT.
-
**** "Date Fields" - Time Frame, Estimated Pickup Date, Actual Pickup Date, Estimated Departure Date, Actual Departure Date, Estimated Arrival Date, Actual Arrival Date, Estimated Delivery Date, Actual Delivery Date.
+
** '''Import Fields''' - [[TBD]], presumably all fields of [[http://mantis.jaguarfreight.com/wiki/CT_bo#Import_Fields CT#ImpTab]] exclude their Date Fields. This tab is allowed only for CT with appropriate MOT.
-
**** "Non-CT Fields" - [[TBD]].
+
** '''Date Fields''' - contains set of pairs "From" and "To" dateboxes for select ranges of different CT dates. If some range not selected (both or one of "From" and "To" dateboxes are blank), selection in a query report will not be limited by this range.
-
** On the "Output" tab (see [[#Figure 1. Main Form Output tab | Figure 1]]) provides additional output control:
+
*** These ranges corresponds with CT fields: [[CT_bo#Estimated_Pick_Up_Date | Estimated Pickup Date]], [[CT_bo#Actual_Pick_Up_Date |Actual Pickup Date]], Estimated Departure Date, Actual Departure Date, Estimated Arrival Date, Actual Arrival Date, [[CT_bo#Estimated_Delivery_Date | Estimated Delivery Date]], [[CT_bo#Actual_Delivery_Date | Actual Delivery Date]].
-
*** Lines Per CT Option
+
** '''Non-CT Fields''' - [[TBD]]. Filter fields of report which don't are fields of CT, but related to it, ''for example'' Salesman.
-
*** Option for CT hyper link
+
* Each field on template has additional "Output" checkbox (greencolored). The status of "Output" checkbox determines the need for output to the report the selected field.
-
*** Ordering of output fields
+
* On the '''Output''' tab (see [[#Figure 1. Main Form Output tab | Figure 1]]) provides additional output control:
-
* On the tabs of template shows only fields which are "members" of report, otherwords, uses for filtering and/or output.
+
** Lines Per CT Option
-
** Selecting of theese fields executes in separate for each tab window. This window is opened by clicking on "Edit Fields Set" button. F.e. when click on "Edit Fields Set" button on "Date Fields" tab (see [[#Figure 2. Main Form Date Fields tab | Figure 2]]), then opens "Edit Date Fields" window (see [[#Figure 3. Edit Date Fields window | Figure 3]]).
+
** Option for CT hyper link
-
** Each selected (and showed on form) field has additional "Output" checkbox (greencolored). The status of "Output" checkbox determines the need for output to the report the selected field.
+
** Ordering of output fields
-
** If some fields not selected, then they couldn't be included to report.
+
=== SD: Add more flexibility ===
=== SD: Add more flexibility ===
Line 122: Line 110:
* 2) specified [[#Lines Per CT Option (LIPCO)]] made as an option on Output tab in the form of "Commodity Lines Per CT" dropdown. see [[#Figure 1. Main Form Output tab | Figure 1]].
* 2) specified [[#Lines Per CT Option (LIPCO)]] made as an option on Output tab in the form of "Commodity Lines Per CT" dropdown. see [[#Figure 1. Main Form Output tab | Figure 1]].
** dropdown takes two states: "show all commodity lines for one CT" and "show only commodity summary (one line)"
** dropdown takes two states: "show all commodity lines for one CT" and "show only commodity summary (one line)"
-
* 3) [[Hard Coded Conditions]]. Since each set of theese conditions is associated with certain report from CT2, suggest to use for select of report mode "Report Type" dropdown on form. see [[#Figure 4. Main Form Report Type dropdown | Figure 4]].
 
-
** Dropdown contains list of names of [[CT based reports]]. If select one of them, it means that report will be generated with  "Hard Coded Conditions". Fields which used in theese conditions can be showed but shouldn't be editable.
 
-
** There is also "Custom" line as last dropdown item. If select this item, it means that report will be generated without "Hard Coded Conditions".
 
== Figures ==
== Figures ==
Line 132: Line 117:
=== Figure 1. Main Form Output tab ===
=== Figure 1. Main Form Output tab ===
[[File:MainFormOutput.gif]]
[[File:MainFormOutput.gif]]
-
=== Figure 2. Main Form Date Fields tab ===
+
=== Figure 2. Main Form Commodity Fields tab ===
 +
[[File:MainFormCommodity.gif]]
 +
=== Figure 3. Main Form Export Fields tab ===
 +
[[File:MainFormExport.gif]]
 +
=== Figure 4. Main Form Import Fields tab ===
 +
[[File:MainFormImport.gif]]
 +
=== Figure 5. Main Form Date Fields tab ===
[[File:MainFormDateFields.gif]]
[[File:MainFormDateFields.gif]]
-
=== Figure 3. Edit Date Fields window ===
+
=== Figure 6. Main Form Non-CT Fields tab ===
-
[[File:EditDateFieldsWindow.gif]]
+
[[File:MainFormNonCTFields.gif]]
-
=== Figure 4. Main Form Report Type dropdown ===
+
=== Figure 7. Output tab ===
-
[[File:MainFormReportType.gif]]
+
[[File:OutputTab Defs.JPG]]
== History ==
== History ==
=== m1846 ===
=== m1846 ===
-
* http://mantis.jaguarfreight.com/mantis/view.php?id=1846
+
* http://ct.jaguarfreight.com/mantis/view.php?id=1846
==== BA ====
==== BA ====
* See [[#Option for CT hyper link (BR)]]
* See [[#Option for CT hyper link (BR)]]
-
* [http://mantis.jaguarfreight.com/mediawiki-1.15.0/index.php?title=Reports_Output&oldid=8996 current revision]
+
* [http://ct.jaguarfreight.com/mediawiki-1.15.0/index.php?title=Reports_Output&oldid=8996 current revision]
-
 
+
-
=== m1998 ===
+
-
* http://mantis.jaguarfreight.com/mantis/view.php?id=1998
+
-
'''last revision''' - http://mantis.jaguarfreight.com/mediawiki-1.15.0/index.php?title=Reports_Output&oldid=10553
+
-
 
+
-
==== BA 1998 ====
+
-
 
+
-
* 1) Have all CT fields available on all CT reports - see [[#BR: Make ALL CT fields available for output and filtering]]
+
-
* 2) Make report filters & output more flexible for every report [[#BR: Add more flexibility]]
+
-
 
+
-
==== SA 1998 ====
+
-
* 1) Have all CT fields available on all CT reports - see [[#SD: Make ALL CT fields available for output and filtering]]
+
-
* 2) Make report filters & output more flexible for every report [[#SD: Add more flexibility]]
+

Current revision as of 20:59, 12 August 2011


Contents

[edit] Info

[edit] Business Need (MO)

[edit] BR: Business Requirements

[edit] BR: Lines Per CT Option

Need 2 options: show all commodity lines for one CT or only commodity summary (one line)

[edit] Option for CT hyper link (BR)

Biz Need:

  • Option to display or not display CT # on output excel without hyperlink.

Suggested Design:

  • Add checkbox on Output Tab provide this option.

[edit] BR: Add more flexibility

[edit] SD: Systems Design

[edit] Standard User Interface

[edit] Select From

See #Figure 7. Output tab

[edit] Selected List

See #Figure 7. Output tab

[edit] Show Estimated Date if Actual Date is empty

In some reports we have only one column for given date instead of one for actual and one for estimated. In this case for some reports this logic is applied.

Example: if "Actual Delivery Date" is empty then display "Estimated Delivery Date" (under "Delivery Date" header)

[edit] Lines Per CT Option (LIPCO)

[edit] LIPCO multi line

In this case system must show all commodity lines for one CT. See example below.

Non Commodity table field values would have to be repeated (including CT#)

File:Daily-EATabing.JPG

[edit] LIPCO one line

In this case on output system must show only one line for one CT. Commodity information must be summarized. For example see CT# 199001 below.

If CT has more than one line in Commodity Table then:

  • for Commodity Table numerical columns (Plts, Weight, etc) show total number
  • for Commodity Table character column (SKU, PO, etc) show any one value and add "++" at the end indicating that there are more

File:In Tansit Spreadsheet JAN 2010.JPG


[edit] Option for CT hyper link

[edit] CT Num with hyperlink
  • mapping: CT#CT Num
  • this number is a hyperlink to Client App OR Internal App (View or Edit)
[edit] CT Num without hyperlink

[edit] SD: Rules for labels

[edit] SD: Output Fields

Most fields are defined in respective business object wikis:

[edit] SD: Make ALL CT fields available for output and filtering

  • Suggested to group all CT fields for filtering on the tabs of "All CT fields report" template. See Figure 0.
  • Non-CT fields that included to report grouped on "Non-CT Fields" tab.
  • List of suggested tabs for grouped fields: "General Fields", "Commodity Fields", "Export/Import Fields", "Date Fields", "Non-CT Fields".
  • List of fields for each tab:
    • General Fields - TBD, presumably all fields of [CT#GenTab].
    • Commodity Fields - TBD, presumably all fields on [CT#ContTab] of CT.
    • Export Fields - TBD, presumably all fields of [CT#ExpTab] exclude their Date Fields. This tab is allowed only for CT with appropriate MOT.
    • Import Fields - TBD, presumably all fields of [CT#ImpTab] exclude their Date Fields. This tab is allowed only for CT with appropriate MOT.
    • Date Fields - contains set of pairs "From" and "To" dateboxes for select ranges of different CT dates. If some range not selected (both or one of "From" and "To" dateboxes are blank), selection in a query report will not be limited by this range.
    • Non-CT Fields - TBD. Filter fields of report which don't are fields of CT, but related to it, for example Salesman.
  • Each field on template has additional "Output" checkbox (greencolored). The status of "Output" checkbox determines the need for output to the report the selected field.
  • On the Output tab (see Figure 1) provides additional output control:
    • Lines Per CT Option
    • Option for CT hyper link
    • Ordering of output fields

[edit] SD: Add more flexibility

  • 1) specified #Option for CT hyper link (BR) made as an option on Output tab in the form of "Display CT# as hyperlink" checkbox. see Figure 1
    • checked state of checkbox means that shipments will be displayed as a hyperlink
  • 2) specified #Lines Per CT Option (LIPCO) made as an option on Output tab in the form of "Commodity Lines Per CT" dropdown. see Figure 1.
    • dropdown takes two states: "show all commodity lines for one CT" and "show only commodity summary (one line)"

[edit] Figures

[edit] Figure 0. Main Form General Fields tab

File:AllCTFieldsMainForm1.gif

[edit] Figure 1. Main Form Output tab

File:MainFormOutput.gif

[edit] Figure 2. Main Form Commodity Fields tab

File:MainFormCommodity.gif

[edit] Figure 3. Main Form Export Fields tab

File:MainFormExport.gif

[edit] Figure 4. Main Form Import Fields tab

File:MainFormImport.gif

[edit] Figure 5. Main Form Date Fields tab

File:MainFormDateFields.gif

[edit] Figure 6. Main Form Non-CT Fields tab

File:MainFormNonCTFields.gif

[edit] Figure 7. Output tab

File:OutputTab Defs.JPG

[edit] History

[edit] m1846

[edit] BA

Personal tools