Multiple Interactive Reports on One Page

If you have been using Interactive Reports since Apex 3.1 landed, you are probably as impressed with them as I am.

The other day I tried to create more than 1 IR on a page and the Wizard prevented me saying "Only 1 Interactive Report can be declared on this page"

I then tired to copy a region that contained an Interactive Report and sure enough I suddenly had 2 IR's on the one page!

Whilst this is probably not supported or suggested, my requirement meant that only 1 IR was to be shown at once (i.e. I had a conditional diaply on both IR)

So if you need to create multiple IR's on the one page but will only display one at run time, copy of a region appears to work!

Comments

Anonymous said…
Hi,
nice way of having multiple IRs in one page! can you please show us how/where did you set the conditions?

Thanks again,
Odeh
26 February 2009 at 16:12
Anonymous said…
Good spot on the workaround for this. This is exactly what I wanted to do too, as I wanted to have a top region with a select list for report names, and the inteactive report for the relevant list choice displaying below. The thought of having the list replicated on multiple pages and the branching etc required to have each interactive report on separate pages would've been more fiddly.
22 April 2009 at 11:56
AJ said…
Good insight...but need to go just a little further...if possible:

Any insight would be great...banditaje@yahoo.com

Thanks in advance...


OK..2 months into Oracle apex

MY dilemma...

Working on ..print page breaks with multiple reports in one region...regular reports, graphs and/or interactive reports.


CSS & JAVASCRIPT are limited when the page-break-(before or after):always

especially when one of the reports within the region contains interactive reports with dynamic rows.

Question? Is it possible to control multiple reports within a region within one template?

Really, don't have a clue where to start.

Thoughts...possibly create unique tag DIV for each report section and then control breaks (using CSS) based on the specific report within the region. (confused on modifying exisitng reports based on class structure built into apex).

I had a thought of controlling the specific interactive reports using:

http://forums.oracle.com/forums/thread.jspa?messageID=3197201&#3197201

NO CLUE OF HOW TO ACCOMPLISH. Any direction for creating special template to wrap each section seperately?

FYI
OK...BI publisher isn't the answer I'm looking for...
22 November 2009 at 03:48
Anonymous said…
Sweet !!! works perferctly ..
Thanks Conor C
9 April 2010 at 16:52
Anonymous said…
Looks like Oracle have "fixed" the workaround in 4.0 :(
15 July 2010 at 19:45
Post a Comment

Popular posts from this blog

Custom Authentication / Authorisation Schemes (Part 1)

I often see posts on the APEX forum asking how to implement custom Authentication / Authorisation schemes within their applications. The following is something I have used in several apps over the last couple of years and provides a great base for securing your application. The code base is largley based on the rather excellent article " Storing Passwords in the Database " found here with a few tweaks and changes. Firstly, just to clarify, Authentication Schemes control access to the application and Authorisation Schemes control access to page items / regions and even pages themselves. Implementing your own Authentication I tend to set up an APP_USERS table that stores Username and encrypted passwords that I Authenticate against when page 101 is submitted. All this will be explained in detail as we go. Create the APP_USERS table CREATE TABLE APP_USERS ( USERNAME VARCHAR2(10), PASSWORD VARCHAR2 (255) ); Create the Application Security Package CREATE OR REPLACE PACKAGE app_sec...
Read more

Custom Error Handling in APEX

If like me you have written several PL/SQL procedures within your APEX app, you will have had to deal with the issue of error handling. As a general rule, I try to hide all Oracle Error Messages from the user and replace these with something more meaningful for example: If a user breaks a unique key by trying to insert the same value twice, the following error message is not uncommon: ORA-00001 Unique constraint violated There is little or no merit rendering this message to a user as those outside the Oracle community, may not be able to deduce what went wrong. We can capture this error and translate it to a user friendly message explaining what went wrong for example: The record you tried to create already exists. Please try again In order to achieve this in APEX, the process is relativly simple. Set up your Custom Error Page 1. Create a new page with the following attributes: Page type: Blank Page Page Number: your choice (for this example I used page 500) Page Alias: ERRPAGE Name:...
Read more

Sum to Parent Nodes in Hierarchy Queries: CONNECT_BY_ROOT

In one of our Applicaitons, the table DEPT contains a self referncing join (Pigs Ear) as it models our organsational department hierarchy. For example: CREATE TABLE DEPT ( DEPT_ID NUMBER NOT NULL ,PARENT_ID NUMBER ,DEPT_NAME VARCHAR2 (100) NOT NULL ,EMPLOYEES NUMBER NOT NULL ,CONSTRAINT DEPT_PK PRIMARY KEY (DEPT_ID) ,CONSTRAINT DEPT_FK01 FOREIGN KEY (PARENT_ID) REFERENCES DEPT (DEPT_ID) ); INSERT INTO DEPT VALUES (1,NULL,'IT', 100); INSERT INTO DEPT VALUES (2,1,'DEVELOPMENT', 12); INSERT INTO DEPT VALUES (3,1,'SUPPORT', 15); INSERT INTO DEPT VALUES (4,1,'TEST', 25); INSERT INTO DEPT VALUES (5,2,'PL/SQL', 2); INSERT INTO DEPT VALUES (6,2,'Java', 1); INSERT INTO DEPT VALUES (7,2,'SQL', 11); INSERT INTO DEPT VALUES (8,2,'C++', 3); INSERT INTO DEPT VALUES (9,4,'Functional', 3); INSERT INTO DEPT VALUES (10,4,'Non Functional', 5); COMMIT; A quick tree walk using CONNECT BY PRIOR shows you the Parent / Child rel...
Read more