Sybase InfoMaker 11.5, CD, Win, ENG Specifiche Scaricare il pdf (Pagina 321)

100

101

CHAPTER 9 Filtering, Sorting, and Grouping Rows

Users Guide 299

4 Click OK.

Only rows meeting the filter criteria are displayed in the Preview view.

Filtered rows and updates

Modifications of filtered rows are applied to the database when you issue

an update request.

Removing a filter

❖ To remove a filter:

1 Select Rows>Filter from the menu bar.

2 Delete the filter expression from the Specify Filter dialog box, then click

OK.

Examples of filters

Assume that a report retrieves employee rows and three of the columns are

Salary, Status, and Emp_Lname. Table 9-1 shows some examples of filters you

might use.

Table 9-1: Sample filters

Sorting rows

You can use an ORDER BY clause in the SQL SELECT statement for the report

to sort the data that is retrieved from the database. If you do this, the DBMS

itself does the sorting and the rows are brought into InfoMaker already sorted.

However, you might want to sort the rows after they are retrieved. For example,

you might want to:

• Offload the processing from the DBMS

• Sort on an expression, which might not be allowed in the

SELECT

statement but is allowed in InfoMaker

To display these rows Use this filter

Employees with salaries over $50,000

Salary > 50000

Active employees Status = 'A'

Active employees with salaries over

$50,000

Salary > 50000 AND Status = 'A'

Employees whose last names begin

with H

left(Emp_Lname, 1) = 'H'

1 2 ... 316 317 318 319 320 321 322 323 324 325 326 ... 827 828

Commenti su questo manuale

Nessun commento

Sybase InfoMaker 11.5, CD, Win, ENG Specifiche Pagina 321

Commenti su questo manuale