Problem with crystal reports
-
Hello, i have created a simple report using visual studio report expert.The schema of the report goes like this.i have selected a single table to be displayed.from this table i have selected just 2 fields.now in the form load event of my webform i have written the following code. Dim objRpt As New CrystalReport1 Dim cnn As New SqlConnection("data source=test-sqlsvr;uid=jts;pwd=jts123;initial catalog=eis") Dim adp As New SqlDataAdapter("select FirstName,LastName from emppersonaldetails where firstname='anil'", cnn) Dim ds As New DataSet adp.Fill(ds) objRpt.SetDatabaseLogon("jts", "jts123", "test-sqlsvr", "EIS") DataGrid1.DataSource = ds DataGrid1.DataBind() objRpt.SetDataSource(ds) CrystalReportViewer1.ReportSource = objRpt now the problem is that my condition as mentioned in the dataadapter does not have any effect on the information shown by the report viewer.it simply shows all the records stored in the table. the data adapter itself contains the correct data.i cross checked it by showing the same data in a datagrid. so whats the problem and how to solve it. Thanx, chitranjan more dash than cash!!!