Drill Through Issue in DMR Model

[dmk.3678]

In Parent report i have Search & Select Prompt for Encounter No. I Set it as Non-Required, Single Select. The slicer expression i have is #prompt ('Fin_No','memberuniquename','set([KFSH DRG COST].[FIN Number].[FIN Number].[FIN Number Pool]->[all])','set(','',')')# and i am passing ALL Encounters by default. (Prompt Property do not have Default Value to be set.).

Now this works fine with Parent Report, but when i try to Drill-Through, i have Target report with Slicer Expression set([KFSH DRG COST].[FIN Number].[FIN Number].[FIN Number Pool]->?EncNo?), but when i run the report and do drill through its prompting for Encounter No to be selected. So i assume the default in the slicer expression did not actually passed to drill-through.

I have tried setting expression in target report to [KFSH DRG COST].[FIN Number].[FIN Number].[FIN Number Pool]->?EncNo?.
also tried making it as Required Field but still its not passing the value successfully to Target Report.

If i dont select anything in Search & Select, it should pass all to Drill Through...

Please suggest...

[dax]

I believe that you will also need to create to use a slicer with a default value in your target report as well.  If you don't select a prompt value in your source report then the drill through will pass a "null" - you can verify this by viewing the passed source values (right click source value, Go To, Related Links, View Passed Source Values).

There may be another way around this but I came across the same issue a while back and went with the above method, and it works fine.

Dax

[dmk.3678]

I believe that you will also need to create to use a slicer with a default value in your target report as well.  If you don't select a prompt value in your source report then the drill through will pass a "null" - you can verify this by viewing the passed source values (right click source value, Go To, Related Links, View Passed Source Values).

There may be another way around this but I came across the same issue a while back and went with the above method, and it works fine.

Dax

Can you please provide an example of the expression of slicer in Target report.

[MFGF]

Can you please provide an example of the expression of slicer in Target report.

How is the drill-through definition defined? Are you passing the data item value of [Fin Number Pool] or are you passing the parameter value of Fin_No?

MF.

[dmk.3678]

How is the drill-through definition defined? Are you passing the data item value of [Fin Number Pool] or are you passing the parameter value of Fin_No?

MF.

I am passing Parameter Value of the Fin_No.
Can not pass data item, as its not used in the report output crosstab. we wanted to filter the data for Fin_No, so we placed the filter.