Last updated on JUNE 28, 2017
Applies to:BI Publisher (formerly XML Publisher) - Version 220.127.116.11.0 to 18.104.22.168.x [Release 11.1]
Information in this document applies to any platform.
Designing reports using Excel using the Report Design guide: http://docs.oracle.com/cd/E28280_01/bi.1111/e22254.pdf , the reports work and deploy in BI Publisher server. If it's using 4 or 5 groups defined in BI Publisher data model, the excel sheet preview looks very strange. In some cases it places multiple line items within a single Excel cell and in the other case it removes a large portion of the data from the spreadsheet. The concept of grouping according to the document is very straight forward
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms