Excel Report Layout Missing Field Data

​@rbishop_para  Hi Ryan - Two things I can think of to check…

In your plug-in file, are you listing each column by name?  I’ve had problems doing this if the names don’t exactly match the XML including spaces before or after the commas.

I think you want to check the XML output, not the _REP view to determine which fields do and don’t have data.  Run the report so you get a record in the Report Archive, then use the button to export the XML.

Hey Tracy,

I’m not listing each column by name in the plugin file.  I’m using IFS’ example plugin file.  I’ve tried tweaking settings under the flattened-xml tag but had no luck.

<?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>E-MAIL</output-method> <!-- BINARY,FILE,E-MAIL this can be more that one value separated by ; -->
         <output-name></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></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-sender>
            <e-mail-cc></e-mail-cc>
            <e-mail-subject>Excel report [#ReportTitle] is ready.</e-mail-subject>
            <e-mail-body><![CDATA[Printjob: [#PrintJobId] has finished executing. Excel report attached.]]></e-mail-body>
            <file-directory></file-directory> <!-- overrides the system set output directory -->
            <binary></binary>
         </default-output-reference>
         <full-xml>TRUE</full-xml>
         <flattened-xml>
            <enabled>TRUE</enabled>
            <strongtyping>TRUE</strongtyping>
            <full-xsd-column-set>ON</full-xsd-column-set>
            <document-model>ON</document-model>
         </flattened-xml>
         <report-id>ORDER_QUOTATION_REP,CUSTOMER_AGE_REP,VEND1099_INFO_REP</report-id> <!-- For which reports should IFS installer register this layout. -->
         <report-title>Excel Layout</report-title> <!-- Title used when installed via IFS Installer -->
      </properties>
      <plugin>
         <properties>
            <use-display-names>ON</use-display-names>
            <excel-template>[#ReportId]_TEMP.xlsx</excel-template> <!-- This line makes this layout dynamic. Just install the Report Template following the name standard -->
            <include-columns></include-columns>
            <exclude-columns></exclude-columns>
         </properties>
      </plugin>
</report-layout>

When I examine the XML from the Print Manager, I have values in all fields.  

In my excel file, I use the default tag to show all fields and use their non-translated field name.  This is IFS’ recommendation to view all data, but still these handful of columns do not populate.

[@REPORT-DATA {Options:InsertRows=ON, DisplayNames=OFF}]

Thanks

​@rbishop_para  The tech docs have mentioned (for a while) that the Excel plugin is deprecated, but we found that the Excel Template was deprecated, but the simple Excel plugin still works, at least in 23r2.  

I’ll see if I have time today to test in 24r2 with the simpler plugin file we’ve used successfully in 23r2. File is shown below if you want to see if it makes any difference in your environment.

<?xml version="1.0" encoding="UTF-8"?>
   <report-layout>
      <properties>
         <version>9.0</version>
         <layout-type>EXCEL</layout-type>
         <plugin-class>ifs.application.reportingservices.impl.extendedformatter.excelplugin.ExcelPlugin</plugin-class>
         <output-method></output-method>
         <output-name></output-name>
         <output-extension>xlsx</output-extension>
         <default-output-reference> 
            <e-mail></e-mail>
            <e-mail-sender></e-mail-sender>
            <e-mail-cc></e-mail-cc>
            <e-mail-subject>Excel report [#ReportTitle] is ready.</e-mail-subject>
            <e-mail-body><![CDATA[Printjob: [#PrintJobId] has finished executing. Excel report attached.]]></e-mail-body>
            <file-sender></file-sender>
            <binary></binary>
         </default-output-reference>
         <full-xml>TRUE</full-xml>
         <flattened-xml>
            <enabled>TRUE</enabled>
            <strongtyping>TRUE</strongtyping>
         </flattened-xml>
         <report-id>VEND1099_INFO_REP</report-id>
         <report-title>Excel</report-title>
      </properties>
      <plugin>
         <properties>
            <use-display-names>ON</use-display-names>
            <include-columns></include-columns>
            <exclude-columns></exclude-columns>
         </properties>
      </plugin>
</report-layout>

This plugin created the excel file successfully, but still the MISC_1099_INCOME_AMOUNT_PAID column is blank in the excel file.  So far I’m having the same results with the Excel plugin, Simple Excel, and CSV.  I get data in other fields but not this one.  The report XML has a value in the field and the printed report looks fine as well.  I’m wondering if the field name length is too long or having numbers in the field name is causing issues with the plugin.  

I think I will abandon this approach and just make a quick report using the same queries from the RPI.