Drill through based on the condition

[Nithesh UC]

Hi All,

I have one scenario where i need to drill through to the other report when the condition is satisfied.
FYI: When the employee itself is a manager then i need to display the details of complete employee details.

Any help/suggestion would be of great!

Thanks,
uC

[RKMI]

Hi uC,

If you have a list of managers then you can make a render varible, use marco which looks at user login if true/ false. After which you need to creat a drillable objectis non drillable when employee is not on the manager list else if he is show up on the list render the a copied object which has drill through enabled. *Note: Object can be text feild or data item value.

Drawback to this is when manager runs the report in backgroud and send email report over to employee the link will remain active. To disable this you need to lock the drill target report in premission and deny the employee from that level access.

I hope this makes sense.

Thanks,
RK

[Satheesh]

Hi,
You can use Conditional Blocks.
1. Create a String or Boolean variable with the condition EMPcode = mangr
2. In report page List drag column (on which you apply). Unlock the report drag two Conditional blocks  in that column assign to Boolean variable One Condition Block is for YES another is For No. Copy the data item on which u apply drill through and paste it into 2 conditional blocks.
3. Select YES conditional block apply drill thru.


You can get the output like who ever Manager then only drill thru is apply.


Regards
Sateesh
+91 98672 00664

[RKMI]

Hi Satheesh,

Thanks for spelling out the steps, thats the same solution I provided in trems of logic.  :o

Thanks,
RK

[Nithesh UC]

Thanks both of you guys..


That solution really make sense!