[Closed]prompt not working in drill through report.

[Srik]

Deleted total from report and its working fine.
Thanks for responces..

-------------
Hi,

How to pass prompt value to detail report when user drill through from "Total ", detail report is displaying all values regardless to the prompt selected in the master report.
Parameter value of prompt is null  when value from total is passed through drill through,
where as prompt value is passed from rest of the cells.

Thanks in advance
Kanth.

[DanSev]

OK.  You can just turn off the drill through links on the total line.
Secondly- the drillthrough report has to have the same filters in place as the parent report (optional) if filtering is to be done the same way. That way you can pass the values to the drillthrough report by passing the parameter values selected on the parent report.

So if the drillthrough report is only filtering on the data item value passed, it will get a null and not filter (if optional, or not return anything if required) it is not enough. The dt report has to have the filter that the parent report has that is prompted for.

(eg. parent filters on country. report you see is states. click a state, get the details, click the total get all countries details. on the dt report there needs to be the filter in the query [Country]=?param_parent?, where the param_parent is fed by the drillthrough link. first modify the drillthrough, then save, then update the drillthrough links on the parent to bring up the new parameter, and pass the parameter from the parent prompt tot it.

[Srik]

Thanks for your quick response.

As you mentioned i'm passing all the the filters to drill through.
I have 2 prompts in my report

1) Date  required and single select
2) status id  Optional and Single selects

Drill through works fine when user runs for all status,

Drillthrough report is getting filtered on Date filter but status filter is not working.

Thanks,
kanth

[Suraj]

first if you are gettting null for paramdisplay, the value is not passed.
second, the issue could be with the way you are using your optional filter in your target report.