How can we modify the name of export report.

Seema Verma

• August 23, 2021 11:11

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

0

• 

  Johnny Stevens

  • Logi Info Ninja
  • Logi Forum Guru
  • August 23, 2021 12:54

  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,
  Johnny

  1
• 

  Seema Verma

  • August 25, 2021 05:15

  Hi Johnny,

  We want in this format (e.g. reportname_mmddyyyy).means instead of yyyy-mm-dd.

  Thanks,

  Seema

   

  0
• 

  Johnny Stevens

  • Logi Info Ninja
  • Logi Forum Guru
  • August 25, 2021 13:24

  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,
  Johnny

  1

Please sign in to leave a comment.