Basically I've written a report that looks like this:
SELECT DISTINCT ID, Sum(TOTAL_BILLING_HOURS),Sum(TOTAL_CREDIT_HOURS)
FROM AS_STUDENT_ENROLLMENT_SUMMARY
HAVING Sum(TOTAL_BILLING_HOURS) >= 175
GROUP BY ID
I've written my report(below) in webfocus, but I can't remember how to translate the Having statement into webfocus. Maybe it's just a brain **** today, but could someone help me?
TABLE FILE INIT_POP
SUM TOTAL_BILLING_HOURS TOTAL_CREDIT_HOURS OVERALL_LGPA_HOURS_EARNED
BY LAST_NAME NOPRINT
BY FIRST_NAME NOPRINT
BY ID
BY LAST_NAME
BY FIRST_NAME
ON TABLE PCHOLD FORMAT EXL2K
END
This message has been edited. Last edited by: Kerry,