Auto text codes allow you to automatically display information in a document, such as page numbers, the current date and time, and report filter details. For example, you add the auto text code {&[Sales Forecast]:DESCRIPTION} to a document. When you view the document as a PDF, or display the document in Interactive, Express, or Flash Mode, the auto text code is automatically replaced with a text field containing the description of the Sales Forecast report. For steps to add an auto text code to a document, see Adding auto text codes to documents.
The following auto text codes allow you to add dataset information to your document. For all these codes, replace REPORTNAME with the name of the related dataset report. If the name contains any spaces or special characters, type the name within square brackets [ ]. For example, to display the report details for a report named Sales Forecast, type {&[Sales Forecast]:REPORTDETAILS}. Special characters are defined as anything other than a-z, A-Z, #, _, . (period), and 0-9.
|
Description |
Code |
Sample Output |
Comments |
|
Dataset report description |
{&REPORTNAME:DESCRIPTION} |
Revenue, profit, & cost by employee & region |
The short description of the specified dataset report. If the report does not have a description, the text field remains blank. |
|
Dataset report details |
{&REPORTNAME:REPORTDETAILS} |
Report Description: Revenue, profit, & cost by region & employee Report Filter: (2007) Filter for Year = 2007 Year = 2007 Report Limits: Revenue > 2000000 Template: Region, Employee Metrics: Revenue, Revenue {~+}, Cost, Sum(Cost){~+}, Profit, Sum(Profit){~+} |
The complete report details, including report description, prompt details, filter details, and template details of the specified dataset report. You can define how this auto text code is displayed (for example, if the report description is shown). For steps, see Configuring auto text codes. |
|
Dataset report filter and limit details |
{&REPORTNAME: FILTERDETAILS} or {&FILTERDETAILS} |
If the filter in the dataset's Filter Editor is defined as: A=1 AND B=2 OR C=3 it prints as: A=1 and (B=2 or C=3) For example, Region=South and (Year=2002 or Year=2003) |
The report filter and report limit used in the dataset report. An example is {&[Sales Forecast]: FILTERDETAILS} for the Sales Forecast report. If the dataset report has a report filter and a report limit, the system displays OR between them. If there is no filter, Empty Filter is displayed. If there is no limit, Empty Limit is displayed. If you do not replace REPORTNAME with the name of the dataset report, the filter and limit information from the document’s grouping and sorting dataset is printed. By default, only the report filter and report limit are displayed, but other filters, such as view filters and security filters, can be displayed as well. |
|
Dataset report prompt details |
{&REPORTNAME: PROMPTDETAILS} |
Prompt 1: Region prompt Northwest, Southwest Prompt 2: Year Year (ID)= 2007 |
The prompt information for all prompts in the specified dataset report. You can define how this auto text code is displayed (for example, if the prompt name is shown). For steps, see Configuring auto text codes. |
|
Dataset report filter details |
{&REPORTNAME: REPORTFILTER DETAILS} |
Report Filter: Year = 2007 |
The report filter used in the specified dataset report. If you do not replace REPORTNAME with the name of the dataset report, the filter information from the document's grouping and sorting dataset is printed. |
|
Dataset report limit details |
{&REPORTNAME: REPORTLIMIT DETAILS} |
Report Limits: Revenue > 2000000 |
The report limit used in the specified dataset report. If you do not replace REPORTNAME with the name of the dataset report, the report limit information from the document's grouping and sorting dataset is printed. |
|
Dataset report template details |
{&REPORTNAME: TEMPLATEDETAILS} |
Template: Region, Employee Metrics: Revenue, Revenue {~+}, Cost, Sum(Cost){~+}, Profit, Sum(Profit){~+} |
The complete template details, including attribute details and metric details. You can define how this auto text code is displayed (for example, if the template name is shown). For steps, see Configuring auto text codes. |
|
Dataset report execution time |
{&REPORTNAME: EXECUTIONTIME} |
11/15/2003 7:10:55 PM |
Displays the date and time the dataset report was executed, or, for an Intelligent Cube, the cube publication date and time. |
To format these codes, see About formatting auto text codes. You can format what is displayed (such as whether to include view filter information) and how it is displayed (such as whether to use a comma or the word AND).
Related topics