Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem using srw.set_page_navigation_html()

Status
Not open for further replies.

winGlow

Programmer
Jul 17, 2000
2
GB
Hi.<br><br>I'm using Oracle Reports 6 for a browser-based reporting system and am struggling to change the <B>before page</B> and <B>page navigation</B> HTML dynamically from PL/SQL.<br><br>Although I've put the code into the BeforeReport trigger, it doesn't seem to have any affect.&nbsp;&nbsp;&nbsp;I've tried lots of variations, but essentially I can't get the following to code to work:<br><font color=#ff0000><br>strNavBarURL := 'navBar.html';<br>srw.set_page_navigation_html(srw.file_escape, strNavBarURL);<br></font><br>When I run the report in my web browser I just get the default Reports navigation bar;-&nbsp;&nbsp;the code just doesn't seem to do anything.&nbsp;&nbsp;&nbsp;It's not picking up a cached copy of the page either.<br><br>The trigger code is being executed as other code in the function runs okay.&nbsp;&nbsp;&nbsp;The file <I>does</I> exist and it works fine if I hard-code the value in the report properties, but I really need to do it dynamically from within PL/SQL.<br><br>Is there something obvious that I'm missing out?<br>Has anybody come across any similar problems in Reports?<br>Any ideas or suggestions would be appreciated.<br><br>Thanks in advance.<br><br>cheers,<br>&nbsp;&nbsp;alan<br><br><br><br>
 
<br>Oracle have reported that this is a known bug in version 6.0 of Reports but that it has been fixed in version 6i.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top