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…

Question “How can I show the sum of the previous details in the last detail band of a group, rather than using the group footer or footer band?” Solution This can be done by making the calculation in a TppVariable, then manually adding a DrawCommand to the page aligned with the last detail band of  Full Article…