Two IR's on one Page

Orders

		Rows				Select Columns Filter Sort Control Break Highlight Compute Aggregate Chart Flashback Reset Help Download

	Order Id	Customer Id	Order Total	Order Timestamp	User Id
	1	1	1200	23/10/2009	2
	2	2	599	18/10/2009	2
	4	3	750	08/10/2009	2
	5	3	40	03/10/2009	2
	6	4	250	28/09/2009	2
	7	5	3800	23/09/2009	2
	8	6	40	18/09/2009	2
	9	6	450	13/09/2009	2
	10	7	500	08/09/2009	2

1 - 9

Click on the little arrow the synchronize the Order Details.

Explanation

	Problem : You can't define two Interactive Reports on the same page. Solution : Use an IFRAME 1. Create a page (ex. 24) with an Interactive Report on DEMO_ORDER_ITEMS - set the Page Template to 'Printer Friendly' 2. Create a page (ex. 23) with an Interactive Report on DEMO_ORDERS 3. On page 23 create an HTML Region with as Region Source: <IFRAME src="f?p=&APP_ID.:24:&SESSION." style="width:600px;height:600px" name="details" scrolling="no" marginwidth="0" marginheight="0" frameborder="0" vspace="0" hspace="0" /> 4. Set the Link Column attributes of the Interactive Report on DEMO_ORDERS to: - Link Column : Custom Target - Link Attributes : target="details" (that's the name of the IFRAME) - Target Page : 24 - Clear Cache : 24,RIR (will clear the IR cache on Page 24) - Item 1 : IR_ORDER_ID as the Name, #ORDER_ID# as the Value (will set ORDER_ID as Search Item Now if you click on the Column Link on the left IR, the right IR gets synchronized.

Blog Post
Two IR's on one Page

Order Items