I am new to Crystal Reports.  I have NEVER used it before!  So...I am in need of creating a report based off of a dataset result.  All database connections are handled by a class, and the datasets are handled in another.  Heres the senario .  I have a form that uses a dataset to fill some properties, which in turn are used to bind some text boxes.  This form has all the needed information I need to create the report and print (a single record).  I'm not sure how to pass the properties to a report.

 

I've created a report and used the class as the datasource.  I put those fields on the form, but I can't get any data to fill those fields.  Do I need to create a new query somewhere in the report and use a parameter to extract the data?  Does Bischof book cover this in detail, and could I understand it with out having to read 500 pages?  I'm kinda on a time limit, but would be interested in learning more in the near future.

 

BTW, My code is VB .NET and I am access a local Access database.

 

Thanks for any help you could provide.

 

Ken McKenzie

This is how I handle my dataset creation and population:

Dim strSQL As String

strSQL = "SELECT * FROM tblPTORequest WHERE ID = " & mID

objDS = objData.RetrieveData(strSQL)

Me.shtCounter = 0

Return objDS

End Function

Then I use the report code in the form Load event.

 

objDS = objPTO.EditPTORequestbyID(mintID)

FillTextBoxes()

Dim myReport As rptPTO = New rptPTO

myReport.Load("C:\ATLPTO\Atlanta PTO Request\Atlanta PTO Request\rptPTO.rpt")

myReport.SetDataSource(objDS)

CrystalReportViewer1.ReportSource = myReport

I appreciate the help and hate to be bothersome.

 

Ken Mckenzie