cats:settings:reportoptions

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
cats:settings:reportoptions [2016/03/01 17:05] – jencats:settings:reportoptions [2020/04/30 13:42] (current) – amanda
Line 1: Line 1:
 =====CATS Report Options===== =====CATS Report Options=====
-This is a list of all options available on reports. Each option is a filter that changes which records will appear on the reports. +This is a list of all options available on reports. Each option is a filter that changes which records will appear on the reports, how the records are displayed, or the visual output of the report. 
 + 
 +To change these filters, highlight the report you want to change from the saved report format list, and click the **Modify** button.  
  
 ====Options Available on All Reports==== ====Options Available on All Reports====
-These options, found on **Screen 5**, are available on all reports. They allow users to customize the style of the report output.  +The options displayed below, found when you click on **Screen 5** from the toolbar menu while modifying a report, are available on all reports in CATS. They allow users to customize the style of the report output.  
-[{{:cats:settings:filters_openposscreen5.png?|Screen 5}}]+[{{:cats:settings:filters_openposscreen5.png?|Screen 5}}]\\ 
  
-**As of:** +**Title** - The title is what will display at the top of the report. This can be left blank. 
  
-**File Name**+**As of:** - Change the **As of** date for this report. This will force CATS to display the data as it was on a certain date. For example, if today is 09\01\2017, but you set the **As of** date to **''08\15\2017''**, you will see the records that were input or matched the selected filters on 08\15\2017. 
  
-**Diff Report** - No, Yes +This can be useful for seeing what was in warehouse as of a certain date, or what accounting entries were made after a certain date, regardless of the date of the entries. CATS keeps track of when most changes were made in the system to facilitate use of this filter.   
 +<note important> 
 +**This option only works on certain reports or for certain types of data.** 
 +The **As of** date will be saved for all reports of the same type until you exit the list of saved reports. So if you print the report file **ALL WITH INVOICES**, change the **As of** date to **''09/01/2017''**, then print the report **ALL NO INVOICE**, the **As of** date for the second report will also be **''09/01/2017''**.\\  
 +Otherwise, the **As of** date resets after every printing.</note> 
 +<note tip>For isolated areas, the **As of** date defaults to the isolated period date.</note> 
 + 
 +**File Name** - If the output location for this report is a file, you can name the file using this option.  
 + 
 +**Diff Report** -    
 +    * No - Do not treat this report as a Difference report.  
 +    * Yes - Save this report into the Difference Report area, allowing you to use a Difference report to find changes between printings of this report. 
  
 **Separate Character** **Separate Character**
  
-**Detail, Summary**+**Detail** - This option will show all details on the report.\\  
 +**Summary**- This option will show only a summary of the totals. No details shown.\\ 
  
-**Single Space, Double Space**+**Single Space, Double Space** - Lets you choose single or double space when printing to a printer.\\ 
  
-**Subtotal** - Subtotal, Do Not Subtotal, No Group Totals, No Totals, No Sub-Heading+**Subtotal** - Subtotal - shows subtotals, Do Not Subtotal - does not show any subtotals just overall totals, No Group Totals, No Totals - No totals shown at all, No Sub-Heading
  
 **Cross-Tab** - No, Top, Bottom, Cross- Tab Only **Cross-Tab** - No, Top, Bottom, Cross- Tab Only
Line 24: Line 38:
 **Date Separator** - Default, "/", "_" **Date Separator** - Default, "/", "_"
  
-**Underline** - Standard, Default, Yes, No, Standard+**Underline** - Standard - Totals and subtotals are underlined, Default - Totals and subtotals are not underlined, Yes - Totals and subtotals are underlined , No - Totals and subtotals are not underlined.\\
  
 **Subtotal Description** - Display, Omit, End of Total, Start of Total Line **Subtotal Description** - Display, Omit, End of Total, Start of Total Line
 +This report option lets you move or omit the description for the subtotal line. Choosing the display option will put the description at the start of the total line. \\ 
  
 **Subtotal Labels** - Default, Value **Subtotal Labels** - Default, Value
  
-**HTML Styles** - Standard, Select, CATS Default+**HTML Styles** - Standard, Select, CATS Default\\  
 +Select will let user view, edit and change fonts and colors on the report.\\ 
  
 **Omit As of Date** - No, Yes **Omit As of Date** - No, Yes
