|
Hi Buddies,
In windows application I am using crystal reports 2008.I used views for design reports.In code behind side called tat views using stored procedure for filtering purpose. filtered data's are assigned to dataset .
Data's are filtered exactly and shown in dataset.i assigned this dataset to crystal report datasourse but reports displayed all records without filteration
here i paste my code .if any bodies solution about tis issue help me
Try
dsReturnHostel = objLogic.SearchReturnedStudentsList(iCount, iHostelID, iRoomID, sReturndate, iCollegeID)
If iCount > 0 Then
ReportsViewer.rptReport = New StudentsStayoutList ReportsViewer.rptReport.SetDataSource(dsReturnHostel) ReportsViewer.WindowState = FormWindowState.Maximized ReportsViewer.Activate() ReportsViewer.Text = "Students Return to Hostel Report" ReportsViewer.Show() ReportsViewer.Visible = True Else MsgBox("No record exists with this Criteria") End If
Catch ex As Exception
MsgBox(ex.Message)
End Try
|