Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
cats:settings:reportoptions [2016/03/14 14:10] – [Exchange Trades Futures Reporting] amanda | cats: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 |
- | [{{: | + | [{{: |
- | **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 **'' |
- | **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 **'' | ||
+ | Otherwise, the **As of** date resets after every printing.</ | ||
+ | <note tip>For isolated areas, the **As of** date defaults to the isolated period date.</ | ||
+ | |||
+ | **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** |
- | **Subtotal** - Subtotal, Do Not Subtotal, No Group Totals, No Totals, No Sub-Heading | + | **Subtotal** - Subtotal |
**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 |
**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, |
**Wrap Extra Columns** - Yes, No | **Wrap Extra Columns** - Yes, No | ||
Line 135: | Line 151: | ||
**Pricing** - All, Stated, To Be Fixed, Fixed, Fixed Stated, | **Pricing** - All, Stated, To Be Fixed, Fixed, Fixed Stated, | ||
- | **Open Quant Calc** - Paid/ | + | **Open Quant Calc** - "Paid/ |
**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, | **Units Condition**-All, | ||
- | ====Exchange Trades | + | ====Futures Reporting==== |
+ | Here are some report options unique to futures reporting.\\ | ||
- | Here are some options unique to future reporting.\\ | + | ===Open |
- | + | Here are the filters unique to Open Futures Reports. | |
- | ===Open Report Screen 1=== | + | |
- | \\ | + | |
[{{: | [{{: | ||
- | **ID** - All, Select, Exclude, Match, Match Excluded\\ | + | **Date Range** - Allows you to filter by Futures Trade date. |
- | **Position** - All, Select, | + | **ID** - All, Select, |
- | **Active Positions**- All, Active\\ | + | **Position** - All, Select, Spot, Futures - Choose a range of positions or Spot (current month) or Futures (all except current month).\\ |
- | **To Be Fixed Trades** - Include, Exclude, Only TBF \\ | + | **Broker** - All, Select, Match, Match Exclude - Show on the report only trades that have specific House Broker codes.\\ |
+ | |||
+ | **Active Positions**- All, Active - Include or Exclude positions on the exchange that are no longer active.\\ | ||
+ | |||
+ | **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.\\ | ||
**Type** - All, Hedge, Price Fix, Speculation, | **Type** - All, Hedge, Price Fix, Speculation, | ||
Line 684: | Line 703: | ||
**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\\ |
- | + | ||
- | ===Liquidated | + | ===Entries |
- | \\ | + | 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.\\ |
- | [{{: | + | |
- | + | ||
- | **ID**-All, Select, Exclude, Match, Match Excluded\\ | + | |
- | + | ||
- | **Active Positions**- All, Active\\ | + | |
- | + | ||
- | **To Be Fixed Trades**-Include, | + | |
- | + | ||
- | **Type**- All, Hedge, Price Fix, Speculation, | + | |
- | + | ||
- | **Include GTC Trades**- Exclude, Include, Only GTC\\ | + | |
- | + | ||
- | **Exchange/ | + | |
- | + | ||
- | **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\\ | + | |
- | + | ||
- | **Starred Trades**- Exclude, Include, Only Starred\\ | + | |
- | + | ||
- | **Strategy**- All, Select, Exclude, Match, Match Excluded, Any, None\\ | + | |
- | + | ||
- | ===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. \\ | ||
+ | [{{: | ||
====Loans==== | ====Loans==== |