I clock my time in org-mode. Because projects in my line of work can last for several years, I'd like clock reports that extend over a long period of time.
The problem is that it's annoying to keep completed subtasks in my todo files. I'd like to be able to put those in the archive. However, this destroys the clocktable structure. Anything in the archive is listed separately (it's a different file), and there's no longer any hierarchical structure to it.
What I would like is to be able to automagically merge information from the archive and the main file when the clocktable is compiled.