Help Regarding CrystalReports
 

Hi all,
I am working with a project which includes Crystal Reports in Vb.Net and SQL Server2000 as Back end.

The code in button click is

str5 = "D:\AttendanceReport.rpt"

If Not IO.File.Exists(str5) Then

Throw (New Exception("Unable to locate report file:" & vbCrLf & str5))

End If

str6 = "SELECT * FROM attendance WHERE attendance.dates ='" & str & " ' and Empid in ( Select Empid from EmployeeDetails where DeptId in (Select Deptid from departments where deptname='" & Convert.ToString(cbxDept.SelectedItem) & "' ))"



MsgBox(str6)

da5 = New OleDbDataAdapter(str6, sDbConnection)

da5.Fill(ds5, "Attendance")

rst.SetDataSource(ds5)

Dim myReportDocument As ReportDocument

myReportDocument = New ReportDocument

myReportDocument.Load(str5)

myReportDocument.SetDataSource(ds5)

'Binding report with CrystalReportViewer 

CRViewer.ReportSource = myReportDocument

CRViewer.DataBind()

I am getting an error as

'DataBind' is not a member of 'CrystalDecisions.Windows.Forms.CrystalReportViewer'.

I can't understand why the error is Coming
Please Help me

Thanks in advance

Re: Help Regarding CrystalReports
 

I can help u. But u will have to mail me at coolamit0072003@hotmail.com . Mention this error in mail

Re: Help Regarding CrystalReports
 

Hi sravan,

When you are using crystal reports in vb.net,there is no method databind available.It is enough if you set the reportsource property to the correct crystal report.

Here is your code.
str5 = "D:\AttendanceReport.rpt"
If Not IO.File.Exists(str5) Then
Throw (New Exception("Unable to locate report file:" & vbCrLf & str5))
End If
str6 = "SELECT * FROM attendance WHERE attendance.dates ='" & str & " ' and Empid in ( Select Empid from EmployeeDetails where DeptId in (Select Deptid from departments where deptname='" & Convert.ToString(cbxDept.SelectedItem) & "' ))"

MsgBox(str6)
da5 = New OleDbDataAdapter(str6, sDbConnection)
da5.Fill(ds5, "Attendance")
rst.SetDataSource(ds5)
Dim myReportDocument As ReportDocument
myReportDocument = New ReportDocument
myReportDocument.Load(str5)
myReportDocument.SetDataSource(ds5)
'Binding report with CrystalReportViewer
CRViewer.ReportSource = myReportDocument


Hope this helps

Regards

Exelio

Re: Help Regarding CrystalReports
 

Hope it will help you.

http://www.tek-tips.com/faqs.cfm?fid=3940