Download Sequel User Manual
Transcript
SDS Sequel User Manual QuickReports QuickReports Summary QuickReports Summary QuickReports are a series of preset reports that have been created for the purpose of easily exporting information in Sequel to an external source, such as Microsoft Excel. Although the QuickReports system is accessed from a specific Project, there are no limitations on which Projects are included in the results. Please see the individual topics for each section for more detail on the reports included. Common Features You can rearrange column headings in the results grid by dragging them into a new position: click and hold the left mouse button on the column heading and then move the mouse. Alternatively, drag the column headings onto the space at the top of the grid labelled ‘Drag a column header here to group by that column’. Each QuickReports screen will default to the current Project, but you can show all Projects by unticking the ‘Only show this Project’ checkbox. Use the filter row in the grid (the first blank row) to add additional filter criteria to your query. Type directly into the row, or choose an option from the drop down list. Right clicking the mouse on the column headings will bring up a menu with additional options. The most useful options here are the Best Fit options and the shortcut to the Filter Editor. The Filter Builder allows you combine many different types of filter across any of the fields in the report. In this way, you can customise the output of the reports to suit any requirement. Summaries Right click the footer panel to open a menu which allows you to create various sums based on the data in the column. The options available will vary depending on the type of data in the column. Exporting To export the information, click ‘Export’. You will be prompted for a filename and what type of file you would like to save as. The available options are Excel, PDF, Word page 105