problem to run MySQL Aggregate Functions in birt 2.1.1 [message #247596] |
Thu, 12 July 2007 09:15  |
Eclipse User |
|
|
|
Originally posted by: jem_do.gmail.com
Hi
sorry for my poor english.
I've downloaded Eclipse 3.2 and BIRT 2.1 .
I have a rptdesign which run well in birt 2.0.1 but not run from birt
2.1.1.
This is my query.It run well in birt 2.0.1.
what is the problem??
plz reply me
////////////////////////////////////////////////////////////
select
round(sum(.subject_grade.marks)*100/ sum(.subject_curriculum.full_marks))
from subject,
subject_curriculum,
course_offering,
course_structure,
program_composition,
examination_type,
examination_instance,
examination_roll_no,
examination_instance_item,
course_enrollment,
program_unit,
subject_grade
where .subject_curriculum.subject_id=.subject.subject_id
and
course_offering.subject_curriculum_id=.subject_curriculum.su bject_curriculum_id
and
course_offering.course_structure_item_id=.course_structure.c ourse_structure_item_id
and .program_composition.program_unit_id=.course_structure.progr am_unit_id
and
program_composition.program_composition_item_id=.examination _type.program_composition_item_id
and
examination_type.examination_type_id=.examination_instance.e xamination_type_id
and
examination_instance.examination_instance_id=.examination_ro ll_no.exam_instance_id
and
examination_instance_item.course_offering_item_id=.course_of fering.course_offering_item_id
and
course_enrollment.course_offering_item_id=.course_offering.c ourse_offering_item_id
and .program_unit.program_unit_id=.program_composition.program_u nit_id
and .course_enrollment.student_id=.examination_roll_no.student_i d
and
subject_grade.course_offering_item_id=.examination_instance_ item.course_offering_item_id
and
subject_grade.exam_instance_id=.examination_instance_item.ex amination_instance_id
and .subject_grade.student_id=.examination_roll_no.student_id
//////////////////////////////////////////////////////////// /
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.03218 seconds