You can use computed fields in any band of the DataWindow object. Typical uses with examples include:
Calculations based on column data that change for each retrieved row
If you retrieve yearly salary, you can define a computed field
in the detail band that displays monthly salary: Salary / 12.
Summary statistics of the data
In a grouped DataWindow object, you can use a computed field
to calculate the totals of a column, such as salary,
for each group: sum (salary for group 1).
Concatenated fields
If you retrieve first name and last name, you can define a
computed field that concatenates the values so they appear with
only one space between them: Fname + "
" + Lname.
System information
You can place the current date and time in a DataWindow object's
header using the built-in functions Today() and Now() in
computed fields.
| Copyright © 2004. Sybase Inc. All rights reserved. |
|
|
