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

/forum/fa/14697/0/
  • Attachment: 222.jpg
    (Size: 38.03KB, Downloaded 1934 times)
Re: subject total in matrix with group report [message #687448 is a reply to message #687447] Fri, 10 March 2023 05:52 Go to previous messageGo to next message
shahzad-ul-hasan
Messages: 615
Registered: 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 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

+?

Re: subject total in matrix with group report [message #687450 is a reply to message #687449] Fri, 10 March 2023 10:36 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9077
Registered: 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:

Return to the Report Wizard by choosing Tools > Report Wizard.


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 Go to previous messageGo to next message
shahzad-ul-hasan
Messages: 615
Registered: August 2002
Senior Member
please see the attached file.
/forum/fa/14698/0/

[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 Go to previous messageGo to next message
shahzad-ul-hasan
Messages: 615
Registered: 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 Go to previous message
shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi
Senior Member
Dear Shahzad

Can you share this report so i can fixed and return you the same report its will help you

On report Data module there is option called summary column you need to create it its will

Previous Topic: Hyperlink report to report
Next Topic: Hyperlink report to report
Goto Forum:
  


Current Time: Thu Mar 28 14:19:38 CDT 2024