Displaying the Printable Page Member

When a POV dimension has multiple members selected and Print All Selections enabled, the PDF Preview of the report displays separate pages for each POV member, but the member name is not displayed in the PDF output of the report.

To display the member name or alias for the POV dimension in the report, you can use the MemberName or MemberAlias text functions in a grid title, text box or grid text cell. The top left cell in a grid is a text cell that can include text functions.

Inserting the POV Selection in the Grid Title

To enable the grid title and insert a text function to display the POV selection:

  1. From the Grid Designer, select General Properties, and then set Title = Show. The Title bar is displayed above the grid.

  2. In the top right of the text box, click text functions.

  3. Select either MemberName or MemberAlias, and then specify the required Dimension parameters. The Dimension parameter is the POV dimension with multiple members selected and Print All Selections enabled.

  4. Click Select to add the text function to the text box. You can add additional text as required, for example "Current Month:", before or after the text function.

  5. Click accept icon to validate the text in the Title bar.

  6. Optional: Set the format for the text and Title bar, such as font, alignment, shading and border, by clicking format text box next to the Title property, under the General Properties panel.

  7. Click Close to return to the report design. When previewing the report in HTML or PDF, the POV dimension member will display for each page of the report in the top of the grid.

Figure 4-3 shows an example of using the MemberAlias function to display the Segment POV member in the Grid Title, and Figure 4-4 shows the results of that formula, with "All Segments" displaying in the header on page one and "Televisions" on page two.

Figure 4-3 Displaying the Segment POV member in the Grid Title


grid property

Figure 4-4 Displaying the Results of the Formula in the Header


POV Selection in the Header

Inserting the POV Selection in the Header

To insert a text function to display the POV selection in the header:

  1. From the report header or footer, right-click and select Add Report Content, and then select Text.

  2. Click edit or Setup Text.

  3. In the top right of the text box, click text functions.

  4. Select either MemberName or MemberAlias, and then specify the required parameters such as Grid and Dimension. The Dimension parameter is the POV dimension with multiple members selected and Print All Selections enabled.

  5. Click Select to add the text function to the text box. You can add additional text as required, for example "Current Month:", before or after the text function.

  6. Optional: Set the format for the text, such as font and alignment, in the text box properties panel.

  7. Click Close to return to the report design. When previewing the report in PDF, the POV dimension member will display for each page of the report in the page header.

Figure 4-5 shows an example of using the MemberAlias function to display the Segment POV member in the header, and Figure 4-6 shows the results of that formula, with "All Segments" displaying in the header on page one and "Televisions" on page two.

Figure 4-5 Formula to Display Segment POV in Header


screenshot showing this formula: Segment: MemberAlias("Grid 1", "Segments") in header

Figure 4-6 Result of Formula to Display Segment POV in Header


screenshot showing result of formula showing All Segments on page 1 and Televisions on page 2

Inserting the POV Selection in the Top Left Grid Cell

To insert a text function to display the POV selection in the header:

  1. In Grid Designer, select the top left cell of the grid, which is a text cell.

  2. In the top right of the formula bar, click text functions.

  3. Select either MemberName or MemberAlias, and then specify the required parameters such as Grid and Dimension. The Dimension parameter is the POV dimension with multiple members selected and Print All Selections enabled.

  4. Click Select to add the text function to the text box. You can add additional text as required, for example "Current Month:", before or after the text function.

  5. Click accept to validate the text in the formula bar.

  6. Optional: Set the format for the text, such as font and alignment, in the text box properties panel.

  7. Click Close to return to the report design. When previewing the report in PDF, the POV dimension member will display for each page of the report in the top left cell of the grid.

Figure 4-7 shows an example of using the MemberAlias function to display the Segment POV member in the top left cell, and Figure 4-8 shows the results of that formula, with "All Segments" displaying in the top left cell of page one and "Televisions" on page two.

Figure 4-7 Formula to Display Segment POV in Top Left Cell


screenshot showing this formula: Segment: MemberAlias("Grid 1", "Segments") in top left cell

Figure 4-8 Result of Formula to Display Segment POV in Top Left Cell


screenshot showing result of formula showing All Segments on page 1 and Televisions on page 2