How do you think I should do this? (DataReport+vb6+Access)
-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

