Cascading report is used to extract data from one prompt to another prompt.
Drill through report is used to extract the data by selecting the column in a report and it can be drilled down by clicking the column data.