Click here to Skip to main content
13,143,774 members (34,997 online)
Rate this:
Please Sign up or sign in to vote.
See more:

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 21: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
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web02 | 2.8.170915.1 | Last Updated 16 Sep 2011
Copyright © CodeProject, 1999-2017
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