This procedure explains how to include revision data in customized registered reports. Note, that the shipped reports already include this code in the templates.
You can display as many revision levels as you require.
-
Select Reports > Edit.
-
On the Edit Report Template dialog, select a registered report template.
-
Select Open.
-
In the Excel report template, select the cells for the revision headers and type the header text in the selected cells.
If you want the revision information to appear at the top of the report, select the cells in the Header section of the template.
-
Select another cell to contain the revision data.
-
In the Name Box, type the appropriate name for mapping the required revision data, for example:
-
Press ENTER.
-
After adding all the required revision data, save the Excel template.
-
The following revision mapping names are available:
-
LastRevision (same as RevisionNumber_1)
-
RevisionNumber_1
-
RevisionDate_1
-
CreateBy_1
-
CheckBy_1
-
ApproveBy_1
-
RevisionDescription_1
-
-
You can include as many revision levels as you need. You specify the revision number by adding an underscore (_) followed by a number to the mapping name. The lowest number that follows the underscore retrieves the latest revision. For example, if you want to specify the data indicated for 4 revision numbers in the document in descending sequence, you need to include the mapping names (one name per cell) in the following order:
Revision
By
Date
RevisionNumber_1
CreateBy_1
RevisionDate_1
RevisionNumber_2
CreateBy_2
RevisionDate_2
RevisionNumber_3
CreateBy_3
RevisionDate_3
RevisionNumber_4
CreateBy_4
RevisionDate_4