jescho
asked on
How to display the data to the data report where the data is after certain process, but not directly from database???
I need to display the data to data report after certain process, I retrieve the recordset base on a sql query, but from the retrieved recordset, i need to find out the number of occurence of certain field's data, like name, so how to display data after all these process??
can anyone tell me???
can anyone tell me???
ASKER
for example, the recordset contain :
Name Subject
AAA English
AAA Chinese
BBB English
BBB Chinese
BBB Math
my desired output in the report base on the above example will be :
Name No Of Course Study
AAA 2
BBB 3
however, if i bound the report textbox control to the name field, it will display all the record name available in the database table. so do you know how??? the report that i use is the data report in VB, i dont know is that MS report..cos i am new to data report and those reference didnt teach much on report.
Name Subject
AAA English
AAA Chinese
BBB English
BBB Chinese
BBB Math
my desired output in the report base on the above example will be :
Name No Of Course Study
AAA 2
BBB 3
however, if i bound the report textbox control to the name field, it will display all the record name available in the database table. so do you know how??? the report that i use is the data report in VB, i dont know is that MS report..cos i am new to data report and those reference didnt teach much on report.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Anthony