Line 40: Line 56:
 **Show Cats Version** - Off, On **Show Cats Version** - Off, On
  
-**Two- Line Heading** - Standard, No,Yes+**Two- Line Heading** - Standard, No,Yes - This setting lets you make the heading on one line or two for printing to a printer.\\
  
 **Wrap Extra Columns** - Yes, No **Wrap Extra Columns** - Yes, No
Line 135: Line 151:
 **Pricing** - All, Stated, To Be Fixed, Fixed, Fixed Stated,  Prov Bought, Invcd\\ **Pricing** - All, Stated, To Be Fixed, Fixed, Fixed Stated,  Prov Bought, Invcd\\
  
-**Open Quant Calc** - Paid/Invoiced, Paid For\\+**Open Quant Calc** - "Paid/Invoiced" will show the amount of units that are on the contract item minus the units on sale invoices. "Paid For" will show just the amount of units that have no purchase invoice.\\
  
 **Trader** - All, Select, Exclude, Match, Match Excluded, Any, None\\ **Trader** - All, Select, Exclude, Match, Match Excluded, Any, None\\
Line 654: Line 670:
 **Units Condition**-All, Only If Units, Only if Weight, Units or weight, Units and Weight        **Units Condition**-All, Only If Units, Only if Weight, Units or weight, Units and Weight       
  
-====Exchange Trades Futures Reporting====+====Futures Reporting==== 
 +Here are some report options unique to futures reporting.\\ 
  
-Here are some options unique to future reporting.\\  +===Open Futures Report (Screen 1)=== 
- +Here are the filters unique to Open Futures Reports.
-===Open Report Screen 1=== +
-\\+
 [{{:cats:settings:filters_extradefuturesreportopenscreen1.png?|Exchange Trades Future Open Report Screen 1}}] [{{:cats:settings:filters_extradefuturesreportopenscreen1.png?|Exchange Trades Future Open Report Screen 1}}]
  
-**ID**-All, Select, Exclude, Match, Match Excluded\\ +**Date Range** - Allows you to filter by Futures Trade date. 
  
-**Active Positions**- All, Active\\ +**ID** - All, Select, Exclude, Match, Match Excluded - Refers to the User ID that created the trade.\\ 
  
-**To Be Fixed Trades**-Include, Exclude, Only TBF \\ +**Position** - All, Select, Spot, Futures - Choose a range of positions or Spot (current month) or Futures (all except current month).\\ 
  
-**Type**- All, Hedge, Price Fix, Speculation, Combination, Exclude Combo, Exclude Price Fixing\\ +**Broker** - All, Select, Match, Match Exclude - Show on the report only trades that have specific House Broker codes.\\ 
  
-**Include GTC Trades**- Exclude, Include, Only GTC\\ +**Active Positions**- All, Active - Include or Exclude positions on the exchange that are no longer active.\\ 
  
-**Exchange/Currency**- All, Select, Currency, Commodity, One Item\\ +**To Be Fixed Trades** - Include, Exclude, Only TBF - To-Be-Fixed trades, created by CATS to indicate that a price-fixing has not yet been completed, can be displayed or excluded on this report.\\ 
  
-**Trade No**- All, Select, Exclude, Match, Match Excluded\\+**Type** - All, Hedge, Price Fix, Speculation, Combination, Exclude Combo, Exclude Price Fixing\\ 
  
-**Memo No**- All, Select, Exclude, Match, Match Excluded, Any, None\\  +**Include GTC Trades** - Exclude, Include, Only GTC\\ 
-          +
-**Memo Mode**- Memos Trades Only, Exclude Memo Trades\\  +
- +
-**Starred Trades**- Exclude, Include, Only Starred\\ +
- +
-**Strategy**- All, Select, Exclude, Match, Match Excluded, Any, None\\           +
- +
-===Liquidated Report Screen 1=== +
-\\ +
-[{{:cats:settings:filters_extradefuturesreportliquidscreen1.png?|Exchange Trades Future Liquidated Report Screen 1}}]+
  
-**ID**-All, Select, Exclude, Match, Match Excluded\\+**Exchange/Currency** - All, Select, Currency, Commodity, One Item\\ 
  
