I was reading the fact sheet a couple days ago
http://www.microsoft.com/technet/prodtechnol/office/office2003/plan/inpthfaq.mspx) and Microsoft even states that InfoPath is NOT a reporting product. Any they have not really supported either. Frankly, I cannot get mad with them because their goal for this tool is not to compete with reporting engines. If you need to do simple reporting, use InfoPath, otherwise use InfoPath for what it is good for (data capture) and use a different tool for reporting.
Question: Can you use InfoPath to generate reports?
Answer: InfoPath is designed to help customers efficiently capture information through rich, dynamic forms and to integrate this information into business processes. It is possible for customers to generate reporting views on existing data using InfoPath, however, this is not the design intent of the product. InfoPath is optimized for scenarios in which data needs to be collected or modified or more contextual information is required. Customers can use a Microsoft or third-party reporting application in conjunction with InfoPath to generate reports because the data collected in InfoPath will integrate with any XML-enabled database or server.