Skip to main content

How can we modify the name of export report.

Comments

3 comments

  • Johnny Stevens

    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

    Hi Johnny,

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

    Thanks,

    Seema

     

    0
  • Johnny Stevens

    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.