How can we modify the name of export report.
Hi,
When we take the export of a report then its name appeared in default format. We want to modify the name of report in the desired format(e.g. reportname_mmddyyyy). Is it possible we can modify the rdtemplate file for export file name.
Thanks
Seema
-
Hi Seema,
The Target.NativeExcel, Target.PDF, etc. elements have an 'Export Filename' attribute which you can set to whatever you'd like. We use a Local Datalayer to grab the Caption we have defined for our reports and we use that so that the Exports match the Caption that the user sees when they run the report. Our Target.NativeExcel, for example, is set up as follows:
<Target ExcelOutputFormat="Excel2007" ExportFilename="@Local.Caption~_@Date.Today~" FrameID="NewWindow" ShowGridlines="True" Type="NativeExcel">
<WaitPage />
</Target>So running this from the "Service Activity Analysis" report right now will give me
Service_Activity_Analysis_2021-08-23.xlsx
Cheers,
Johnny1 -
Hi Seema,
Your formula for the Export Filename would be something like:
='ReportName'_FormatDateTime('@Date.Today~','MMddyyyy')
Or you can piece together DatePart values to make the date you need if that doesn't work - https://devnet.logianalytics.com/hc/en-us/articles/4402744824087-Functions
Regards,
Johnny1 -
Hi Johnny,
We want in this format (e.g. reportname_mmddyyyy).means instead of yyyy-mm-dd.
Thanks,
Seema
0
Please sign in to leave a comment.
Comments
3 comments