hello,
is there a way to create a report without a database?
i want everything to show on the report in runtime.
Printable View
hello,
is there a way to create a report without a database?
i want everything to show on the report in runtime.
What report? Crystal Reports, Access Report, etc. ?
the normal reports that comes with vb6
That is really outdated but its the VB 6 Data Report.
I havent used it since 1998 just after VB 6 came out as its too limited and cumbersome.
If you can write some kind of textfile or ini file you may be able to connect to it instead but Im unsure.
you could use something like this,
Assign the text boxes on report1 to use the fields from the recordset.Code:Dim rsP As New ADODB.Recordset
With rsP
' Create Recordset Fields (Columns) here
.Fields.Append "tender", adVarChar, 10
.Fields.Append "activity", adVarChar, 8
.Fields.Append "reading", adVarChar, 10
.Fields.Append "turn out", adVarChar, 12
.Fields.Append "date", adVarChar, 10
.Fields.Append "time", adVarChar, 10
.Fields.Append "cfs", adVarChar, 6
.CursorType = adOpenKeyset
.LockType = adLockOptimistic
.Open
End With
' load the data into the recordset
With report1
' Bind the Recordset to the Report
Set .DataSource = rsP
.DataMember = rsP.DataMember
.Show
End With