Applying Dynamic Names for Published Result Files

This topic describes how you can use dynamic result file name and dynamic directory path to save report results when you publish a report to disk or to email.

If you schedule to publish the report result periodically with a fixed name, then Server only keeps the last generated report result. To save the result generated every time, you need to use a dynamic result file name. Similarly, you can use a dynamic directory path to avoid report management difficulties, since for a fixed directory path too many results might be generated in a single folder.

Logi Report Server provides you with the following defined strings to form a dynamic name:

By	Strings Defined	Description (Sample)
Time	Form the file name using the date/time when the result is generated (for example, 2006-07-25, 00:00:00 AM).
>	yyyy	Return the year (for example, 2006).
	yy	Return the year in short form (for example, 06).
	MM	Return the month of the year, shown in number format (for example, 12).
	dd	Return the day of the month, (for example, 25).
	hh	Return the hour of the day (for example, 05). It is for the 12-hour time.
	HH	Return the hour of the day (for example, 05). It is for the 24-hour time.
	mm	Return the minute of the hour (for example, 00).
	ss	Return the second of the minute (for example, 00).
	m	Return the AM/PM marker (for example, AM).
	+/-	Perform the +/- operation on the date/time (for example, if current date is June 20, the result of [dd+2] is 22 and that of [dd-5] is 15 ).
Parameter		Form the file name using the parameter value specified for <param_name>.
	param_<param_name>	Return the value of <param_name>.
	paramDisplay_<param_name>	Return the display value of <param_name>.
User		Form the file name using username.
	name	Return the name of the user who currently signed in to the computer (for example, Mike).
	z	Return the ordinal number (for example, 001.pdf, 002.pdf, and 003.pdf).
System		Form the file name using the system variables.
	language	Return local computer configuration language (for example, en).
	zone	Return the system configuration time zone (for example, GMT-05.00).
	encoding	Return the file encoding (for example, Cp1252).
	region	Return the system configuration region (for example, US).
Logi Report
	pathcat	Return the catalog file name, with its path and extension (for example, path.SampleReports.cat).
	CAT	Return the catalog file name, with its extension (for example, SampleReports.cat).
	cat	Return the catalog file name, without its path and extension (for example, SampleReports).
	pathcls	Return the report file name, with its full path (for example, catalog path and report path) and extension (for example, path1.path2.Employee Information List.cls).
	CLS	Return the report file name, with its extension (for example, Employee Information List.cls).
	cls	Return the report file name, without its extension and path (for example, Employee Information List).
	sheet	Return the report tab name in the report (for example, report1). However, for formats such as .rst, .rsd, and .wst, Server interprets the string "[sheet]" literally as "[sheet]" itself.

Naming rules

The defined strings are case-sensitive.
You must enclose defined strings by square brackets ([ ]) which must appear in pairs, for example, [yyyy].
If the string is not a defined string but enclosed by square brackets, Server will display an error message. For example, if you use myHTMLResult_[yy]$[YYYY][MM]M[dd]D[ABCD] $name$cls[cls].html as the result file name, you will get an error message saying Invalid file name, since ABCD is not defined, but appears in square brackets.
You should never use square brackets to enclose strings that are not defined in the preceding table. Strings that are not in square brackets will be directly used as (part of) the file name.
If you want the square brackets and the strings enclosed by them to appear in the file name exactly as they are, that is, not to be parsed as defined strings, you can add a dollar sign ($) before the string. For example, if the string is $[yyyy], the result file name will be [yyyy], instead of a specific year, such as 2006.
If you want to keep the dollar sign ($) together with the square brackets and the strings, you should add another dollar sign ($). For example, if the string is $$[m], the result file name will be $[m], and if the string is $$$$[m], the result file name will be $$$[m].
You can use more than one defined string in the dynamic result file name, except for the ordinal number (z), such as [m][name], [yyyy].[MM].[dd], [region][yy].
You can add characters between different defined strings. For example, if the string is [yy]Year[MM]Month, the result could be 02Year2thMonth.
The number of digits of the ordinal number is determined by the total number of "z"s. For example, zzz indicates 001, 002, and so on, and zz indicates 01, 02, and so on.

See the following examples of the dynamic result file name:

Sample Name	Result File Name
myTXTResult_[yyyy].[MM].[dd].[hh].[mm].[ss].txt	myTXTResult_2003.10.30.05.14.45.txt
myTXTResult_[MM-1].[param_pCountry].[param_pDate].[param_pTime].txt	myTxtResult_05.China_USA.29.param_pTime.txt
myPDFResult_CT[zone][language][region]my$$[1].pdf	myPDFResult_CTGMT-05.00enUSmy$[1].pdf
myRSTResult_[pathcat][CLS].rst	myRSTResult_SampleReports.SampleReports.catEmployee Information List.cls.rst
myRSTResult_[zzz].rst	myRSTResult_001.rst, myRSTResult_002.rst, ...
myHTMLResult[cat]_[cls]_[zz].html	myHTMLResultSampleReports_Corporate Overview_01.html, myHTMLResultSampleReports_Corporate Overview_02.html,...
myHTMLResult_[yy]$[YYYY][MM]M[dd]D$name$cls[cls].html	myHTMLResult_02[YYYY]06M21D$name$clsCorporate Overview.html

Note icon

There are two differences between the naming rules of dynamic result file name and the dynamic directory name:
- Server only supports the string "z" in the naming result file, but not in the naming dynamic directory. For example, C:\folder[zz]\folder is incorrect because Server does not support the sequence for directory.
- Server replaces "/" by "." in the naming result file. However, for naming a dynamic directory, this rule does not apply.
When you publish a report to email, string "z" is not dynamic. For example, zzz only indicates 001 and zz only indicates 01.

Previous Topic Next Topic