Forum Stats

  • 3,852,764 Users
  • 2,264,135 Discussions
  • 7,905,134 Comments

Discussions

Displaying totals in the title area of a worksheet.

965863
965863 Member Posts: 1
edited Oct 3, 2012 8:03AM in Discoverer
Hi,


I'm using Oracle Business Intelligence Discoverer Plus 10g 10.1.2.55.26, We're running queries which are retrieving in excess of 10,000 rows .

Does anyone know of a method to display totals at the top of the page rather than the bottom as viewing the total means scrolling through 100s of pages. or is there a way to insert the totals into the title area.

Thanks

Answers

  • Rod West
    Rod West Member Posts: 4,025 Gold Trophy
    Hi,

    You can only display totals in the title area if it is a page item. So you could use an analytic funtion to calculate a total and have this as a page item.

    Another approach would be to use SQL, so for example, you could create a custom view containing a group by that uses grouping sets to create subtotal rows, and then sort the report so these appear at the top.

    In general, though it is better to create reports that return only the rows that you want, so a workbook returning 10000+ rows should have some additional parameters or worksheets so that users could for example, only return summary rows.

    Rod West
This discussion has been closed.