By entering these custom values as report parameters, you can customize the file for each user.
| Code | Description |
| %date% | Inserts the current date. |
| %time% | Inserts the current time. |
| %datetime% | Inserts the current date and time. |
| %rolename% | Inserts the database role or roles that are being used. |
| %groupname% | Inserts the name of the distribution group. |
| %distributionlist% | Inserts the name of the distribution list. |
| %email% | Inserts the email address of the recipient. Ignored if %emailtosendto% is also used. |
| %displayname% | Inserts the display name of the recipient. Ignored if %emailtosendto% is also used. |
| %sendiftrue% | Triggers sending of the report. May only be used once per report. |
| %emailtosendto% | Retrieves a comma-delimited list of email addresses from the report. May only be used once per schedule. |
%sendiftrue%
If %sendiftrue% is used, the report will be generated normally, but only sent to users if this parameter is calculated to be TRUE.
This allows exception reporting. For example, if you had names defined in Excel, you could set the formula in the parameter cell to be
=Or(Sales < 1000, Losses > 50)
The report can be published with the exception-detecting cell exposed as a Web Parameter:
This parameter can then be used as the %sendiftrue% parameter when selecting a report to set up the schedule.
%emailtosendto%
Retrieves a comma-delimited list of email addresses from the report. May only be used once per schedule.
If %emailtosendto% is used, the email addresses in the schedule or distribution group will be ignored. The addresses from this parameter will be used instead. The value in the cell may be either one email address or a comma-delimited list.
Note that this parameter overrides the %email% and %displayname% parameters.
