Suppose you want to change the name of the repeatable item, EMPGRADE,
in the previous GROUP BY clause to EMPLEVEL:
Move the cursor to the groupingexpr fragment.
Press the NxtRpt function key (F11) to make EMPGRADE the current
repeatable item. Its color changes from yellow to green.
Press Enter. A pop-up panel is displayed showing the repeatable
item EMPGRADE already entered.
You can now edit the name of the column in the pop-up panel. Change
it to EMPLEVEL.
Press the Exit function key (F3). EMPGRADE is replaced by EMPLEVEL
in the GROUP BY statement.
Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.