Unanswered: How to create a dynamic report in Oracle Portal
I am trying to create a report that would only show the rows based on a criteria. My table has the following structure:
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