| calculation in matrix report [message #621448] |
Wed, 13 August 2014 07:44  |
shahzad-ul-hasan
Messages: 643
Registered: August 2002
|
Senior Member |
|
|
Dear Sir,
I want to get this report.
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 3013 times)
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
