I have seen a couple questions similar to this, but the solutions given don't seem to work for me. I am trying to build a table for trending of summary information. For example, if I wanted to see how the total number of open orders changed from month to month.
The answer I have seen given is to create a summary report that is then copied to a history table.
The problem I am running into is that my summary report will not allow me to only group by columns. If I group by rows, when I try to copy the data to the history table, it wants to make each row a record, rather than making a single record with each row a field. If I use crosstabs and group by columns and use a "today()" formula for the row, it doesn't give me the option to import the resulting report to another table. What am I doing wrong?