Download Sequel User Manual
Transcript
SDS Sequel User Manual (Rich Text) and Web page (html). Project QuickReport Project QuickReport The Project and Property QuickReports differ from the others, in that you can save ‘layouts’ of which attributes you would like to report on and the order in which they appear. On the left hand side are the list of all available Attributes. At the top of this list are a toolbar and a drop down list. The drop down list contains the definitions of the layouts you have created, as well as the default layout, ‘All Items’. To create a new layout, click the 'New Layout' button from the mini-toolbar. This will add the layout into the drop down list, with the name 'My Layout'. Click the item to edit the name, or press <F2>. Tick the Attributes you would like to include. Use the blue arrow buttons to rearrange the order of the Attributes; the floppy disk button to save your layout, and the red cross button to delete your layout. The double green arrow button refreshes the screen. The box with the tick in it will select every Attribute, whilst the box without a tick in it will unselect every Attribute. The Project QuickReports is also different from the others in the way it responds to the ‘Only show this Project’ checkbox. When the report is run for all Projects, the grid is pivoted, so that the Attributes become columns and each row represents a Project. When it is showing only the current project, it is displayed in the same way as the attributes grid in the program. Cashflow QuickReport Cashflow QuickReport The right hand side of the Cashflow QuickReport allows you to choose which of the five reports you would like to see. In addition there are two date selectors for limiting the range of data returned. The five reports for Cashflows are: 1. Cashflow Summary. This reports a single row for each Cashflow, with details about the owner, time last edited, interest rate, etc. 2. Forecast and Actual Spend by Month. This reports a row for each month in the Cashflow highlighting Forecasts, Transactions, Nett Cashflow, Interest and Cumulative Balance. 3. Budget, Latest, Forecast and Actual by Account Code. This reports a row for each Account Code in the Cashflow and totals Budget, Latest Estimate, page 106