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...
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
Quote from: dax on 04 Oct 2016 05:22:11 PM
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.
Quote from: dmk.3678 on 05 Oct 2016 12:57:01 AM
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.
Quote from: MFGF on 05 Oct 2016 04:32:01 AM
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.