Way to create report output in PDF from SQL Server DB

[plshelpme]

Is there any way to create reports that output in pdf through Visual Interdev based on data on an SQL server DB?

I would also like to build a nicer interface on the front of this so that users can run the queries and create the reports themselves in a user friendly manner.

Any ideas?

 

[cbokowski]

take a look at

http://www.activepdf.com

I have been using this product for about 6 months.