Themuppeteer
Programmer
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 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"
rpt.Sections("Section1"
rpt.Sections("Section1"
rpt.Sections("section1"
rpt.WindowState = vbMaximized
rpt.Show
Thx