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:
-
From the Grid Designer, select General Properties, and then set Title = Show. The Title bar is displayed above the grid.
-
In the top right of the text box, click .
-
Select either
MemberName
orMemberAlias
, and then specify the required Dimension parameters. The Dimension parameter is the POV dimension with multiple members selected and Print All Selections enabled. -
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.
-
Click to validate the text in the Title bar.
-
Optional: Set the format for the text and Title bar, such as font, alignment, shading and border, by clicking format next to the Title property, under the General Properties panel.
-
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
Figure 4-4 Displaying the Results of the Formula in the Header
Inserting the POV Selection in the Header
To insert a text function to display the POV selection in the header:
-
From the report header or footer, right-click and select Add Report Content, and then select Text.
-
Click or Setup Text.
-
In the top right of the text box, click .
-
Select either
MemberName
orMemberAlias
, 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. -
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.
-
Optional: Set the format for the text, such as font and alignment, in the text box properties panel.
-
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
Figure 4-6 Result of Formula to Display Segment POV in Header
Inserting the POV Selection in the Top Left Grid Cell
To insert a text function to display the POV selection in the header:
-
In Grid Designer, select the top left cell of the grid, which is a text cell.
-
In the top right of the formula bar, click .
-
Select either
MemberName
orMemberAlias
, 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. -
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.
-
Click to validate the text in the formula bar.
-
Optional: Set the format for the text, such as font and alignment, in the text box properties panel.
-
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
Figure 4-8 Result of Formula to Display Segment POV in Top Left Cell