Wednesday, August 14, 2002
From The Edge: Understanding DBCalc in Report Designer Section: Report Designer Chapter: Running R:BASE Your Way! Platform: R:BASE 7.0 for Windows Build: 1.855xRT03 and Higher The DBCalc component in R:BASE 7.0 Report Designer eliminates the use of COUNT, SUM, MINIMUM, MAXIMUM, AVERAGE and SUM OF ColName expressions used in earlier versions of R:BASE. The DBCalc component is a data-aware report component used to perform common report calculations and print the resulting value such as COUNT, SUM, MINIMUM, MAXIMUM and AVERAGE. The calculation is performed based on the value of the field specified in DataField. Use the "DBCalc Type" to indicate the necessary calculations. DBCalc Types: The DBCalc Type property determines what type of report information is calculated and printed on the report. This property can be set from the report control's speed menu. For report break calculations you can use the ResetBreak property to enable a calculated value to be reset to zero each time the value of the field changes. Count: Count one for each row in Break where the ResetBreak field value is the same. Sum: Sum data values for each row in Break where the ResetBreak field value is the same. Minimum: Minimum data value for each row in Break where the ResetBreak field value is the same. Maximum: Maximum data value for each row in Break where the ResetBreak field value is the same. Average: Average of all data values for each row in Break where the ResetBreak field value is the same. Calculations such as Break Totals are available through ResetBreak property. Each time the field value for the Reset Break changes, all associated DBCalc components are reset to zero. Use the DisplayFormat property to control how the text is formatted. Text alignment of the caption is determined by the value of the Alignment property. You can force the control to resize to fit a changing caption by setting the AutoSize property to True. You can control the appearance of this component (Font, Alignment, etc.) at design-time by using the Format Bar of the Report Designer. The Format Bar also allows you to set the DataField property from a drop down list box at the far left. You can also set key properties by using the speed menu. To access the speed menu, position the mouse cursor over the report object and click the right mouse button. The LookAhead option is designed to allow you to display summary calculations in the Report Header section, Page Footer calculations in the Page Header section and Break Footer calculations in the Break Header section of the report. When the LookAhead property is set to True, the draw command which represents the component on the rendered page will continue to update with the most recent calculation value until the report completes the generation of the associated page or Break. Notes: The Report Pass Setting property must be set to Two Pass, in order for LookAhead calculations to function reliably. PDF version of this technical document is also available at: From The Edge: http://www.razzak.com/fte (Reports and Labels) (Powered by R:Tango) Enjoy and make sure to have fun! Very Best Regards, Razzak. ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