-**Active Positions**- All, Active\\ +**Trade No** - All, Select, Exclude, Match, Match Excluded\\
  
-**To Be Fixed Trades**-Include, Exclude, Only TBF \\  +**Memo No** - All, Select, Exclude, Match, Match Excluded, Any, None\\  
- +         
-**Type**- All, Hedge, Price Fix, Speculation, Combination, Exclude Combo, Exclude Price Fixing\\  +
- +
-**Include GTC Trades**- Exclude, Include, Only GTC\\  +
- +
-**Exchange/Currency**- All, Select, Currency, Commodity, One Item\\  +
- +
-**Trade No**- All, Select, Exclude, Match, Match Excluded\\  +
- +
-**Memo No**- All, Select, Exclude, Match, Match Excluded, Any, None\\   +
-        +
 **Memo Mode**- Memos Trades Only, Exclude Memo Trades\\  **Memo Mode**- Memos Trades Only, Exclude Memo Trades\\ 
  
 **Starred Trades**- Exclude, Include, Only Starred\\ **Starred Trades**- Exclude, Include, Only Starred\\
  
-**Strategy**- All, Select, Exclude, Match, Match Excluded, Any, None\\           +**Strategy**- All, Select, Exclude, Match, Match Excluded, Any, None\\    
- +  
-===Entries Report Screen 1=== +===Entries Report (Screen 1)=== 
-\\+The Entries report (showing all futures trades as they were entered instead of current status) has all of the report options the Open Futures report has, except for the **Include GTC** option.\\
 [{{:cats:settings:filters_extradefuturesreportentriesscreen1.png?|Exchange Trade Futures Entries Report Screen 1}}] [{{:cats:settings:filters_extradefuturesreportentriesscreen1.png?|Exchange Trade Futures Entries Report Screen 1}}]
  
 **Reversals**- Include, Exclude, Only\\  **Reversals**- Include, Exclude, Only\\ 
  
-**Update Price**- Yes, No, Yes/Exclude Missing\\ +**Update Price**- Yes, No, Yes/Exclude Missing\\        
 + 
 +===Liquidated Report (Screen 1)=== 
 +These are the same filters as for the Open Futures report, but the **Include GTC Trades** option is not available for this report. \\ 
 +[{{:cats:settings:filters_extradefuturesreportliquidscreen1.png?|Exchange Trades Future Liquidated Report Screen 1}}]
  
 ====Loans==== ====Loans====
Line 772: Line 771:
 ====Invoicing Reports==== ====Invoicing Reports====
  
-===Provisionals Not Finalized===+===Provisionals Not Finalized Screen 1===
 \\ \\
 [] []
  
-**Blah**- \\ +**Units Condition**-All, Only if Units, Only if Weights, Units or Weight, Units and Weight\\  
 + 
 +**Transaction Code**-All, Select, Exclude, Match, Match Excluded\\  
 + 
 +**Invoice Type**-All, A/R Sales, A/P Sales\\  
 + 
 +===Provisionals Not Finalized Screen 2=== 
 +\\ 
 +[] 
 + 
 +**Only if Wt/Units**- Yes, No\\  
 + 
 +**All, Prov no Final, Open**- All, Prov/Not Final, Open Invoices, Open or Prov/Not final, Modified/ Finalized\\  
 + 
 +**Show Prior Invoice**- Yes, No\\  
 + 
 +**Contract Price**- All, Priced, Unpriced\\  
 + 
 +**Date Pricefixing**- All, Yes, No\\  
 +  
 +**Invoice File**- Current, History\\  
 + 
 +===Provisionals Not Finalized Screen 3=== 
 +\\ 
 +[] 
 + 
 +**Reserve Costs**- All, Purchases, Sale\\  
 + 
 +**Prorate Rsv Costs**- All, None, Reserved Amount, Actual Amount\\  
 + 
 +**Invoice Flag**- Select Any, Select All, Exclude Any, Excluded All, Advanced\\ 
  
 ===Report Of Open Invoices=== ===Report Of Open Invoices===
 +\\
 +[]
 +
  
  
  • cats/settings/reportoptions.1456851908.txt.gz
  • Last modified: 2017/12/19 03:21
  • (external edit)