Above is SQL report to show some reporting features of IndooGrid. It displays common Microsoft Northwind sample table Orders.
We predefined some additional options to display time limited content and to search single fields or all fields simultaneously. These options are available using filter on the top of the grid (because of using static Microsoft data we set today date to 7/11/2007 - for example last week is beetwen 7/4/2007 and 7/11/2007 and last month starts on 6/11/2007 and ends on 7/11/2007)).
Using Search all fields we can execute general search (filter string found in any field except calculated columns, i.e. Actual and Planned fields).
Using grid features only (without modifying table or creating view) we have also calculated Planned time of shipment (RequiredDate - OrderDate) for each order and Actual time of shipment (ShippedDate - OrderDate) for each order. These added columns are colored blue.
Column Ship Via is related to Shippers table (join table on Shippers) and it displays text form joined table based on Ship Via value from Orders table.
Join for displaying values in the grid is separated from join for displaying values in Filter dropdown list (you can also display 1,2,3 in grid column and Andrew etc. in filter column as it is made for Employees or use other combinations).
On the bottom of the grid are also calculated average values for both filtered and nonfiltered grid. For example: sort orders (by clicking on column header) by Date required or enter "GR" in filter field and see results.