TECH TIP: Calculating a Summary based on Group Totals Question: “I am using a Variable in the Group Footer to conditionally calculate totals for each group. I want to add a second Variable to the Summary that accumulates the results calculated for each group.” The following example uses two Variable components: vCustomerTotal and vCustomerSummary. The variable  Full Article…

TECH TIP: Performing Calculations Calculations can be done either on the data access side or within ReportBuilder. When designing reports there are always decisions to be made as to how much processing to do on the data side versus the report side. Usually doing more on one side can greatly simplify the other. So it  Full Article…

Question “How do I make a calculation based on a total (such as a percentage) inside a report using a look ahead value?” Solution Retrieve the look ahead value using the DBCalc.GetLookAheadValue routine and convert it to a numerical type.  Then use this value in a new calculation elsewhere in the report. Download: CalcUsingLookAheadValue.zip CalcUsingLookAheadValuesRAP.zip Sample  Full Article…