Click here to Skip to main content
12,505,591 members (54,899 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: VB Oracle
Hi

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.

mukesh
Posted 15-Sep-11 21:27pm

1 solution

Rate this: bad
 
good
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
  Permalink  
v2

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 | Mobile
Web02 | 2.8.160927.1 | Last Updated 16 Sep 2011
Copyright © CodeProject, 1999-2016
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