A rank is a component that is based on the value of another component - a DBField, formula, summary, or parameter. You can map one or more values for these fields to an image known as the rank. The Rank component enables you to convert raw data values to easy-to-understand graphical cues or to hide sensitive details but still convey the general data value users. This topic describes how you can insert ranks in a report.
You can also create a rank component by first inserting a label, DBField, formula, summary, parameter, or special field, and then changing its display type as rank.
You can use ranks in page reports that use query resources only, and where you can insert a rank in a page report depends on what you have selected as its source (see Component Placement for more information).
To insert a rank into a query-based page report
- Position the mouse pointer at the allowed report location where you want to insert the rank.
- Do one of the following:
- From the Components panel, drag the Rank icon in the Visual category to the report.
- Navigate to Insert > Rank.
- Navigate to Home > Insert > Rank.
Designer displays the Rank Expert dialog box.
- 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 Browse to select an image file to be the default image. A value that does not fit any of the specified value ranges applies this image file by default.
- In the Default Image Alternate Text text box, type a string to serve as the content when the default image cannot display.
- In the Value Range box, select in the cell of the corresponding column to specify the minimum value, maximum value, image, and alternate text of the first range.
- Select Add to add and define more ranges. To delete a range, select it and select Remove. You can also use Move Up and Move Down to adjust the order of the ranges.
Designer displays a value, which is larger than or equal to the minimum value of a range and less than the maximum value, 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, Designer applies the highest range in the Value Range box.
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 specify the ranges 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. In the Alternate Text cell, type Poor.
- Select Add to add another range line. Set the minimum and maximum values to 71 and 90, select another image to represent the rank and type Good in the Alternate Text cell.
- Add one more range line, and set the values, image, and name for Excellent in the same way.
- Select Insert in the dialog box.
- Select in the location where you want to place the rank.
See an example: The SampleComponents catalog, included with Designer, contains reports that have examples of how you could use each component type in a report. For the rank component example, open