Print Page | Close Window

Crystal Reports Data Filter

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Writing Code
Forum Discription: .NET programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4819
Printed Date: 18 May 2024 at 12:27pm


Topic: Crystal Reports Data Filter
Posted By: sdhsivam@gmail.
Subject: Crystal Reports Data Filter
Date Posted: 17 Nov 2008 at 6:18am

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




Print Page | Close Window