DataReport

Hi
I am using dataReport for viewing/printing reports. Will it support computed columns.

This is my query. I execute the query settin it to a ADO Recordset and the assign that record set to the report data source. But the computed ID field, Where do I specify in the report.

sqlstr = "select GRNStock.grnno,Cname,Pname, quantity
from GRNStock,Products,customers,GRN
where Products.PID=GRNStock.PID and Customers.CID=GRN.CID and GRN.GRNNo=GRNStock.GRNNo
and year(grndate)=1999 and month(grndate)=10
order by Cname,Pname
Compute sum(quantity) by Cname,Pname"

Set adors = adocn.Execute(sqlstr)
Set rptgrnpdsum.DataSource = adors


Thanks in advance
James