thankQ Help

1.Click on Report Explorer on the right

2.Right click on sqlDataSource1 under Components

3.Select Manage Queries

4.Click on the … ellipsis button on Manage Queries

5.Click Run Query Builder

6.Click Filter at bottom on form

7.Click the + beside And

8.Click on the Table and select the field to filter e.g. Date of Payment

9.Select the Is greater than or equal to operator

10.Click the pencil and then the icon beside the Table name  until it becomes a ?

11.Click onto <select a parameter>

12.Select Bind To

13.Select FromDate

14.Create another filter for Date To filter, binding to ToDate parameter

15.Select to only have the top 100 records while testing, especially with a large database

16.Click OK

The filter has now been added to the Query Builder

17.Click OK at the bottom of the form

18.Click Next on Query Editor

19.Click Finish

20.Click OK on Manage Queries

21.Click Save on the ribbon

22.Enter Title and Description and Confirm

23.Click OK