>We often give our users a way to extract data directly into Excel and then ask them to mock up reports there. That way, we know what they need and how they want it presented.

I agree, Excel is great for prototyping and report mockups, no question.