Question:
I want a simple way to get a report from a SQL server database to HTML. Then I want the report to print, nicely formatted. How do I do this? Also, should I be doing something else that’s a better way to get reports on the Web?
Answer:
The following sample page can be written to do just what you asked. It requires Active Server Pages (ASP) and SQL Server. Note that the value of the strConnect variable is very important. “Initial Catalog” represents the database from which the data will be extracted. “Data Source” represents the name of the server on which that database is running. Copy and paste this code into one of your own ASP pages. It should produce a simple, yet organized report.
<%@ Language=VBScript %> <% strConnect = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=Pubs;Data Source=CAISON" Dim conn set conn=Server.CreateObject("ADODB.Connection") conn.Open strConnect,sa, "" Dim rs set rs=Server.CreateObject("ADODB.Recordset") rs.Open "Select * FROM Authors",conn %>Authors Report
<%=rs.fields(0).name%> <%=rs.fields(1).name%> <%=rs.fields(2).name%> <%=rs.fields(3).name%> <% do until rs.EOF %><% rs.MoveNext loop %> <%=rs(0).value%> <%=rs(1).value%> <%=rs(2).value%> <%=rs(3).value%>