Calling oracle report from jsp

[jessiechkee]

Hi all,
Does anyone know how to use jsp to connect to oracle report?
If can, please show me in details how it runs...
and
Please give me some guidelines.

Your help will be appreciated.

 

[amitary]

Hi
I have the same problum if get some positive response then let me know.

 

[Guest_imported]

Hi,

What do you mean jsp connect to report?

Do you mean jsp call oracle report. If that is the case, just call the report as you call a HTML file, like

http://xxxx.com/cgi-bin/rwcgi60?key...AMENTER2=ABCD+destype=cache+desformat=htmlcss

Hope it help.

Frank

 

[Guest_imported]

How do Crystal Reports Can be Called from JSP

 

[jatinsut]

one way is to call WServlet from a jsp directly.
If your jsp needs to call a CGI program (or even a servlet) , u need to simulate the get ot post method functionality.
It can be done as follows.
String qry = "report="+rep+".RDF&userid=system%2Fmanager%40ibba&server=Rep60_INFRA5%2DOraHome82&desformat=pdf&destype=cache";
URL my_url = new URL("

http://host:port/cgi-bin/RWCGI60.exe");

URLConnection connection = my_url.openConnection();
connection.setDoOutput(true);
connection.setDoInput(true);
connection.setAllowUserInteraction(false);
DataOutputStream send_data = new DataOutputStream(connection.getOutputStream());
send_data.writeBytes(qry);
DataInputStream read_data = new DataInputStream(connection.getInputStream());
String temp_data = "";
while ( (temp_data = read_data.readLine() ) != null) {
out.println(temp_data);
}

Hope this helps.

Jatin