Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
See more: VB Oracle
I am trying to generate data report in VB 6 with data in oracle 8. How do I can form the display window of the data as I want the report in the format as below
Name of patient                  ram                     ajay
Address                              sitarampur            mohanpur
contact no                           9988997766            7788664488
Doctors Reference               Dr ajay               Dr mohan
Age                                    45                        67
Sex                                    M                        M
I have created tables with the fields : name of patient, address, doctors name, age, sex.
help me please.
Posted 15-Sep-11 22:27pm

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Add data report in vb6.0 design the report accordingly and on load event of the form fetch data from database and set record set to the report.
See this code :
Set rptEntries.DataSource = rsRecset.DataSource
rptEntries.DataMember = rsRecset.DataMember
With rptEntries
.Sections("PageHeader").Controls("lblFilter").Caption = strlblFilter
.Sections("Detail").Controls("txtRollNumber").DataField = "RollNumber"
.Sections("Detail").Controls("txtName").DataField = "Name"
.Sections("Detail").Controls("txtDate").DataField = "punchdate"
.Sections("Detail").Controls("txtTime").DataField = "punchtime"
.Sections("Detail").Controls("txtReader").DataField = "RdrName"
.Sections("Detail").Controls("txtEntryType").DataField = "EntryType"
.Show vbModal
End With

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 434
1 OriginalGriff 385
2 CHill60 230
3 CPallini 220
4 Abhinav S 200
0 Sascha Lefévre 75
1 OriginalGriff 70
2 F-ES Sitecore 55
3 Peter Leow 50
4 Dave Kreskowiak 40

Advertise | Privacy | Mobile
Web01 | 2.8.150327.1 | Last Updated 16 Sep 2011
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100