I am looking for a good resource to help me learn GridView. Essentially I would like dozens of examples of filters, each with descriptions of what each part accomplishes. In addition I would like to learn how to set up requests for fields so that when some one else brings up the view it will ask for a date range, or item number range. I have been running in to trouble, thinking that I have set everything up correctly, verifying ok, then getting no results in the view, or all results.

I have read through the manual, but find that GridView alone could easily warrent a textbook.

Hi Nick,

Two quick ways to get off the ground. Use either or both the "Adagio Expert Online" and "Introduction to GridView" webinars to work through a specific view or problem. Try and describe the View you are trying to create in the "I want to know..." question box when you register. For example:

• ...how to prompt the user for one of more values to filter a View?
  
• ...how to filter my transactions to show only those older than 60 days?
  
• ...how to see all the items a customer bought this month?
  

Just a thought on how you may be coming up empty.

Could it be that you are not being as precise as needed in filters when you use "And" and "Or"? In English, you can say "Show me the clients in CA and NV" and people would understand that you want to see the clients in CA and the clients in NV, but the computer interprets it as "Show me any client who is in both CA and NV". Since no client record can be in CA and in NV at the same time, your filter won't let any records through.

What you need to say is "Show me the clients in CA or NV" which will be interpreted as "Show me any client in CA and show me any client in NV".

Make sense?

Nick,

Have a look here: GridView "Quickies" from Business Computer Cdentre for some examples of formulas and filters.

Hi Nick,

Here are 2 GridView 'quickies':

- When using the QueryString function to ask for runtime entry of text (item numbers, customers, etc) and comparing to your data, matching has to be exact, including leading and trailing spaces. Change your filter to 'trim' spaces from your data field value:
Trim({Item number}) = QueryString("Enter the item number")

- If you refresh a View with a filter and get a blank screen as a result, you can toggle the filter button off from the toolbar. This will load the entire database into your view without any filters. If the file is large then this could take some time to refresh, so use prudence if you do this. And remember to turn the filter toggle back on when you want to determine your filter is working.

And one other note. If you are using the runtime query for item numbers to search for all records equal to one or more codes in a file such as OrderEntry or SalesAnalysis (which can be very large files), consider using a link rather than a runtime query; performance is significantly faster. So instead of having a single view based on SalesAnalysis transactions and a query asking for the item code, include a second view on the item master file and link it to the transaction view (by item number) that you already have - and save as a workspace. Then you can double-click to get the same list much faster. And also you can multi-select items from the main list and do a query for multiple item codes at once.

To have the View "ask you" for a range of item numbers, use this fiter:

Code:

---

AND(
  UPPER(TRIM({Item #}))>=UPPER(TRIM(QUERYSTRING("Starting item?", ""))),
  UPPER(TRIM({Item #}))<=UPPER(TRIM(QUERYSTRING("Ending item?", "zzzzzzzzzzzzzzzz")))
  )

---

For date ranges use "=QUERYDATE()".

I asked the same question about the transaction codes in IC history the other day. Here are the values:
Code:

---

 Trx Trx
 Src Type Description
 1   1    Receipt
 1   2    Receipt adjustment
 1   3    Receipt return
 2   1    Shipment
 2   2    Shipment return
 3   1    Adjustment credit 
 3   2    Adjustment debit
 4   1    Stock transfer from
 4   2    Stock transfer to
 5   1    Component item assembly
 5   2    Master item assembly

---

Hope that helps.

And for some codes like these in IC Transaction History, make sure you turn on the 'Translate coded fields' option in the View definition (F4 to edit this). Some of these numeric fields are designed with the value description built-in, so '1' turns into 'Receipt', '2' into 'Shipment' and so on.

How about if someone wrote a "GridView for Dummies" book. I'll volunteer as a model for the front cover.