Adding Dynamic Titles in Microsoft Office

Generation QR Code in Microsoft Office Adding Dynamic Titles

Adding dynamic titles to a report can allow users to see what was selected on the prompt screen For our example, we continue to use the example report created throughout the chapter, to which we have added the title Gross Profit Margin Here s how to add dynamic titles to a report: 1 In the Insertable Objects pane, click the Toolbox tab 2 Drag a Block object below the title of the report 3 From the Insertable Objects pane, drag a Text Item to the block 4 Click OK without adding any text A text object displays in the block object, as shown next:

5 In the block object, click the Text Item 6 In the Properties pane, set the Source Type property to Report Expression (by default it is set to Text) 7 Click the ellipsis at the right of the Report Expression property The Report Expression window displays 8 In the Available Components pane, click the Parameters tab

9:

9 Double-click a parameter to add it to the expression In this example, we add Product line The expression ParamDisplayValue( Product line ) is added to the Expression Definition pane:

10 Click OK In this example, we repeat steps 1 through 9 to add a second dynamic title for the parameter for Product Type 11 From the Standard toolbar, click Run Report The prompt screen displays 12 From the prompts, make your selections 13 Click Finish In this example, we select Camping Equipment at the Product line prompt, and from the Product Type list, we select Cooking Gear and Lanterns The report displays the items that you selected in the prompt below the title and above the list report, as shown next:

Adding formatting to parameters makes it easier for end users to locate and view data on the report For this example, we continue to use the example report created throughout this chapter Here s how to add formatting to parameters in a report: 1 Select the Block objects that contain the title of the report and the dynamic title(s) created in the previous section

on objects 2 In the Properties pane, click the ellipsis to the right of the Padding property The Padding window displays

Part III:

3 Add padding to the objects In this illustration, we add 7 pixels of padding to the Top and Bottom of the object and leave the Left and Right padding blank

4 Click OK 5 Select the Block object that contains the dynamic title 6 In the Properties pane, double-click the Border property The Border window displays 7 Add any borders to the object you would like In this example, we have two dynamic titles We add a top border to the first and a bottom border to the second 8 From the Toolbox tab in the Insertable Objects pane, drag a Text Item in front of the parameter in the Block that contains the dynamic title The Text dialog box displays 9 Type descriptive text for the parameter Be sure to leave a space after the text so that the text and the parameter do not run together, and then click OK We add the text Product Line: for our first parameter and then repeat steps 6 and 7 to add Product Type(s): for the second parameter 10 From the Style toolbar, you can use features such as Bold, Foreground Color, and Font to format the text We make our text Bold and change the Foreground color to Blue 11 From the Standard toolbar, click Run Report The results display:

9:

The dynamic title stands out after the basic formatting we have applied to it You can also use similar formatting techniques on the Prompt page to make it easier for the end user to read