Question

21R2 Excel report giving an error

  • 28 December 2022
  • 1 reply
  • 123 views

Userlevel 2
Badge +5

I have followed the below steps.

  1.  rpl file
  2. <?xml version="1.0" encoding="UTF-8"?>
    <report-layout>
       <properties>
          <version>9.0</version>
          <layout-type>
    EXCEL</layout-type>
          <!--SCRIPT,XSL,XML,EXCEL,SIMPLE EXCEL-->
          <plugin-class>ifs.application.reportingservices.impl.extendedformatter.excelplugin.ExcelPlugin</plugin-class>
          <output-method>
    FILE</output-method>
          <!-- BINARY,FILE,E-MAIL this can be more that one value separated by ; -->
          <output-name />
          <!-- This will default to "ReportId"_"ResultKey" if left empty. You can add a path as part of the filename. -->
          <output-extension>xlsx</output-extension>
          <!-- The file name and attachment name will be a concatenation of <output-name> and <output-extension>. -->
          <default-output-reference>
             <e-mail />
             <!-- if left empty, it will use the email adress in the print dialog or if not defined it will use the sender address instead (send to yourself). Make sure each user has his own email adress set correctly. -->
             <e-mail-sender />
             <e-mail-cc />
             <e-mail-subject>Excel report Lm Test Second is ready.</e-mail-subject>
             <e-mail-body><![CDATA[Printjob: [#PrintJobId] has finished executing. Excel report attached.]]></e-mail-body>
             <file-sender />
             <!-- File Sender name configured in solution manager -->
             <binary />
          </default-output-reference>
          <full-xml>TRUE</full-xml>
          <flattened-xml>
             <enabled>TRUE</enabled>
             <strongtyping>TRUE</strongtyping>
             <full-xsd-column-set>OFF</full-xsd-column-set>
             <document-model>OFF</document-model>
          </flattened-xml>
          <report-id>LM_TEST_SECOND_REP</report-id>
          <!-- For which reports should IFS installer register this layout. -->
          <report-title>Lm Test Second</report-title>
          <!-- Title used when installed via IFS Installer -->
       </properties>
       <plugin>
          <properties>
             <use-display-names>ON</use-display-names>
             <excel-template>
    LM_TEST_SECOND_REP_TEMP.xlsx</excel-template>
             <!-- This line makes this layout dynamic. Just install the Report Template following the name standard -->
             <include-columns />
             <exclude-columns />
          </properties>
       </plugin>
    </report-layout>
  3. Report Designer layout is working fine. But for the excel output it’s giving below error.

  4. I could see the generated xml file in the ‘Print Manager’. But the Excel file isn’t going to download. Did I miss something? 

 


1 reply

Userlevel 7
Badge +30

Moved to Framework section.

Reply