QR GET TOTALS DATA

version 2003

QR GET TOTALS DATA (area; colNum; breakNum; operator; text)

The QR GET TOTALS DATA command allows you to retrieve 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):

	- Subtotal: between 1 and the number of Subtotal/sort.
	- Grand total: -3 / constant: qr grand total.

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:

If the value returned equals 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 allows you to retrieve 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.

QR SET TOTALS DATA.