You could write a script that performs the search for the 3 month period, collects the results into a set of variables, then repeats this process for the 6, 9, and 12 month periods. Then on your report layout, display the variables instead of fields.
Hello, Roland. brsamuel has already given you one option. There are at least a few other ways to create the report, depending on your exact needs.
1) Create a second table (either with one record for each year, or just one record with global fields). Create a pair of date fields for each time period. Then, create relationships from the report table back to your original data, one relationship per time period. At that point, your summary fields (from the context of the report) will show you the summaries for the time periods.
2) Use ExecuteSQL to pull the data and put them into either variables or merge fields.
3) Use scripting to create an HTML table with the data you want in each cell. (Note: This technique typically works better when you have an unknown number of columns, which is not the case here.)
4) Use scripting (perhaps server-side) to store the data in dedicated fields in a report table. Then, use that table to display the data.
1 is probably the easiest to implement. 4 will perform the fastest (for the end user). A lot depends also on whether you plan to keep a history of these report data, or just summon them at runtime. (Note that 4 can be combined with 2 - use ExecuteSQL to pull the data, then stuff them into the fields.)
Gentlemen (brsamuel and Mike_Mitchell)
I'm going to try your recommendations. Although I've just now dipped my feet into utilizing variables within my reports (I'm still very much a novice in my eyes), I will indeed get my hands dirty with these options. I'm just happy to know that it indeed can be done. Thank you so much for your directions. I'm always greatly appreciative to the help I receive here.