Invoice Summary - All Tables Not Showing

[tentzontli]

I am totally new to this, my apologies...I am working with an invoice database that I would like to produce reports with.

The Problem: when I set up a columnar/list report the invoice tables do not all add up, only the first line in the report shows up.

The invoice contains about 15 rows and each row is categorized by a pull-down "id". How do I get the report to reflect the remaining 14 rows when I do a report for a single month?

Please help - Im tired and the people are losing faith.

:)

[CobaltSky]

Please help - Im tired and the people are losing faith.

Hello tentzontli,

In most databases, invoices are stored in two parts - the main information is stored in an invoice table and the information for each line is stored in a separate (related) table.

It sounds as though you are building a report based on the main table (one record for each invoice) whereas what you require is a report based on the table that holds the many lines for each invoice. The second table is probably called InvoiceLines or InvoiceRows or SaleItems or some other similar combination.

If a layout based on the appropriate table already exists, you may be able to adapt it for your report. Otherwise, I suggest you make a new layout and base it on the correct table. :wink2:

[tentzontli]

Hey thanks for that, although now I have all repeating fields listed and even the ones with no info are shown.

For example: A list of memberships starts with the first line of the invoice and then the price with 14 zeros representing the repeating fields that are now displayed as a list of blank rows.

Is there any way to get the repeating fields to only show up if there is data?

One other problem is that to do a Summary Field for data broken down by product ID only organizes itself by ID at the first line regardless of what other Products are in the remaining rows.

Thanks for your help in advance.

[Søren Dyhr]

although now I have all repeating fields listed

Time to change horse, since the one you're flocking is ...well dead!

Ditch repeaters immediately!

Invoicing follows what Ray suggests, if reporting should be an issue!

http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000717

And while at it read this thread!

http://www.fmforums.com/forum/showtopic.php?tid/189781/post/265798/hl//fromsearch/1/#265798

--sd

Edited September 6, 2007 by Guest

[tentzontli]

oh...how unfortunate. nothing beats starting over. ok. thank you.