CT Records Report

From UG

(Difference between revisions)
Jump to: navigation, search
(Hard Coded Conditions)
(User Defined Conditions)
Line 33: Line 33:
=== User Defined Conditions ===
=== User Defined Conditions ===
* See Figure 2 for general filters tab below
* See Figure 2 for general filters tab below
-
* All filters are "multi select"
+
* Date filter is from Date to Date calendar
 +
* Office filter is "multi select"  
 +
* Office selected filters are connected by '''OR''' condition
 +
** For example: ((Office = New York) '''OR'''(Office = London))
* Check box in front of each filter. If filter is set, check box MUST be automatically checked vise versa
* Check box in front of each filter. If filter is set, check box MUST be automatically checked vise versa
-
* Filters consist of several groups
 
-
* Every filter is connected by '''AND''' and sub selections inside each filter combo-box are connected by '''OR'''
 
-
** For example: ((Client Companies = E.A. USA Domestic) '''OR'''(Client Companies = Elizabeth Arden)) '''AND''' ((Shippers = A-TESTCOMP - TestCity - test remark)'''OR'''(Shippers = ABC - HK - test))
 
* If none of the filters are selected, generate ALL results.
* If none of the filters are selected, generate ALL results.
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +

Revision as of 17:40, 26 February 2010


Contents

Technical Specification

Summary

  • This report should appear on Saved/Scheduled Reports section (to run this report you have to schedule it).
  • This report should appear Acc > Reports > CT Records Per Office.
  • Report shows date time stamp and how many records are found (number)per mode and per office

User Interface

From Scheduled Reports

See #Figure 1. CT Records Per Office (Schedule Menu)

See #Figure 2. General Filters Tab

See #Figure 3. Output Tab

From Acc Reports

See #Figure 4. Filters and Buttons

Filters

See #Filters and Filters Matching Logic.

Hard Coded Conditions

  • This report is used to identify how many shipments (CT's) has been created in the system by specific office during a given time frame (???Still need to know how to generate per schedule? all from the beginning to present OR from the last report
  • Report should use CT#Created On Date date field to identify when shipment was created.

User Defined Conditions

  • See Figure 2 for general filters tab below
  • Date filter is from Date to Date calendar
  • Office filter is "multi select"
  • Office selected filters are connected by OR condition
    • For example: ((Office = New York) OR(Office = London))
  • Check box in front of each filter. If filter is set, check box MUST be automatically checked vise versa
  • If none of the filters are selected, generate ALL results.











Figure 1. CT Records Per Office (Schedule Menu)

File:CTRecordsSchedules.JPG


Figure 2. General Filters Tab

File:GeneralTabCTrecords.JPG


Figure 3. Output Tab

File:OutputCTRecords.JPG


Figure 4. Filters and Buttons

File:CTrecordsACCMenu.JPG


Figure 5. SpreadSheet

File:CTrecordsPerOffice.JPG

Personal tools