Hey guys!
I need a little help with Crystal Reports!The Report keeps repeating the details.I tried to group it by the reference number but it keeps displaying it four times!Also how can I order the report by reference number?Please help me its the last thing for me to finish my software!Here's my code:
Dim crptdoc As New CrystalReport1
Dim mystr As String
Dim myDS As New DataSet1
crptdoc.Load("C:\Users\ACP\Documents\Visual Studio 2005\Projects\Sistema ManoObras\SistemaManoObras\SistemaManoObras")
crptdoc.SetDataSource(myDS.Tables("Payroll"))
mystr = "{Employees.EmployeeID} = " & Val(Form1.TxtEmpID.Text) & "and {Payroll.PayrollID} = " & Val(Form1.TxtPayrollID.Text) & ""
CrystalReportViewer1.SelectionFormula = mystr
CrystalReportViewer1.ReportSource = crptdoc