Business case
You want to create a page with two or more reports that are connected with each other. A kind of master-detail for reports.
In this example we show the list of departments and as a child report we show the employees of that department.
Solution
We start with building a blank page for our reports. Add the different report regions on the page. Whether you are using interactive reports or classic ones, it doesn't matter. The solution works for both.
Once the reports are present and working independently, we can start making them connected.
The first report is called master and the second one is called the detail report.
Follow these steps to connect the reports:
- Create the necessary page items to hold the information to be passed on to the detail report. In my case this is only the primary key. So I create a page item called P7_DEPT_PK_ID. These page items can be set to hidden, since they have no added value for the end-user. But for testing purposes, we lease them visible so we can see what is being passed on. You can make them hidden, once everything is working correctly.
- Now we need some javascript-code to pass the values of the current selected master record to these page items. The easiest way is by using a link column on the master report. As target for this link-column, we use an URL with the following destination:javascript:$s('P7_DEPT_PK_ID','#DEPARTMENT_ID#');You can see here that we are using a method called "$s", which can be used to put values in items. As parameters we give the name of the destination parameter and the value, which in this case is the DEPARTMENT_ID from the currently selected master record.
Some nice explanation on these javascript functions can be found in this blog: https://apex.oracle.com/pls/apex/germancommunities/apexcommunity/tipp/6341/index-en.html. - Once the value of the PK is now in this page item, we still need to refresh the detail report. This can be done through the use of a dynamic action. In this dynamic action we indicate that whenever the page item P7_DEPT_PK_ID is changed, we need to refresh the detail report.
- The only remaining thing to do is to use the page item in the query of the detail report.
- Because we are using javascript to fill in the page item, we need to submit the page item to the server, when we are refreshing the detail report. This is done through the property 'Page Items to Submit' on the detail report.
- Now you can run your solution
Hmm, it seems like your site ate my first comment (it was extremely long) so I guess I’ll just sum it up what I had written and say, I’m thoroughly enjoying your blog. I as well as an aspiring blog writer, but I’m still new to the whole thing. Do you have any recommendations for newbie blog writers? I’d appreciate it.
BeantwoordenVerwijderenBest Selenium Training in Chennai | Selenium Training Institute in Chennai | Besant Technologies
Awesome..You have clearly explained …Its very useful for me to know about new things..Keep on blogging..
BeantwoordenVerwijderenangularjs Training in bangalore
angularjs Training in btm
angularjs Training in electronic-city
angularjs Training in online
angularjs Training in marathahalli
Hi, Great.. Tutorial is just awesome..It is really helpful for a newbie like me.. I am a regular follower of your blog. Really very informative post you shared here. Kindly keep blogging.
BeantwoordenVerwijderenpython training in tambaram | python training in annanagar | python training in jayanagar
This is most informative and also this post most user friendly and super navigation to all posts... Thank you so much for giving this information to me..
BeantwoordenVerwijderenDevops Training courses
Devops Training in Bangalore
Best Devops Training in pune
Devops interview questions and answers
This is most informative and also this post most user friendly and super navigation to all posts... Thank you so much for giving this information to me..
BeantwoordenVerwijderenbest rpa training in chennai | rpa online training |
rpa training in chennai |
rpa training in bangalore
rpa training in pune
rpa training in marathahalli
rpa training in btm
This is a nice article here with some useful tips for those who are not used-to comment that frequently. Thanks for this helpful information I agree with all points you have given to us. I will follow all of them.
BeantwoordenVerwijderenJava training in Chennai | Java training in Bangalore
Java interview questions and answers | Core Java interview questions and answers
That was a great message in my carrier, and It's wonderful commands like mind relaxes with understand words of knowledge by information's.
BeantwoordenVerwijderenData Science Training in Indira nagar
Data Science training in marathahalli
Thanks for your great and helpful presentation I like your good service. I always appreciate your post. That is very interesting I love reading and I am always searching for informative information like this. Well written article Thank You for Sharing with Us pmp training institute in chennai | pmp training class in chennai | pmp training near me | pmp training courses online | pmp training fee | |
BeantwoordenVerwijderenThanks a lot very much for the high your blog post quality and results-oriented help.
BeantwoordenVerwijderenDevops Training in Chennai | Devops Training Institute in Chennai
Nice tutorial. Thanks for sharing the valuable information. it’s really helpful. Who want to learn this blog most helpful. Keep sharing on updated tutorials…
BeantwoordenVerwijderendevops online training
aws online training
data science with python online training
data science online training
rpa online training
We are a group of volunteers and starting a new initiative in a community. Your blog provided us valuable information to work on.You have done a marvellous job!
BeantwoordenVerwijderenMicrosoft Azure online training
Selenium online training
Java online training
Python online training
uipath online training
excellent information....!
BeantwoordenVerwijdereninplant training in chennai
inplant training in chennai
inplant training in chennai for it
brunei darussalam web hosting
costa rica web hosting
costa rica web hosting
hong kong web hosting
jordan web hosting
turkey web hosting
gibraltar web hosting
very nice.....!
BeantwoordenVerwijdereninplant training in chennai
inplant training in chennai
inplant training in chennai for it
italy web hosting
afghanistan hosting
angola hosting
afghanistan web hosting
bahrain web hosting
belize web hosting
india shared web hosting
nice..
BeantwoordenVerwijdereninplant training in chennai
inplant training in chennai
inplant training in chennai for it
hosting
india hosting
india web hosting
iran web hosting
technology 11 great image sites like imgur hosting
final year project dotnet server hacking what is web hosting
macao web hosting
nice...................
BeantwoordenVerwijdereninplant training in chennai
inplant training in chennai
inplant training in chennai for it
algeeria hosting
angola hostig
shared hosting
bangladesh hosting
botswana hosting
central african republi hosting
shared hosting
very nice post blog.........
BeantwoordenVerwijderenr programming training in chennai
internship in bangalore for ece students
inplant training for mechanical engineering students
summer internships in hyderabad for cse students 2019
final year project ideas for information technology
bba internship certificate
internship in bangalore for ece
internship for cse students in hyderabad
summer training for ece students after second year
robotics courses in chennai
Did you hear there's a 12 word phrase you can tell your partner... that will trigger deep feelings of love and instinctual attractiveness for you deep inside his chest?
BeantwoordenVerwijderenBecause hidden in these 12 words is a "secret signal" that fuels a man's instinct to love, please and look after you with all his heart...
12 Words That Fuel A Man's Desire Instinct
This instinct is so hardwired into a man's mind that it will drive him to work harder than before to love and admire you.
As a matter of fact, fueling this powerful instinct is absolutely essential to achieving the best ever relationship with your man that the moment you send your man one of the "Secret Signals"...
...You will soon notice him expose his heart and soul to you in a way he never expressed before and he will recognize you as the one and only woman in the universe who has ever truly interested him.
Great post! I am see the programming coding and step by step execute the outputs.I am gather this coding more information.
BeantwoordenVerwijderenAWS training in chennai | AWS training in annanagar | AWS training in omr | AWS training in porur | AWS training in tambaram | AWS training in velachery
The information regarding hyusman industry is very well explained.Step by step explanation is helping me to understand the concepts clearly.Your efforts are really worth.Keep going.
BeantwoordenVerwijderenJava training in Chennai
Java training in Bangalore
Java training in Hyderabad
Java Training in Coimbatore
Java Online Training
Really nice and interesting post. I was looking for this kind of information and enjoyed reading this one. Keep posting. Thanks for sharing.
BeantwoordenVerwijderenhadoop training in chennai
hadoop training in tambaram
salesforce training in chennai
salesforce training in tambaram
c and c plus plus course in chennai
c and c plus plus course in tambaram
machine learning training in chennai
machine learning training in tambaram
Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging…
BeantwoordenVerwijderenangular js training in chennai
angular js training in velachery
full stack training in chennai
full stack training in velachery
php training in chennai
php training in velachery
photoshop training in chennai
photoshop training in velachery
Great.. Tutorial is just awesome..It is really helpful for a newbie like me.. I am a regular follower of your blog. Really very informative post you shared here. Kindly keep blogging.
BeantwoordenVerwijderensap training in chennai
sap training in omr
azure training in chennai
azure training in omr
cyber security course in chennai
cyber security course in omr
ethical hacking course in chennai
ethical hacking course in omr
Superb. I really enjoyed very much with this article here. Really it is an amazing article I had ever read.
BeantwoordenVerwijderenjava training in chennai
java training in annanagar
aws training in chennai
aws training in annanagar
python training in chennai
python training in annanagar
selenium training in chennai
selenium training in annanagar
Thanks for your informative article,Your post helped me to understand the future and career prospects & Keep on updating your blog with such awesome article.
BeantwoordenVerwijderenjava training in chennai
java training in porur
aws training in chennai
aws training in porur
python training in chennai
python training in porur
selenium training in chennai
selenium training in porur
This was a very informative article, indeed loved to read and clear my doubts. Keep us posted a lot more blogs. Also check out our blog pages too.
BeantwoordenVerwijderendata science training in chennai
ccna training in chennai
iot training in chennai
cyber security training in chennai
ethical hacking training in chennai
Hey, Wow all the posts are very informative for the people who visit this site. Good work! We also have a Website. Please feel free to visit our site. Thank you for sharing.
BeantwoordenVerwijderenBe Your Own Boss! If you're looking for a change in your work prospects, then let's prepare for your career from here!!!
Self Employment | Women Development | Information Technology | Engineering Courses
Mgmibet Casino Login - JTG Hub
BeantwoordenVerwijderenHow to login to Mgmibet 군산 출장마사지 Casino and get your 원주 출장샵 login details. You can use any 충청북도 출장샵 of our links and make 양산 출장샵 your registration. You 대전광역 출장마사지 can open the