>Hi All,
>I'm looking for recommendations for the best product to allow our reports the option of being converted to .pdf files programatically. I'd appreciate all your thoughts/feedback, and experiences.

Pat,

Take a look at http://fox.wikis.com/wc.dll?Wiki~PDFdrivers~SoftwareEng. You've to pick one based on your requirements and preferences.
We're using XFRX and quite happy with it. You can download demo and try it.