Personally I've that using
XtraReports[
^] solves my reporting needs just fine. Distribution is royalty free.
Apart from that iTextSharp fits the bill well enough.
MikTex[
^] can also be used to create very nice looking reports publishable in various formats.
Regards
Espen Harlinn