Member Avatar for b1izzard

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

  • 2 Contributors
  • 1 Reply
  • 124 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by mnmw
Member Avatar for mnmw

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.