How to Create a Calculated Column in a PixelPerfect Report

Frank_S — Thu, 19 Nov 2015 23:35:33 GMT

Description: This tutorial illustrates how to create calculated columns in a PixelPerfect report using Calculated Field

After adding CH341 - Sales by Product CH341 - Sales by Product in the Levels node:

You can double click on a field to insert it in the expression

Hold down the CTRL key on your keyboard while you select the following fields in the following order:ProductName, Sales, Quantity, AvgPrice
Left click and hold on the selection made in Step 1.
While holding the selection, drag and drop it into DetailReport - "CH341_Level" -> Detail1 band
Drag the Detail1 bar upper border till it coincides with the lower border of the Level border to eliminate the white spaces

After clicking desired cell:

Click on Preview

See the step below to create a more complex expression and avoid the Infinity issue

On previewing again, you can see that the word Infinity has been replaced with the ' - ' character where the quantity value is 0.

article How to Create a Calculated Column in a PixelPerfect Report in Member Articles