Author Topic: Difference between a cascading report and drill thru  (Read 78 times)

0 Members and 1 Guest are viewing this topic.

Offline rpmolecule

  • Full Member
  • *
  • Posts: 224
  • Karma: +1/-0
  • Seize the Day!
    • View Profile
Difference between a cascading report and drill thru
« on: April 02, 2009, 05:46:16 AM »
Tanong ko lang... what is the difference between a cascading report and drillthru report?why do we go for drill thru report?

« Last Edit: August 07, 2014, 03:22:54 AM by rpmolecule »

Techronnati | where technology never sleeps

Difference between a cascading report and drill thru
« on: April 02, 2009, 05:46:16 AM »

Mountain View

Offline Transformer10

  • Full Member
  • *
  • Posts: 104
  • Karma: +0/-0
    • View Profile
Re: Difference between a cascading report and drill thru
« Reply #1 on: August 07, 2014, 03:23:21 AM »
Just to give you an idea,  Drill Through is used to link the master & detail reports.
After putting drill through if you click on a link (e.g. Order ID 1234) in the master report then the details will be displayed for that particular item (Order ID 1234).

Cascading prompt uses the value from the previous prompt to filter the value in the current prompt.

For Cascading no need of two reports.If a report having two related columns (e.g. Country & States) then we can cascade these two columns by adding two value prompts.

If you select a country (e.g INDIA) in the next prompt all the states will be displayed those which are under INDIA.

If you want to see the details for the state Tamilnadu then select TN from the list which will display all the details for TN.

 

Related Topics

  Subject / Started by Replies Last post
0 Replies
143 Views
Last post September 10, 2008, 07:35:29 AM
by MrSpecialist
0 Replies
69 Views
Last post April 02, 2009, 05:43:44 AM
by MrSpecialist
0 Replies
65 Views
Last post April 02, 2009, 06:31:00 AM
by CyborgRepublic
0 Replies
65 Views
Last post April 02, 2009, 06:39:31 AM
by CyborgRepublic
0 Replies
112 Views
Last post April 02, 2009, 06:42:14 AM
by CyborgRepublic

Posting Disclaimer: Any individual may post a message in this forum and may do so anonymously. Therefore, the sole author is exclusively and entirely responsible for all opinions in that message. They do not represent the official opinions of Techronnati, its administrators or moderators or the Techronnati Management. Techronnati is merely acting as an impartial conduit for constitutionally protected free speech and is not responsible and will not be held liable for the content of such messages. All images and service logos are trademarks of their respective owners.