Here is a pseudo sample of the reports (where the entries are the counts):
SALES REPORT
Salesman's Name: John Doe
Customer Sales Ticket 1399 499T 499DIG 8000
ABC Co. 12345 14 12 102 21
XYZ Co. 44455 8 7 30 16
Total 22 19 132 37
Another time period may see other product names across the report.
----- 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.
Is there a way to create a variable as a column heading on a report and
modify the contents of that variable so that the contents are printed?
Yes, create a global field. Enter information into that field and place
the
field on the report layout. Change for the next report. You could even add
this to the script for the report.
Again, please type up (as text) as small sample of how you want this to
look:
Salesman 1
Product 1
date company1
date company2
Product 2
date company1
date company2
Salesman 2
Product 1
date company1
date company3
Product 4
date company3
date company4
OR
Salesman 1
Company 1
product1
product2
Company 2
product1
product2
Salesman 2
Company 1
product1
Company 3
product1
product4
Company 4
product4
These two are the same FIND (QUERY), but different SORTS (ORDER BY in
sql-speak). Is there another "format" you need?
Beverly
----- Original Message -----
From: "Beverly Voth" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Wednesday, August 22, 2007 6:30 PM
Subject: Re: How to simulate an SQL statement in FM 5.5
What do you mean by "headings would be different whenever a new query
was
created"?
