Printable View
hello,
is there a way of adding a data report without requiring a data environment?
i tried doing so but it said invalid data source.
i only want the report to be stimulated from something i've entered on the report instead of from a database as my application wont be having one.
Short answer: No. Sorry.
what exactly you want to do
try passing the values at run time to datareport objects
since i dont have a database, i'll pre-enter data onto the report first.
this is only for testing purposes just to give an idea on what the report would look like.
Yes you can use a datareport without a dataenvironment. You just have to set the datasource at runtime.
dim rsRpt As New ADODB.Recordset
With rsRpt
' Create Recordset Fields (Columns) here
.Fields.Append "groupid", adVarChar, 12
.Fields.Append "meter", adVarChar, 12
.Fields.Append "lastread", adDouble
.CursorType = adOpenKeyset
.LockType = adLockOptimistic
.Open
End With
rsRpt.AddNew
rsRpt!Groupid = "abc"
rsRpt!meter = "xyz"
rsRpt!lastread = 123.45
rsRpt.Update
End If
With rptMeterlist
' Bind the Recordset to the Report
Set .DataSource = rsRpt
.DataMember = rsRpt.DataMember
.Show vbModal
End With
set rsrpt=nothing
add the text boxes to your report and set the datafield property to the fields in the recordset and leave the datamember property blank.
this goes in the general declarations?
This can go anywhere. I run alot of reports this way, usually from a command button. Just put the code in the click event.
i'm sorry but it says object not found:
Set .DataSource = rsRpt
Sounds like it can't find the datareport. Have you created the datarareport? Make sure your using the correct name.
what am i supposed to name it?Quote:
Originally Posted by wes4dbt
With rptMeterlist
' Bind the Recordset to the Report
Set .DataSource = rsRpt
.DataMember = rsRpt.DataMember
.Show vbModal
End With
In this example I have a datareport named rptMeterlist. When I used the report designer I left the datasource and datamember properties blank and then I assigned them at runtime, see above.
so if i were to add textboxes, how do i put the values in?
What ever you put in the recordset that you assign to the datareport.datasource will show up on the report.
I attached a demo program that show how to use a data report without a dataenvironment. I hope this helps
Moved to reporting
thank you very much. i'll have a look at it.Quote:
Originally Posted by wes4dbt