Hi guys,

I have a table which use to store exam result data. The format is as below:

StudID AssessName AssessMark AssessGrade AssessType
1000    Ind. Assess   80                     A          Coursework
1000    CPM             76                     B          Coursework
1000    Assess Final  78                     B          Final Exam

I wish to print the Final Exam's AssessMark at the last row of the VB Datareport. How can I specify that it will be printed at the last row of the report section? For e.g.

------------------------------------------------------
StudID: 1000

AssessName           AssessMark AssessGrade
Ind. Assess             80              A
CPM                       76              B

Final Exam    78              B
------------------------------------------------------

Your help is highly appreciated.

Thank you


Gary

Hi..

First you need to filter the data stored in your database. It seems like this:
rs=select * from tbl where fieldname='" & str &"'"

set datareport.datasource=rs
datareport.show



hopefully it helps

Hi..

First you need to filter the data stored in your database. It seems like this:
rs=select * from tbl where fieldname='" & str &"'"

set datareport.datasource=rs
datareport.show



hopefully it helps
vyx

Hi Sage,

Thanks for the reply,

Yes, I've filtered up but I'm using dataenvironment to do my datareport. Is is possible to use two commands under one connection?

I've tried but it seems like it cnt work. An error msg pop up and show that "DataField 'cmdFinalRes_Grouping.Assessment Mark' not found".

Thank you

Gary