When you enter a natural segment value in the Dimensionsdialogue box, you can place a wildcard character ( ?or *) in any position of a segment. Management Reporter extracts all of the values for the defined positions without regard to the wildcard numbers. For example, if the row definition contains only natural segment values, assuming a four-character natural segment, entering 6???in a row instructs Management Reporter to include all accounts whose natural segment value begins with a 6. Entering 6*would return the same results, but would also include variable width values, such as 60 and 600000.

Management Reporter replaces each wildcard character ( ?) with the complete range of possible values, including letters and special characters. For example, in the range from 12?0 through 12?4, the wildcard character in 12?0 is replaced with the lowest value in the character set, and the wildcard character in 12?4 is replaced with the highest value in the character set.

Note Note

The use of wildcard characters should be avoided for the starting and ending accounts in ranges. If you use wildcard characters in either the starting account or the ending account, you might return unexpected results.

Single-segment or single-dimension ranges

You can specify a range of segment values or dimension values. The benefit of specifying a range is that you do not have to update the row definition every time that a new segment value or dimension value is added to the financial data.

For example, the range +Account=[6100:6900]pulls the values from Account 6100 through 6900, inclusively, into the row amount.

When a range includes a wildcard character ( ?), Management Reporter does notevaluate the range on a character-by-character basis. Instead, the low and high ends of the range are determined, and then all values between those ends are included, inclusive.

Note Note

Report Designer is unable to select any account, dimension, or field from the Microsoft Dynamics ERP system that includes the following reserved characters: & * [ ]. You can add an ampersand ( &) only when you are automatically building row definitions by using the Insert Rows fromdialogue box. For more information, see Add dimensions in a row definition .

Multiple-segment or multiple-dimension ranges

When you enter a range by using combinations of multiple dimension values, the range comparison is accomplished on a dimension-by-dimension basis. The range comparison cannot be accomplished on either a character-by-character basis or a partial segment basis.

For example, the range +Account=[5000:6000], Department=[1000:2000], Cost centre=[00]includes only the accounts that match each segment. In this scenario, the first dimension must be in the range from 5000 through 6000, the second dimension must be in the range from 1000 through 2000, and the last dimension must be 00. (For example, +Account=[5100], Department=[1100], Cost centre=[01]would not be included in the report because the last segment is out of the specified range.)

If a segment value includes spaces, enclose that value in square brackets [ ]. The following values are valid for a four-character segment: [ 234], [123 ], [1 34]

Dimension values should be enclosed in square brackets, which Management Reporter will do for you.

When a multiple-segment or multiple-dimension range includes wildcard characters ( ?or *), the low and high ends of the whole multiple-segment or multiple-dimension range is determined, and then all values between those ends are included, inclusively. If you have a large range, such as the whole range of accounts 40000 to 99999, you should specify a valid starting and ending account, when it is possible.

Note Note

Report Designer is unable to select any account, dimension, or field from the Microsoft Dynamics ERP system that includes the following reserved characters: & [ ]. You can add an ampersand ( &) only when you are automatically building row definitions by using the Insert Rows fromdialogue box. For more information, see Add dimensions in a row definition .

See Also