Please observe the report below:




Pretend the values are Running Totals, placed in the report footer. A total of 18 Running Totals are created.

But the only difference between each set of 6 Running Totals is the filter "Project". It can be "Project X, Y or Z".
So I hope it's possible to create only 6 Running totals and 3 Formula's to create the filter. Then re-use the Running Totals, only modifying the formula/filter.

For only 18 Running Totals it's not a big deal, but I have 100 Running Totals, and they need to be re-used 30 times. That's makes it a total of 3000 running totals. No way I'm going to type them.
Using Sub reports is not an option. I make highly customized reports which involves a lot of coding and running total/formula creation.

Is there a way to solve this?

Gr,
Val

- The row names come from different tables.
- Exporting it to Excel with all formatting is not cool. Leaves blank columns behind. A well known, somewhat irritating, feature of CR.

So can't sure Cross Tables. With formulas and Running totals, I can fully control the final result after export...