Forum Stats

  • 3,874,247 Users
  • 2,266,705 Discussions
  • 7,911,780 Comments

Discussions

Categories

Urgent! Oracle report and asp.net

405398
405398 Member Posts: 16
edited Feb 17, 2010 6:11AM in Reports
Hi, I had develop asp.net program,I would like to call the oracle report using asp.net.Is it anywhere to do it?
Tagged:
· Share on TwitterShare on Facebook

Comments

  • 393139
    393139 Member Posts: 1,032
    Hi,

    There are 2 ways to do it.

    1. Inside your asp application you can call Oracle reports using HTTP, ie, for paper layout use
    http://machine:port/reports/rwservlet?report=...
    for web layout (JSP's) deploy the report on a J2EE application server and access it
    http://machine:port/reports/your_folder/Report.jsp?server=...

    For complete information take a look at Publishing Reports to the Web (Chapter 8)
    http://otn.oracle.com/products/reports/htdocs/getstart/docs/index.html

    2. If you use upcoming Oracle Reports 10g, you should be able to use the Web Service interface to submit jobs from your application, and do some other operations. Documentation for this will also be included in the "Publishing reports manual" with the release.


    Navneet.
    · Share on TwitterShare on Facebook
  • 405564
    405564 Member Posts: 7
    This looks like it pertains to Reports 9i. Is is also possible to save the report definition as a JSP in Reports 6i? If not, how do I save it so that ASP can call it?
    · Share on TwitterShare on Facebook
  • 384471
    384471 Member Posts: 743
    (1) In 6i you cannot save report as JSP
    (2) In 6i to run to web you can use "rwcgi60" executable. You can use rdf format itself. From ASP give a link something like this

    http://host:port/cgi-bin/rwcgi60?report=test.rdf+destype=cache....
    (3) Another option is to run using Web cartridge and Reports thin client for 6i. Please refer 6i docs to see the steps in
    details

    Thanks
    The Oracle Reports Team
    · Share on TwitterShare on Facebook
  • 405564
    405564 Member Posts: 7
    Thanks, I used the rwcgi60 and that worked! Now, is there a way to pass parameters (connect string and user-defined report parameters) to the report without hard-coding them in the url?

    We can't use the thin-client approach because our customer will not allow individual client-installs.

    Thanks,
    Jenny

    (1) In 6i you cannot save report as JSP
    (2) In 6i to run to web you can use "rwcgi60"
    executable. You can use rdf format itself. From ASP
    give a link something like this

    http://host:port/cgi-bin/rwcgi60?report=test.rdf+desty
    e=cache....
    (3) Another option is to run using Web cartridge and
    Reports thin client for 6i. Please refer 6i docs to
    see the steps in
    details

    Thanks
    The Oracle Reports Team
    · Share on TwitterShare on Facebook
  • 384471
    384471 Member Posts: 743
    1) To display user params give paramform=yes
    2) For sensitive things like db conn which you would like to hide from user include keys in "cgicmd.dat" file

    You can see cgicmd.dat file in $OH\reports\cgicmd.dat. There are lot of examples in the file to get started. Please refer docs for further details

    Thanks
    The Oracle Reports Team
    · Share on TwitterShare on Facebook
  • 754308
    754308 Member Posts: 2
    Hi,

    Can you help me how to run the oracle reports from asp.net.
    And how to access the parameter values from asp.net screen to oracle reports.

    Thanks,
    shiva
    · Share on TwitterShare on Facebook
This discussion has been closed.