Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    California
    Posts
    58

    Unanswered: How to create a dynamic report in Oracle Portal

    Hi,
    I am trying to create a report that would only show the rows based on a criteria. My table has the following structure:
    ID number(10)
    Review_date date
    Review varchar2(1000)
    I want the report to display the following query:
    Select Review_date, review from t1 where id=:ID;
    I need the value of the parameter ID to be accepted through the URl. As in, the requirement wants that a url like www.abc.com:7777/abc?ID=1 should display a page where the report is run for id=1 and the results are displayed.
    I have created a report in Portals where id can be entered once the customize link is pressed and the criteria is added. But the requirements state that users should not have to do this, links will be provided to them based on certain criterias, they just need to click on them. Any help is highly appreciated.
    DBMS: Oracle 9i
    Portal: Oracle portal 9i rel2
    OS: windows 2000 server

  2. #2
    Join Date
    Mar 2004
    Location
    California
    Posts
    58
    Anyone have any idea?

  3. #3
    Join Date
    Mar 2004
    Location
    California
    Posts
    58

    Nevermind

    its ok, I figured it out. You can use the procedure <report name>.show with certain paramaeters.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •