Just simply right click a grid and click "Send to Excel." To undo the split, click and drag the gray bars above each "split" to the top of the grid.ĭid you know most Grids can be sent to excel? This can be very useful particularly on the Product Lookup Grid to easily export out your Product list and Warehouse Quantities to Excel. The gray bar can be clicked and dragged as many times as necessary to create multiple "splits". The data grid will split into two as shown below. Then click and drag the bar down to the desired location to make the "split". Place your cursor on the gray bar above the vertical scroll bar until it turns into the cursor shown to the right. In order to do this a vertical scroll bar must be present on the grid. Some data grids allow the grid to be split, so you can view two or more sections of a large data set at once. Split grids to view multiple sections of data simultaneously: Try it out in the Business Alerts and Business Activity Review windows.
This is useful when you need a quick printout rather than a report.
Some static data grids can be printed by simply right-clicking on the data grid and selecting the Print Grid option. Print grids to get an instant hard copy of your data: Well, just click a data grid column, drag it to a desired position in the data grid and drop it when two red arrows appear. Drag and drop grid columns for better organization:ĭo you need certain data grid columns to be more prominent than others or wish to view information in a certain logical order? Just sort one column and then hold down the Shift key while you click another column header (click again to sort in the opposite order), which will sort the information by subcategory. You can even sort multiple columns simultaneously.
#WINDOWS GRID DETAILS WINDOWS#
With a simple click of a data grid column header, you can sort static information of some windows in either ascending or descending order. Sort grid columns to see information in ascending or descending order:
#WINDOWS GRID DETAILS CODE#
Look for fields filter as you type, for data grid information that cannot be filtered by the provided drop-down menus.įor example, in the Business Activity Review window you can filter by various criteria as shown below, such as who the activity is assigned to, the activity type, code and more.Įnhanced filtering is also available in the Customer Information window (on the Invoices, Orders and Products tabs) and the Business Alerts window. You don't have to scroll through tons of information to view what you need, use the new drop-down menus and Look for fields to see exactly what you want. Filter grids to speed up your information searches: Give these quick and simple features a try and you will see time-saving benefits by better organizing and quickly finding information.
But did you know that the data grids had extra features, besides just data organization? Filter, sort, print, split and drag and drop data gridsĭata grids exist throughout the system in various windows to organize data. Data grid features offer time-saving benefits. On windows with a horizontal or vertical scroll bar, you can split the grid. You can also use filters to sort the data. Right clicking on grids in Acctivate allow access the data grid features such as Print Grid, Send to Excel, and Restore Settings.
0 kommentar(er)
