Difference between revisions of "Comment Frame"
| Line 10: | Line 10: | ||
| − | When referencing an Excel range, the range must contain uniquenames. This is typically populated by a slicer which has the ' | + | When referencing an Excel range, the range must contain uniquenames. This is typically populated by a slicer which has the 'Update range with selection' property set. The range can be one or more columns. |
1 Column: Comments are retrieved for all members in the range | 1 Column: Comments are retrieved for all members in the range | ||
2 or more columns: Comments are retrieved for the combinations held in each row | 2 or more columns: Comments are retrieved for the combinations held in each row | ||
Revision as of 16:54, 17 October 2017
Comment Frames allow for the display of comments within a report. They can be used in 2 main ways:
1) Tied to a specified Grid, where they display all comments for the Grid, filtered by the current selections in place.
2) Tied to an Excel range containing uniquenames. Typically this approach would be used to display either higher level comments, or to build a report directly on the comments users have entered.
Comment frames are added from the Visualise menu.
When referencing an Excel range, the range must contain uniquenames. This is typically populated by a slicer which has the 'Update range with selection' property set. The range can be one or more columns.
1 Column: Comments are retrieved for all members in the range
2 or more columns: Comments are retrieved for the combinations held in each row
