Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DataReport: first line of recordset not shown

Status
Not open for further replies.

Themuppeteer

Programmer
Apr 4, 2001
449
BE
Hi,
I want to show a Datareport of the data I get from a stored procedure, the data returned are: cid, method, event and date_time.
Everything goes just fine except for one thing.
If I display the data of the same recordset in a flexgrid, I get all the correct data and if i display the data in a datareport, the first line is not shown. In other words, in my grid I have one row extra data (which is right) and in the datareport the first line is not shown while it should be shown.

Could someone please help me out here, my deadline is today.

This is my code:

.........

Set rs = cmd.Execute

Set rpt.DataSource = rs

rpt.Sections("Section1").Controls("txtCid").DataField = "cid"
rpt.Sections("Section1").Controls("txtMethod").DataField = "Method"
rpt.Sections("Section1").Controls("txtEvent").DataField = "Event"
rpt.Sections("section1").Controls("txtDatum").DataField = "Date_Time"
rpt.WindowState = vbMaximized
rpt.Show

Thx
 
I think somewhere in your design you have called your first line 1 instead of 0 (zero). Usually fields all start at zero
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top