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