XLReporting has various features across all pages, which are useful when working with data.
By clicking on the XLReporting in the left-top of the screen, you can toggle between 3 modes:
To sort data in tables and reports, simply click on any column header. If you click repeatedly on the same column, the sort order of that column will switch between ascending and descending:
To filter data on your screen, simply select a value from any of the dropdowns at the top of the screen:
This only filters data on your screen, not in the database.
To insert, delete, copy, or move rows (when you are editing data), you can either right-click on a row, or click on the ☰ button in the last column of a row:
To hide columns that you don't need, right-click on any column header, and then simply click to switch the visiblity (the "eye") of every column:
This only hides columns on your screen, not in the database.
To change the order of columns, click on any column header, and then simply drag it to the required location:
All data can be exported to Excel, and imported from Excel where applicable. If you have lots of data to be edited, it can sometimes be faster to do that in Excel using search & replace, copy down etc. Simply export the data, edit it in Excel, and import it back again. For more information on Excel integration, click here.
In the right-top of the screen you will find a Save button to save your changes (where applicable), and an Actions button with relevant options: