Hi there everyone,

I'm starting to explore the wonderful world of Filemaker. I'm trying to create a specific report. Here are the details.

I'm trying to create a report of a list of numbers per category per location by date.

So if I look up a specific date, I want the report to first list everything grouped in locationA, then in categoryA, but list out every number. Then repeat by categoryB and so forth.

I've tried changing the amount of columns, and that sort of works, but I would like a cleaner look with each sub-summary and result all on one line instead of each being on separate lines.

I hope this makes sense.

Thanks for your help.

Well how would that work if there are 100 different items in categoryB? It would expand horizontally for 100 types?

There are up to 20 different locations and the categories are limited to about 20 different categories. There would not be more than a max of 20 items, so I guess it would either expand or repeat after a certain threshold.

Ideally, I would want something like this.

1/20/10 - San Francisco - Food - 1, 2, 3, 4

1/20/10 - San Francisco - Materials - 5, 6

1/20/10 - Oakland - Food - 7, 8, 9

1/20/10 - Oakland - Materials - 10, 11

Each number above represents a separate record. Is this possible at all? Essential I'm looking for a way to create a list of found records by criteria. Thanks! I hope this makes sense.

Edited January 20, 201016 yr by Guest

I decided to go with a different report structure so I no longer need this answered. Thanks for viewing.