As Matt states, InfoPath can be used to do simple reporting. It can even be used to generate headers and footers with some limitations. However, the general advice regarding reporting is not to rely on InfoPath for complex reports. Note that header/footer support is richer in InfoPath 2007.
Patrick Halstead
Project Manager at Qdabra