Dynamic Quarterly Statements

I am trying to design a quarterly Balance Sheet and Income Statement. In our old system, it would know, based on the date, which quarters to include and exclude, so we never had to manually hide or unhide columns. Has anyone designed a report like this? What I am trying to show is that in March, we only see Q1; in June we need to see Q1 and Q2 only, and so on. I am just seeing if anyone has tackled something like this before.