Export File Name

Export File Name

When exporting reports (or sending via e-mail) into different formats (.pdf, .rtf, .xls,...) a custom name of exported report can be generated. Cusom name can only be set for custom reports (not system reports).

Different fields from Report Tree of Report Designer can be used:

Applicable fields for each report can also be seen from Overview of SQL queries of all data sets on specific form/report:

From Datasets select a record qReportIzpisXY and execute a sql statement. Fields in a resoult can be used for export naming.

From Datasets select a record qReportIzpisXY. Fields in a resoult can be used for export naming.

Example: Order_#qReportIzpisD.acKey#_#qReportIzpisS.acSubject# results in report name when exporting: Naročilo_1801000000002_Datalab d.d..pdf

Fields must be separated with #. Text can be used in sting.

Result when exporting a report.

Or sending a report via e-mail.

Some examples for copy of report 000 - Cash journal by payment methods and copy of report 241 - Invoice

Report 000:
Report_#fDateDue# - memo on the report
Report_#fDateDue\YYYYMMDD# - memo on the report with formatting
Report_#qReportIzpis.acKey#_#fDateDue\YYYYMMDD# -dataset on the report, FieldName acKey
Dnevnik_#mTitle2#_#Date#

Report 241:
Text_#mTitle1#_#fKljuc#_#Date\YYYYMMDD# - result: Text_Invoice_19-300-000011_27.03.2019.pdf
Text_#mTitle1#_#qReportIzpisD.acKey#_#Date\YYYYMMDD# - result: Text_Invoice_1930000000011_27.03.2019.pdf
Text_#mTitle1#_#qReportIzpisD.acKey#_#qReportIzpisS.acSubject#_#Date\YYYYMMDD - result: Text_Invoice_1930000000011_Datalab d.d._27.03.2019.pdf

Formatting is used for DateTime macros only. If formatting is used for none-DateTime macros, formatting will be ingnored.