This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Web Services and the fly likes MS SQL Server 2005 Reporting Services in a java desktop environment Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » Web Services
Bookmark "MS SQL Server 2005 Reporting Services in a java desktop environment" Watch "MS SQL Server 2005 Reporting Services in a java desktop environment" New topic
Author

MS SQL Server 2005 Reporting Services in a java desktop environment

DN Debed
Greenhorn

Joined: Nov 03, 2008
Posts: 10
Is it possible to interface sql server reporting services with a java desktop application?

If yes, can you teach or give me an idea how is it done?

I successfully interfaced it to a web application using this as guide (http://www.javaworld.com/javaworld/jw-01-2005/jw-0110-sqlrs.html). I now want to try it in a desktop application.

This is because our program is comprised of a web app and a desktop app (used for end of day and as utility app).

Thanks!
Peer Reynders
Bartender

Joined: Aug 19, 2005
Posts: 2922
    
    5
DN Debed wrote:Is it possible to interface sql server reporting services with a java desktop application?


The article that you reference A Java proxy for MS SQL Server Reporting Services suggests that that is not a good idea:

Donner/Papas wrote:Whatever form of authentication is used, the user must have access to the report server, either through a domain account or a local account.
...
Thus, direct access to RS proves impractical if you must authenticate a large user base that does not have Windows domain accounts. In our case, the Web application uses IBM's Tivoli Access Manager and an LDAP (lightweight directory access protocol) directory to manage user permissions.
...
Because of these concerns about the limited out-of-the-box ability to directly authenticate users, the direct-access option is not attractive for our purposes.


The entire motivation behind that article is to decouple any java client from MS SQL Server RS. For the purpose of the article the clients of the ReportRequest servlet are assumed to be browsers.

However it should be possible to convert the report data content of the response body returned by the ReportRequest servlet to XML (or even XHTML with a Microformat). A java desktop application could then use a URLConnection or HttpClient to issue a report request and get the report data in the HTTP response. The XML data can then be parsed (or bound with JAXB) by the java desktop application for its own use.
 
wood burning stoves
 
subject: MS SQL Server 2005 Reporting Services in a java desktop environment
 
Similar Threads
beginner in need of HELP!!!!!!!
"org.xml.sax.SAXParseException: Premature end of file" Problem
Is this a Java Memory problem or a Windows / SQL Issue
Reporting services
Integrating J2EE application with SQL Server Reporting Services