PH46307: BIRT REPORT IN RSAD4WS 9.7 GENERATES MULTIPLE SHEETS

APAR status

• Closed as Vendor Solution.

Error description

• When generating BIRT Reports using RSAD4WS 9.7, the output excel
  file contains multiple sheets with 41 rows on each sheet.
  Compared to the previous version, which is RSAD4WS 9.5, the
  output excel file contains all the information in one sheet.
  
  The steps below are followed:
  
  Right-click on the *.rptdesign class.
  Select Report As >> Report Configurations.
  Under ClassGeneralizations, indicate the location of the
  *.rptdesign file.
  Under the Report Output, choose .xlsx as the format of the file.
  Click Report.
  
  
  One distinction noticed was on RSAD4WS 9.5, the file format was
  .xls and on RSAD4WS 9.7 it is .xlsx.
  

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

• As the issue is in uk.co.spudsoft.birt.emitters.excel plugin
  which is outside RSAD codebase, refer technote
  https://www.ibm.com/support/pages/node/6605339 to resolve the
  issue.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels