Dear Champs! I am facing some problems in filterization. Let me clear the scenario to you:
On the Table level "TimeSheet" table had the relation with "EmploymentInformation" on "EmployeeId" I have a form "DailyTimeSheet" with two datasources: 1) TimeSheet 2) EmploymentInformation Datasource "TimeSheet" has the following properties: Table: DailyTimeSheet JoinSource: EmploymentInformation LinkType: OuterJoin I had a grid to display the fields with following properties: DataSource: EmploymentInformation Now, grid display me all the Employees either they have matching results in "DailyTimeSheet" or not.. Grid contains both datasources field. As I enter the data in "PRTimeSheet" datasource fields, a record is automatically created and is saved in PRTimeSheet table. I want to filterize the results on the basis of : "EmploymentInformation.PayGroupCode" "EmploymentInformation.EmployeeId" "TimeSheet.WorkDate" How can I give "Ranges" for all these fields? And where I have to give? I am facing a really serious problem....... Quick reply will be highly appreciated..... Thanks in Advance! Ehtasham Ur Rahman