produce a report in a HTML/.xls/doc | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

produce a report in a HTML/.xls/doc

HI!ALL Members
I have to write a script which will pull all the information about database server and produce a report in a HTML/.xls/doc/.txt format.How should I write this script.IF any one have ever written such scripts pls post here.
I have made a documentation such as:there will be a html page with a list box,this list box ill show the total no of database available in server.a submit button will be there in this page.if we seclect a db db1 and click submit it should generate a reprt in html/doc/xls giving these information to the managemt:name of datbase,phy loc,size,properties,users, pwd,sid.
pls suggest.
You can do it so plz refer to this link.
Rajeev Kumar Srivastava