JSP with SQL Server reporting service

shyamprabhu · February 15th, 2007, 06:26 AM

Hi,
I am new to JSP and SQL Server world.
I have to design a report using SQL Server Reproting service
and call that report form a JSP page.
Can anyone please help me to know how
to access the reports.

I am using Tomcat and SQL Server 2005 version.

Any help would be appreciated

Thanks
Shyam Prabhu

robertsnoog · February 17th, 2007, 01:53 AM

here is one very smaple example.

<%@Â¡Â¡pageÂ¡Â¡import="java.lang.*,Â¡Â¡java.io.*,Â ¡Â¡java.sql.*,Â¡Â¡java.util.*"Â¡Â¡contentType="tex t/html"Â¡Â¡%>
<html>
<body>
<%Â¡Â¡Class.forName("com.microsoft.jdbc.sqlserver. SQLServerDriver").newInstance();
Â¡Â¡Â¡Â¡Â¡Â¡StringÂ¡Â¡url="jdbc:microsoft:sqlserve r://localhost:1433;DatabaseName=testdb";

Â¡Â¡Â¡Â¡Â¡Â¡StringÂ¡Â¡user="sa";
Â¡Â¡Â¡Â¡Â¡Â¡StringÂ¡Â¡password="password";

Â¡Â¡Â¡Â¡Â¡Â¡ConnectionÂ¡Â¡conn=Â¡Â¡DriverManager.g etConnection(url,user,password);

Â¡Â¡Â¡Â¡Â¡Â¡StatementÂ¡Â¡stmt=conn.createStatement (ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_ UPDATABLE);

Â¡Â¡Â¡Â¡Â¡Â¡StringÂ¡Â¡sql="selectÂ¡Â¡id,titleÂ¡Â¡f romÂ¡Â¡books";

Â¡Â¡Â¡Â¡Â¡Â¡ResultSetÂ¡Â¡rs=stmt.executeQuery(sql) ;

Â¡Â¡Â¡Â¡Â¡Â¡while(rs.next())Â¡Â¡{Â¡Â¡%>
Â¡Â¡Â¡Â¡Â¡Â¡Â¡Â¡rs.getString(1)%><br>
Â¡Â¡Â¡Â¡Â¡Â¡Â¡Â¡<%=rs.getString(2)%><br>
<%Â¡Â¡}Â¡Â¡%>

<%Â¡Â¡rs.close();

stmt.close();
conn.close();
%>
</body>
</html>