Quote:Mark -
I am truly sorry but I don't understand your comments.
This sounds like you think that I think my first example was an interpretation of the use of multiple views. I prefaced it by saying that it was an example of a report with only one view. Am I missing something?
I was referring to this example:
2) If I have a report with two (or more) groups, then my Report Header would appear only once at the beginning of the report and my view header would appear (and could change) at the beginning of each group, such as:
REPORT - SUMMARY OF EXPENSES FOR FISCAL YEAR
VIEW1 - THIS SECTION IS EXPENSES BY EACH MONTH
July................... Auto Fuel..............$10,000.00
..........................Food....................$ 1,000.50
..........................Etc.
August................Auto Fuel..............$12,000.00
...........................Food................... $....500.00
...........................Etc.
Footer1 Total...................................$23,500.50
VIEW2 - THIS SECTION IS FOR EXPENSES BY CATEGORIES
Auto Fuel.......................................$22,000.00
Food..............................................$ 1,500.50
Footer2 Total..................................$23,500.50
Quote:I suppose in my mind each view is associated with a corresponding group. It sounds like you are saying they are separate entities. If so, I simply just don't understand.
Lets use an example database as (well) an example. Lets say you are using Customers.db and writing a report. In your reports you have sorted the customers by the state they are in and you put a group break on state, so that you get a new group of customers for each state. In that way a group break divides the set of records. So if we have 377 records, they would be divided into 50 groups - one for each state. We basically end up with only a few records in each of the 50 groups.
Views allow Sesame to run through the data more than once. In the simplest case, you could use two views to put two different tables into the same report. Using Customers.db again, you could have the first view be a table of all of the customers showing their name, address, and phone number. In the second view you could have all of the customers in a table, showing other fields, like their hobbies or their date.
Usually multiple views are used to generate different kinds of formats on the data (like table versus freeform) or to calculate values that need to see all of the data before the calculation can be performed. Adding views is very much like having more than one report in the same report.