VB6 Data Report with code
Posted on 2000-03-25
Well i am working with data reports using Visual Basic 6, but with codes instead of data environment. my problem now is am trying to make the report master/detail one but am having difficulties in coding. The code i wrote for the report will execute all the data which will be duplicated, what i mean is; if i have a person's name, and working times, it will represent the name again and again with eaching working times, what i need is to represent the name once only for his/her list of working times.....(by the way am using MS Access)
The code to put data into report:
With DR /*DR is the report name*/
Set .DataSource = rs /*Dim rs As New ADODB.Recordset*/
.DataMember = ""
For intCtrl = 1 To .Count
If TypeOf .Item(intCtrl) Is RptLabel Then
.Item(intCtrl).Caption = rs.Fields(q).Name & ":"
q = q + 1
If TypeOf .Item(intCtrl) Is RptTextBox Then
.Item(intCtrl).DataMember = ""
.Item(intCtrl).DataField = rs(z).Name
z = z + 1
Can sombody help me????