Home » Developer & Programmer » Reports & Discoverer » calculation in matrix report
calculation in matrix report [message #621448] Wed, 13 August 2014 07:44 Go to next message
shahzad-ul-hasan
Messages: 561
Registered: August 2002
Senior Member
Dear Sir,
I want to get this report./forum/fa/12102/0/
If one student want to read all (6) subject then fee will be dvided on subject percentage.
or if the student want to read 2 or 3 subject then amount will be divided on subject amount not in percentage...
Report Query is
SELECT DISTINCT TP.TCLASS, TPD.TSUB, TPD.TPCT, TPD.TPM, STUDENT.ID, 
STUDENT.GROP, STUDENT.NAME || ' / ' ||STUDENT.F_NAME Na,  FEE.RECP
FROM FEE, STUDENT, TP, TPD
WHERE ((FEE.ID = STUDENT.ID)
 AND (TPD.TDATE = TP.TDATE
 AND TPD.TID = TP.TID)
 AND (TP.TCLASS = STUDENT.CLASS)) 
AND FSTAT='RECEIVED'
AND STAT='PRESENT'
order by student.id
  • Attachment: 1.JPG
    (Size: 16.45KB, Downloaded 493 times)
Re: calculation in matrix report [message #621449 is a reply to message #621448] Wed, 13 August 2014 07:45 Go to previous messageGo to next message
shahzad-ul-hasan
Messages: 561
Registered: August 2002
Senior Member
/forum/fa/12103/0/
Another picture..
  • Attachment: 2.JPG
    (Size: 38.96KB, Downloaded 470 times)
Re: calculation in matrix report [message #621450 is a reply to message #621449] Wed, 13 August 2014 07:46 Go to previous messageGo to next message
shahzad-ul-hasan
Messages: 561
Registered: August 2002
Senior Member
/forum/fa/12104/0/
  • Attachment: 3.JPG
    (Size: 41.20KB, Downloaded 366 times)
Re: calculation in matrix report [message #621998 is a reply to message #621450] Wed, 20 August 2014 06:11 Go to previous message
bluetooth420
Messages: 141
Registered: November 2011
Senior Member
Your percentage total is greater than 1.00 (more than 100%).

Subject PS is spotted in required image but absent in setup.

Need your table structure/data.
Previous Topic: rep-4202 error occurred while logging on to the mail subsystem
Next Topic: Can I use parameters in views to be called in Discoverer
Goto Forum:
  


Current Time: Sat Jul 04 17:38:01 CDT 2020