Skip to main content
Question

21R2 Excel report giving an error

  • December 27, 2022
  • 1 reply
  • 182 views

Forum|alt.badge.img+6

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

Mathias Dahl
Superhero (Employee)
Forum|alt.badge.img+32
  • Superhero (Employee)
  • 2826 replies
  • January 2, 2023

Moved to Framework section.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings