A rank is a component that is based on the value of another component - a DBField, formula, summary, or parameter. One or more values for these fields can be mapped to an image known as the rank. The rank component allows you to convert raw data values to easy-to-understand graphical cues or to hide sensitive details but still convey the general data value to the report end users.
Ranks are only supported in page reports that are created using query resources.
To insert a rank into a page report:
- Do one of the following:
- Select Insert > Rank.
- Drag the Rank button from the Components panel to the report.
The Rank Expert dialog appears.
- The Rank Resources drop-down list displays the dataset available for the current insertion, and the list box below shows its fields, including DBFields, formulas, summaries and parameters.
Select the field you want to insert as rank from the list box. You can also create formulas, summaries, and parameters here.
- Select the Browse button to select an image file to be the default image (used if a value does not fit any of the specified value ranges).
- Type the alternate text of the default image in the Default Image Alternate Text box, which will be displayed when the image cannot be loaded or is not available.
- In the Value Range box, specify the minimum value, maximum value, image and alternate text respectively in the Minimum, Maximum, Image, and Alternate Text columns. Select or to add or delete a range. To adjust the order of the ranges, select or . A value, which is larger than or equal to the minimum value of a range and less than the maximum value, will be displayed as the image, or the alternate text if the image cannot be loaded or is not available. For a value belonging to two or more overlapping ranges, the highest range in the Value Range box will take effect.
Suppose that you want to define product quality rank based on customer grading, and you want to define three levels:
- 50-70, Poor
- 71-90, Good
- 91-100, Excellent
You can define as follows in the Value Range box:
- In the first range line, set the minimum and maximum values as 50 and 70 respectively in the cells of the Minimum and Maximum columns. Go to the Image cell, and then select <Browse...> to select an image to represent the rank. Select the Alternate Text cell and type Poor.
- Select to add another line. Set the minimum and maximum values as 71 and 90, select another image to represent the rank and type Good in the Alternate Text cell.
- Add one more line, and set the values, image and name for Excellent in the same way.
- Select Insert in the dialog, then select the mouse button in the location where you want the rank to be displayed.
- Where a rank can be inserted in a report depends on what you have selected as its source.
- You can also create a rank by first inserting a label, DBField, formula, summary, parameter or special field, and then changing its display type as rank.
See an example: The SampleComponents catalog, included with Logi Report Designer, contains reports that have examples of how each component type could be used in a report. For the rank component example, open