CT Records Report

From UG

Revision as of 18:04, 26 February 2010 (edit) Montira (Talk | contribs) (→Summary) ← Older edit		Revision as of 18:06, 26 February 2010 (edit) (undo) Montira (Talk | contribs) (→Technical Specification) Newer edit →
Line 63:		Line 63:
	* Fill in page with one CT per cell left to right then top to bottom		* Fill in page with one CT per cell left to right then top to bottom
	* Fit page for printing		* Fit page for printing
-
	==== Sort By Definitions ====		==== Sort By Definitions ====
Line 85:		Line 84:
	** There is no footer		** There is no footer
		+	=== Special Cases ===
		+	TBD
-		+	=== Figures ===
-		+	==== Figure 1. CT Records Per Office (Schedule Menu) ====
-		+
-		+
-		+
-	Figure 1. CT Records Per Office (Schedule Menu)	+
	[[File:CTRecordsSchedules.JPG]]		[[File:CTRecordsSchedules.JPG]]
-	Figure 2. General Filters Tab	+	==== Figure 2. General Filters Tab ====
	[[File:GeneralTabCTrecords.JPG]]		[[File:GeneralTabCTrecords.JPG]]
-	Figure 3. Output Tab	+	==== Figure 3. Output Tab ====
	[[File:OutputCTRecords.JPG]]		[[File:OutputCTRecords.JPG]]
-	Figure 4. Filters and Buttons	+	==== Figure 4. Filters and Buttons ====
	[[File:CTrecordsACCMenu.JPG]]		[[File:CTrecordsACCMenu.JPG]]
-	Figure 5. SpreadSheet	+	==== Figure 5. SpreadSheet ====
	[[File:CTrecordsPerOffice.JPG]]		[[File:CTrecordsPerOffice.JPG]]

---

Revision as of 18:06, 26 February 2010

Contents 1 Technical Specification 1.1 Summary 1.2 User Interface 1.2.1 Filters 1.3 Hard Coded Conditions 1.4 User Defined Conditions 1.4.1 Filters and Filters Matching Logic 1.5 Output 1.5.1 Cell Definitions 1.5.2 Sort By Definitions 1.5.3 Summary 1.6 Special Cases 1.7 Figures 1.7.1 Figure 1. CT Records Per Office (Schedule Menu) 1.7.2 Figure 2. General Filters Tab 1.7.3 Figure 3. Output Tab 1.7.4 Figure 4. Filters and Buttons 1.7.5 Figure 5. SpreadSheet

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.

Filters and Filters Matching Logic

• Date: From Ct#Created_On_Date To Ct#Created_On_Date
• Office#City

Output

• Create output tab with list of output headings; in this case it is only for schedule report view
• This output heading consists of ONLY CT#
• Required default headings on the combo box
• List of headings #Cell Definitions
• See #Figure 5. SpreadSheet for output result (xls)

Cell Definitions

• CT# with link
  • Mapped to CT#CT Num

??????** If user is client, CT# hyperlinks are link to view shipment page under client interface> shipment detail. ?????* If user is internal user(JG users), CT# hyperlinks are linked to view shipment page in Internal interface.

• • Default on the combo box selected list
• Fill in page with one CT per cell left to right then top to bottom
• Fit page for printing

Sort By Definitions

• Sort by CT# from earlier CT# to newer CT#
• Tab by alphabet order (Office(s))

Summary

• Output is a spreadsheet
• Spreadsheet tabs: There is one tab PER office with total of CT# records
• Spreadsheet each tab: Group by MOT
• Spreadsheet consists of Header, Body, and footer
• Header:
  • Report name
  • Date Time Stamp
  • Criteria (list of filter(s) selected)
  • Jaguar Logo
• Body: (general info)
  • Consists of heading (CT#)and result in each cell
    • Cell: CT# with hyperlink
• Footer
  • There is no footer

Special Cases

TBD

Figures

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