I am working on a database that will give reports from a POS system (cash register). It's been a few years since I've done any filemaker work and I can't seem to find an answer to my dilema. Last version i used was 6 or 7, before they added tables.

Problem:

FIELD1

This field gives the total amount of money the person has paid.

FIELD2

This field is the section of the restaurant that the person is in. The data is numbers. ex "1"=section 1, "2"=section 2, etc... (the wanted data isn't that simple, but you get the idea.)

I need a one page report that shows how much money, during a certain period, was received from each section.

First, I'm assuming that i need to create the report in a separate database (or table?) that can go back to the database with all the data.

Second, I created scripts that find the correct data and calculate the totals for the particular section that script looks at. How do i combine the data from the scripts into a single page report?

I've set up the scripts with the find command and a summary field.

Thanx,

-paul

First: no, you don't need to create a separate reports table. You could, but it's not necessary, at least not for what you've described.

Second: hard to say without seeing your scripts. Read on...

If you make a layout with a subsummary part (by section), and you put the section name on the part along with a summary field that totals the amount, you're pretty much done:

- do a Find for the records you want to summarize,

- sort by section (and other criteria if desired),

- preview or print to see the totals.

yeah that's one of the ways I've been playing with, now to throw the monkey wrench into the works...

It's not just a matter of a simple break down of each number. they want the numbers grouped specific ways.

example.

restaurant is numbers 1-5

take-out is numbers 5-13

delivery is number 13-21

so the data has to be grouped based on these pre-set criteria...

make any sense?

Create a field that is a simple calc*

=Case(

number < 6; "Restaurant";

number <14; "Take out";

number < 22; "Delivery")

*This calc makes assumptions about your ranges, which, as written, are contradictory.

Then add an additional summary section to the report and sort by this new field first, then by number.

Edited July 28, 200817 yr by Guest

LOL. ok, got the reports showing the correct data, thanx for the suggestions...

the client strikes again. now they want to be able to export this data. can you export summary reports?

Yes: Exporting data from FileMaker Pro