devxlogo

Create an HTML Report From a SQL Server Database

Create an HTML Report From a SQL Server Database

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

<% do until rs.EOF %> <% rs.MoveNext loop %>
<%=rs.fields(0).name%> <%=rs.fields(1).name%> <%=rs.fields(2).name%> <%=rs.fields(3).name%>
<%=rs(0).value%> <%=rs(1).value%> <%=rs(2).value%> <%=rs(3).value%>

See also  How HealthStream Learning Center Supports Healthcare Education and Compliance
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist