4D v16.3

QR GET TOTALS DATA

Home

 
4D v16.3
QR GET TOTALS DATA

QR GET TOTALS DATA 


 

QR GET TOTALS DATA ( area ; colNum ; breakNum ; operator ; text ) 
Parameter Type   Description
area  Longint in Reference of the area
colNum  Longint in Column number
breakNum  Longint in Break number
operator  Longint in Operator value for the cell
text  String in Contents of the cell

The QR GET TOTALS DATA command retrieves the details of a specific break.

area is the reference of the Quick Report area.

colNum is the number of the column whose data will be retrieved.

breakNum is the number of the break whose data will be retrieved (subtotal or grand total). For a subtotal row, breakNum corresponds to the row number. For a grand total, breakNum is -3 (you can also use the qr grand total constant from the QR Rows for Properties theme).

operator returns the sum of all the operators present in the cell. You can use the constants of the QR Operators theme to process the returned value:

Constant Type Value
qr average Longint 2
qr count Longint 16
qr max Longint 8
qr min Longint 4
qr standard deviation Longint 32
qr sum Longint 1

If the value returned is 0, there is no operator.

text returns the text present in the cell.

Note: operator and text are mutually exclusive, so you either have a result returned through operator or through text.

The QR GET TOTALS DATA command retrieves the details of a specific cell.

area is the reference of the Quick Report area.

colNum is the column number of the cell whose data is going to be retrieved.

breakNum is the row number of the cell whose data is going to be retrieved.

operator returns the sum of all the operators present in the cell. You can use the constants of the QR Operators theme to process the returned value (see above).

text returns the text in the cell.

Here is a depiction of how the parameters colNum and breakNum have to be combined in cross-table mode:


If you pass an invalid area number, the error -9850 will be generated.
If you pass an invalid colNum number, the error -9852 will be generated.
If you pass an invalid breakNum number, the error -9853 will be generated.



See also 

QR SET TOTALS DATA

 
PROPERTIES 

Product: 4D
Theme: Quick Report
Number: 768

This command modifies the Error system variable

 
HISTORY 

Created: 4D 2003

 
ARTICLE USAGE

4D Language Reference ( 4D v16)
4D Language Reference ( 4D v16.1)
4D Language Reference ( 4D v16.2)
4D Language Reference ( 4D v16.3)