CT Records Report
From UG
(Difference between revisions)
(→User Defined Conditions) |
(→Filters and Filters Matching Logic) |
||
Line 44: | Line 44: | ||
==== Filters and Filters Matching Logic ==== | ==== Filters and Filters Matching Logic ==== | ||
+ | * Date: From [[Ct#Created_On_Date]] To [[Ct#Created_On_Date]] | ||
* [[Office#City]] | * [[Office#City]] | ||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
Revision as of 17:47, 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
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.
Filters and Filters Matching Logic
- Date: From Ct#Created_On_Date To Ct#Created_On_Date
- Office#City
Figure 1. CT Records Per Office (Schedule Menu)
Figure 2. General Filters Tab
Figure 3. Output Tab
Figure 4. Filters and Buttons
Figure 5. SpreadSheet