1 Topic by thezimguy (edited by thezimguy 2018-08-18 12:02:19)

  • Registered: 2018-07-19
  • Posts: 260

Topic: [SOLVED] Report Generation With MVD FastReport with Grouping

Hello Dmitry and MVD Friends,

The studentReport system records exams and class scores for each student
TABLE
1. register: student details
2. score : students scores
3. course: the subjects students are taking

PROBLEMS
I want to make a report in fastReport which will output each student and the (courses with scores[exams,class])

##########################################################################################
#    EXAMPLE
##########################################################################################
#    NAME Eric Obeng
#
#    SUBJECT        |    EXAMS SCORE    |    CLASS SCORE
#    ..........................................................................
#    ENGLISH        |    80                        |    80
#    MATHS                    |    80                        |    92
#    SCIENCE        |    80                        |    82
#
#
#
#    NAME Linda Obeng
#
#    SUBJECT        |    EXAMS SCORE    |    CLASS SCORE
#    ..........................................................................
#    ENGLISH        |    84                        |    91
#    MATHS                    |    73                        |    87
#    SCIENCE        |    78                        |    85
#      ICT                       |    70                        |    84
#
#########################################################################################
Attached is the project

Post's attachments

Attachment icon reportCard.zip 335.3 kb, 371 downloads since 2018-08-17 

@thezimguy

thezimguy's Website

  • Registered: 2014-02-14
  • Posts: 10,294

Re: [SOLVED] Report Generation With MVD FastReport with Grouping

Unfortunately I can't help you, because you use pirate version.

Dmitry.

3 Reply by thezimguy (edited by thezimguy 2018-08-17 14:54:51)

  • Registered: 2018-07-19
  • Posts: 260

Re: [SOLVED] Report Generation With MVD FastReport with Grouping

I'm using a beta version
Tnx all the same

@thezimguy

thezimguy's Website

  • Registered: 2018-07-19
  • Posts: 260

Re: [SOLVED] Report Generation With MVD FastReport with Grouping

I have been able to figure it out. Thank you guys.

What I did was to place the SQL below in the report button.
Then I used the group header in the FastReport to generate the result I needed.

SELECT register.id,
       score.examsScore,
       score.classScore,
       register.fname,
       register.lname,
       register.oname,
       course.courseName
  FROM score
       LEFT OUTER JOIN register
                    ON register.id = score.id_register
       LEFT OUTER JOIN course
                    ON course.id = score.id_course
 WHERE score.id_register = register.id
 ORDER BY id_register;

Thanks

@thezimguy

thezimguy's Website

  • Registered: 2018-07-19
  • Posts: 260

Re: [SOLVED] Report Generation With MVD FastReport with Grouping

For more explanation follow link below
https://www.fast-report.com/documentati … groups.htm

@thezimguy

thezimguy's Website