Report Formatting

[cyberghozt]

I've recently learned how to use summary fields and subsumary parts.

My issue is i'm attempting to create a report that groups vertically rather than horizontally.

For example I need a report for widgest sold that groups all the months in one report and the months are the column headers.

For example

[April][May][June]

[widget1][#April][#May][#June]

[widget2][#April][#May][#June]

[widget3][#April][#May][#June]

[TotalApril][TotalMay][TotalJune]

hopefully that illustration explained my point..

I have no issues grouping by widget names, types, etc.. but I can't figure out how to count within the certain months. My find request would either be for a specific date range (1 date range) rather than multiple but I need results from multiple finds.

Any suggestions? This seems to be a simple reporting concept so i'm sure there's a simple way to do it that i'm missing.

Please help!

[bcooney]

This is not a simple reporting issue. This type of report is referred to as a cross-tab, and is very difficult to achieve in FileMaker.

Here is a link to a very popular technique, but it certainly isn't beginner-level stuff. M. Edoshin's Cross-tab article