Member Avatar

I had created a report using Reportviewer control(VS2008+MS-Access), the report displays all the records from Access Db correctly but i need to sort the records and display.

Sorting by Date(Ascending) that too the records prior to Today's date should not be displayed

I do not know about sorting inside a ReportViewer. However the best method is to sort the data in the query used to retrieve the records. for example strQuery = "select * from tableName order by primarySortField, SecondarySortField". This way, by the time data reaches the ReportViewer, it will already have been sorted. Regards.