A screenshot would be helpful. A few ideas--I guess printing it in table view doesn't help? Keeping in mind if you right-click any of the top labels you can do some ad hoc sorting and reporting.
What did you try with a report layout? Have you tried using a report layout without the body part, using only sub-summary parts? Have you investigated cross-tab reporting?
If you have linked your two tables, Country and Invoices in the correct relationship, you have two options:
On Country you can add a portal to Invoices to list all invoices that are linked to that country
On Invoices, you can set up a list or table view layout that includes fields from both country and invoices.
I have a similar question. I have managed to add sales data to each customer (main table) by "time of sale" and "actual sales" in a portal. Each record contains time of sale and sales in a horizontal fashion (i.e. by record). However, my colleagues are used to seeing aggregated data in a vertical fashion like in an Excel sheet: time of sale as one column heading and right next to it sales as another column heading.
I tried Reports to aggregate data but they come below each other and cannot be put next to each other, I suspect because of the nature records work. So I wonder how I can get an Excel like view? The obvious choice is to add for every customer a new field for every new time of sale and new sale but that cannot not be the solution.
Thanks for any suggestion.
season 1 sale 1
season 2 sale 2
season 1 season 2
sale 1 sale 2