Flexible Report 2579

From UG

(Difference between revisions)
Jump to: navigation, search
(BA Requirements)
 
(8 intermediate revisions not shown)
Line 1: Line 1:
-
[[Category:Projects]]
+
[[Category:RFD]]
== Info ==
== Info ==
Line 12: Line 12:
** all [[Commodity]] fields
** all [[Commodity]] fields
** all [[Container]] fields
** all [[Container]] fields
 +
** include the following non CT object/components
 +
***salesman
 +
***internal user groups
 +
***users offices
* should be done only for  [[CT based reports]]
* should be done only for  [[CT based reports]]
Line 28: Line 32:
** All fields should only be available for internal
** All fields should only be available for internal
-
* see also [[#SD: Rules for labels]]
+
* see also [[#Rules for labels]]
==== Options for Output ====
==== Options for Output ====
-
* Make the output tab a recap list, of all of the checked filters, with the option to move up, down & remove
+
* Have output tab be a recap list, of all the checked filters
 +
 
 +
* Give option to move up, down & remove
* If no filters selected, default settings to:
* If no filters selected, default settings to:
-
 
+
**shipper
-
*shipper
+
**consignee
-
*consignee
+
**qty
-
*qty
+
**origin
-
*origin
+
**destination
-
*destination
+
**departure date
-
*departure date
+
**arrival date
-
*arrival date
+
**PO
-
*PO
+
**SKU
-
*SKU
+
== SA Notes ==
== SA Notes ==
 +
 +
=== Standard User Interface ===
 +
Report filters use [http://mantis.jaguarfreight.com/wiki/Reports_Filters#Boolean_Logic Boolean logic] and are [http://mantis.jaguarfreight.com/wiki/Reports_Filters#Multiselect multiselect].
 +
 +
=== Output Fields ===
 +
Most fields are defined in respective business object wikis:
 +
* [[CT]]
 +
* [[Commodity]]
 +
* etc
 +
 +
=== Make ALL CT fields available for output and filtering ===
 +
* Suggested to group all CT fields for filtering on the tabs that correspond to CT tabs:
 +
** '''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 [[http://mantis.jaguarfreight.com/wiki/CT_bo#Containers_and_Commodities CT#ContTab]] of CT.
 +
** '''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.
 +
** '''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.
 +
** '''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 filter field on template has additional "Output" checkbox (greencolored). The status of "Output" checkbox determines the need for output to the report the selected field.
 +
 +
=== Rules for labels ===
 +
* on Output tab - show [[Standard Long Label]]
 +
* on HTML View and Spreadsheet - show [[Standard Short Label]]
 +
 +
=== Show Estimated Date if Actual Date is empty ===
 +
Sometimes we have only one column for given date instead of one for actual and one for estimated. In this case this logic is applied.
 +
 +
=== Additional flexibility ===
 +
* 1) Option to display or not display CT # on output with hyperlink.
 +
* 2) Option to display all commodity lines for one CT or to display one line with summarized commodity.
== History ==
== History ==
-
0002579: [Flex Rep] Finalize Requirements and SA Notes sections
+
0002579: [Flex Rep] Finalize Requirements and SA Notes sections  
 +
[http://mantis.jaguarfreight.com/mantis/view.php?id=2579 2579]
 +
 
 +
=== 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=11814
 +
 
 +
==== 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 02:00, 12 January 2011


Contents

[edit] Info

  • 0002578 started [Flex Rep] .....<proj>

[edit] BA Requirements

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

  • make ALL CT fields available for output and filtering:
    • all CT fields
    • all Commodity fields
    • all Container fields
    • include the following non CT object/components
      • salesman
      • internal user groups
      • users offices
  • How to group so many filters? Additional tabs? Groups on one tab?
    • suggest solution
  • How to group or order them on Output Tab (Select From panel):
    • now they are not grouped / ordered and when we have a very long list this is an issue
    • now we need to select one at a time - this is too slow
    • please suggest alternative designs so we can choose
  • Internal vs Client:
    • All fields should only be available for internal

[edit] Options for Output

  • Have output tab be a recap list, of all the checked filters
  • Give option to move up, down & remove
  • If no filters selected, default settings to:
    • shipper
    • consignee
    • qty
    • origin
    • destination
    • departure date
    • arrival date
    • PO
    • SKU

[edit] SA Notes

[edit] Standard User Interface

Report filters use Boolean logic and are multiselect.

[edit] Output Fields

Most fields are defined in respective business object wikis:

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

  • Suggested to group all CT fields for filtering on the tabs that correspond to CT tabs:
    • 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 filter field on template has additional "Output" checkbox (greencolored). The status of "Output" checkbox determines the need for output to the report the selected field.

[edit] Rules for labels

[edit] Show Estimated Date if Actual Date is empty

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

[edit] Additional flexibility

  • 1) Option to display or not display CT # on output with hyperlink.
  • 2) Option to display all commodity lines for one CT or to display one line with summarized commodity.

[edit] History

0002579: [Flex Rep] Finalize Requirements and SA Notes sections 2579

[edit] m1998

last revision - http://mantis.jaguarfreight.com/mediawiki-1.15.0/index.php?title=Reports_Output&oldid=11814

[edit] BA 1998

[edit] SA 1998

Personal tools