Home » Developer & Programmer » Reports & Discoverer » subject total in matrix with group report (6i, 10g)
subject total in matrix with group report Fri, 10 March 2023 03:58
 shahzad-ul-hasan Messages: 615Registered: August 2002 Senior Member
i want to get a total of subject in matrix report. but cannot get. please help me.

• Attachment: 222.jpg
Re: subject total in matrix with group report [message #687448 is a reply to message #687447] Fri, 10 March 2023 05:52
 shahzad-ul-hasan Messages: 615Registered: August 2002 Senior Member
i want to calculate the row wise total. of each subject
Re: subject total in matrix with group report [message #687449 is a reply to message #687448] Fri, 10 March 2023 06:22
 Michel Cadot Messages: 68600Registered: March 2007 Location: Nanterre, France, http://... Senior MemberAccount Moderator

+?

Re: subject total in matrix with group report [message #687450 is a reply to message #687449] Fri, 10 March 2023 10:36
 Barbara Boehmer Messages: 9077Registered: November 2002 Location: California, USA Senior Member
Please see the following sections of Oracle® Reports Building Reports 10g Release 2 (10.1.2).

This section gives a detailed example that you can follow one step at at time.
25 Building a Matrix Report
https://docs.oracle.com/cd/B14099_19/bi.1012/b13895/orbr_matrix.htm

This section should be particularly helpful
25.4 Add summaries to the single-query matrix
https://docs.oracle.com/cd/B14099_19/bi.1012/b13895/orbr_matrix.htm#i1012661

If you follow the full example and compare to what you have, then all you need to do is substitute your column names for the ones in their example. Here is an excerpt

"25.4 Add summaries to the single-query matrix
To make your matrix report more useful, you should add summaries of each row and column in the matrix, and the whole report. In the single-query case, you can add these summaries very easily with the Report Wizard. In the multiquery case, you would need to add the summaries manually and then use the Report Wizard to create fields for them.

The steps below describe the procedure for adding summaries to the single-query matrix.

To add summaries to a single-query matrix:

Note:

Although you can use the Report Wizard to add summaries to a single-query matrix, you cannot use this method for a multiquery matrix.
On the Report Type page, select Create Paper Layout only.

On the Totals page, click SUM_SAL in the Available Fields list, then click Sum.

Tip:

You may have to use the arrows to make the Totals tab visible.
Click Finish to preview your report output in the Paper Design view.

Note:

When your new layout is created, you should notice a couple of things. First, at the bottom of each column of the matrix, you should now see a summary of that column's values. The report is also probably more than one page long now. Because of the width of the layout, the summaries for the departments cannot fit on the page with the rest of the matrix. Hence, the department summaries and the report summary overflow to the next page. Go to the second page of the report and you will see the department summaries and the report summary."

If this is not sufficient, then please post the query that you used to create what you have posted.
Re: subject total in matrix with group report [message #687465 is a reply to message #687450] Sat, 11 March 2023 03:39
 shahzad-ul-hasan Messages: 615Registered: August 2002 Senior Member

[Updated on: Sat, 11 March 2023 03:40]

Report message to a moderator

Re: subject total in matrix with group report [message #687499 is a reply to message #687449] Tue, 21 March 2023 08:36
 shahzad-ul-hasan Messages: 615Registered: August 2002 Senior Member
Sum totmarks by each subject in matrix report.
Quote:

whatever Barbara said can't understand.

Re: subject total in matrix with group report [message #687884 is a reply to message #687499] Mon, 10 July 2023 04:39
 shahzaib_4vip@hotmail.com Messages: 410Registered: December 2008 Location: karachi Senior Member