Problem in Drill Trough of IWR --- URGENT

[astra1]

Hi,

We are facing the following problems in the IWR:

1. We are not getting the Drill Through Option when we run the report. Tried both in Excel as well as PDF.

2. There are 3 sub reports in the IWR excluding the main report. we need to drill through from Sub Report 2 to Sub Report 3... Is it Possible????

This is VERY Urgent and any help will be highly appreciated

Thanx in advance

Regards,

Vish

 

[sharatkb]

Hi,
Is your first query related to the second query ?

Regarding your second query, we can drill through from a value in the parent report's main query to a main query in the child report.

So, if we try to drill-through to a report whose main query doesn't contain the selected column then Impromptu displays the following message: "The drill-through report does not contain all of the selected columns"..

But, if we have the selected column in the Main Query of the child report and the main query and sub-query of the target(child) report are linked, then we can achieve the required output.

I hope this helps...

Regards