Flexible Report 2579

From UG

(Difference between revisions)
Jump to: navigation, search
(→History)
(→SA Notes: transfered from Reports Output)
Line 48: Line 48:
== 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 ==

Revision as of 01:06, 7 December 2010


Contents

Info

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

BA Requirements

BR: Make ALL CT fields available for output and filtering

  • make ALL CT fields available for output and filtering:
  • 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

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

SA Notes

Standard User Interface

Report filters use Boolean logic and are multiselect.

Output Fields

Most fields are defined in respective business object wikis:

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.

Rules for labels

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

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

m1998

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

BA 1998

SA 1998

Retrieved from "https://wiki.jaguarfreight.com/Flexible_Report_2579"
Personal tools