Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

How do you think I should do this? (DataReport+vb6+Access)

Ok, the problem I have is that I dont know how I should do this:

-I have a high school school grading application done using vb6, Access and reporting with DataReports
-I do not have Crystal
-At the end of the term an "Academic Term Report" is generated for each student.
-The report has one template that I have designed listing ALL the subjects offered in the school
-For each subject there is a TermAverage, and ExamPercentage, an exam Symbol (e.g. A+,A,B,C....)
-I have and can generate all this data from the Term Tests and Exams written for a particular term (TermAverage,ExamPercentage,TermSymbol...etc)
-I have written a query that returns all the students in the school and their corresponding results ()
-The problem is that I do not know how I can now make the data appear in all these columns in a report.
Someone suggested that I should lable rptTextBoes from one up to 12 (if there are twelve subjects) and name the fields as follows:

Subject / Term% / Exam % / Symbol / Teacher's Remarks
English Language, txtTermAverage1, txtExamPercentage1, txtSymbol1, txtRemark1
Mathematics, txtTermAverage2, txtExamPercentage2, txtSymbol2, txtRemark2
Geography, txtTermAverage3, txtExamPercentage3, txtSymbol3, txtRemark3
....
etc

These are arranged in columns and rows.

How do I now assign a datasource using this?

Is there a flexible way?

If I'm using Commands,DataEnvironment what would be the best way?

Could you show me?

I hope I was clear.

Thanks
[1598 byte] By [tinonetic] at [2007-11-11 10:11:56]
# 1 Re: How do you think I should do this? (DataReport+vb6+Access)
I've also attached the Academic report I would like to generate.

Please if you can advise me, I would greatly appreciate it.

Just in case I didnt explain properly, simply put, this is the case.

There are students in a class register

At the end of each school term, there is an academic report sent out for each and every student in their respective register classes.

The students are enrolled in at least 1 subject (usually more than 5), so on this academic report, there there are rows as follows,

Subject Name , Term Average %, Exam Mark %,Exam Symbol, Subject Position, Remark

I hope that makes sense and someone can help me. I'm not lazy, just been trying to do this and I just cant fugure it out. (I'm new to reporting, I've read Data Environment, Commands, Data Reports but I just dont know how I can apply it here coz most examples are "simple")
tinonetic at 2007-11-11 17:22:59 >