Show it, no hide it ... no show it again

Another RTF template enhancement for 10.1.3.3 ... imagine you have a report that maybe has multiple master detail relationships, say a customer listing with each of their invoices listed. If would be nice to be able to expand and collapse customer invoices in the html output providing a level of interactivity.


In previous releases we had an ability to very simply show and hide sections in an output. The sample Customer Orders report that ships with the standalone release showed this off. But it was an all or nothing thang - show all/hide all - we always wanted to allow you to expand/collapse specific regions - we found a horrible way to do it it in a template but it was not practical.


showhide2:


In 10.1.3.3 you can now build such a report, I think it takes the HTML output for publisher standalone to a new level. There are of course some new RTF template commands to add to the template.

<?dhtml:showhide;hide?> <?end dhtml?>

<?dhtml-header:?> <?end dhtml-header?>

<?dhtml-contents:?> <?end dhtml-contents?>


Now rather than bore you with the written details - Im getting hooked on Jing, thanks AppsLabbers- its a 'project' from Techsmith to record your screen and your voice if you are so inclined all for free as long as you can limit yourself to a few minutes. Those of you that know me will know I found it really hard :o)

Well I was so inclined, so here it is, you can see the show hide in action here - sorry the movie has been lost. Of course, the sample files are loaded here.
What's really neat about the solution is that the javascript used to do the show/hide is not part of the BIP server UI but actually embedded in the HTML file itself so you can see that working too, just here.


Not quite here for Apps users - you're getting too much bad news lately - will write about something you can use, I promise.

Comments:

Thanks John - they do have a public site, I just got it wrong http://oracleappslab.com

Cheers

Tim

Posted by Tim Dexter on September 19, 2007 at 03:01 AM MDT #

The AppsLab link is not accessible through the intranet - it will only work inside the Oracle intranet. https://appslab.us.oracle.com/

Posted by John McDonnell on September 19, 2007 at 03:01 AM MDT #

Tim, You mention that we can use this approach within Oracle e-Business suite. Is that still the case? Also I have been playing with the approach using the template add-in. What I want to do is generate a report that displays a table of results and gives the user the ability to expand each row to see some detail about the row. I can get this to work using the above approach but I cant stop the output repeating the column headers. In my template I have: Table with the column headers dhtml:ShowHide[ dhtml:header-show[ Table with the results ]dhtml:Header-show dhtml:Contents[ Table with the detail info ]dhtml:Contents ]dhtml:ShowHide

Posted by David Taylor on November 30, 2009 at 01:59 AM MST #

Hi Is there any way that i can hide some sections in the output based on some condition in the rtf template to produce the pdf output template.. Thanks Neethu

Posted by Neethu on February 28, 2010 at 04:17 AM MST #

None of the links to the examples work for me. Is there any way to get a sample template?

Posted by guest on June 02, 2011 at 04:23 AM MDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Follow bipublisher on Twitter Find Us on Facebook BI Publisher Youtube ChannelDiscussion Forum

Join our BI Publisher community to get the most and keep updated with the latest news, How-to, Solutions! Share your feedback and let us hear your voice @bipublisher on Twitter, on our official Facebook page, and Youtube!

Search

Archives
« February 2015
SunMonTueWedThuFriSat
1
2
3
4
5
6
7
8
10
11
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
       
       
Today