I was trying to get a list of the Product Names from the Found Data Set. The
columns include Salesman, Customer, Product Name and Count. Since each
Product Name may be repeated many times as one steps through the rows, I was
trying to get a list of each Product Names that were exist in the entire
Found Data Set so I could use them as the headings in my report.
FM 5.5 does not have arrays so I was going to output the names as I Looped
through the Found Data Set. Based on the help I have already gotten maybe I
can output the names to Global Heading Variables using some kind of
repeating field.
----- Original Message -----
From: "Beverly Voth" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, August 23, 2007 10:48 AM
Subject: Re: How to simulate an SQL statement in FM 5.5
On 8/23/07 9:59 AM, "Nicholas Geti" <[EMAIL PROTECTED]> wrote in whole
or
in part:
The idea is that each salesman sells a different package of products for
each customer and date. We want to create Product Name column headings
based
only on what is shown by the filtered view; not all possible Product
Names
that are in the data base. There are hundreds of Product Names and would
not
fit on one page plus most of which would just be empty in any case.
Your FIND will filter to whatever you are looking for. That may depend, of
course, how you have the data "normalize" (or not).
How do I export the current view to another table?
Why do you need to export the "view" to another table? You can create a
script to call this report anytime you need it.
