| January 01, 2008 23:55:16 |
#5 |
| binay.bk |
Member Since: January 2008 Total Comments: 4 |
RE: what is the difference between a cascading report and drillthru report?why do we go for drill thru report?
|
Hi
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. |
| |
