Generating Reports from Forms to a Report

[popodc]

Please help me generate reports from the forms to crystal or data report.. i have the details in the text boxes and i dont need database to put it into. i justi need to pass it on a report using crystal report 6.0 or data report for printing purposes . Thanx

[d3gerald]

well thats kinda easy thing. you can set the value of each control you want to like this

DataReport1.Sections("SectionNameAsString").Controls("ControlNameAsString").Caption = "Your Value"   'you may use .Caption for labels

but theres one problem with data report, you need to connect it to a recordset so that you can run it. you can open a recordset as dummy or you may have it contain data without connecting it to the database, try a search

[popodc]

thanks d3gerald.. can u give me a sample code for that.. i placed in Details(section1) a label and i need to get values from my first form(using textboxes) to datareport1. thanx!

[d3gerald]

Dim rsTemp As New ADODB.Recordset
 
rsTemp.ActiveConnection = Nothing
rsTemp.CursorLocation = adUseClient
rsTemp.LockType = adLockBatchOptimistic
    
'create some fields
rsTemp.Fields.Append "Field1", adChar, 50
rsTemp.Fields.Append "Field2", adVarChar, 50
'you may create more here
rsTemp.Open
    
'add a record
rsTemp.AddNew
rsTemp.Fields(0) = "Value1"
rsTemp.Fields(1) = "Value2"
rsTemp.Update

[popodc]

hanks d3gerald.. can u give me a sample code for that.. i placed in Details(section1) a label and i need to get values from my first form(using textboxes) to datareport1. thanx!

[popodc]

well thats kinda easy thing. you can set the value of each control you want to like this

DataReport1.Sections("SectionNameAsString").Controls("ControlNameAsString").Caption = "Your Value"   'you may use .Caption for labels

but theres one problem with data report, you need to connect it to a recordset so that you can run it. you can open a recordset as dummy or you may have it contain data without connecting it to the database, try a search

how will i know the controls?? i tried it but up to controls(1) and controls(2) only works?? how can i put controls?