Expression in group does not response correctly.

[yanivvl0]

hi to all ,

i have a group that contains 2 members the first ia an exprission , the expression check if there is a special string in the field DocumentName , if so it gets a hard-code string , else it gets other field value ( name in Hebrew ) - that way it union values like    

"tochnitavoda2015" , "tochnitavoda2016" , "tochnitavoda2017" to one value "תכניות עבודה" :

if ( DocumentName like '*tochnit*' , 'תכניות עבודה' , SubMenu ) 

it works ok , when i try to drill down to the lower level in the group from 'תכניות עבודה' then i get values equal to a selection

SubMenu = 'תכניות עבודה'   :

before drill down :

after drill down :

Thanks for your help !!

[sunny_talwar]

Would it possible for you to share a sample to look at this issue Yaniv?

[yanivvl0]

hi Sunny ,

its a bit problem - its the performence model , and there is sensitive data in it ( user names .. )

i will be glad to make things more clear , if you have any questions on any subject,

as always -  thanks a lot!

[sunny_talwar]

May be scramble the data before sharing?

Preparing examples for Upload - Reduction and Data Scrambling

[yanivvl0]

HI Sunny , i solve the problem in the DB layer - Thanks!!