EstherGrandal_D
7 years agoQrew Cadet
Summary fields , and override option .
I have two tables whit the flowing relationship;
"to create week reports" < "Time cards"
One record in "to create week reports " to many records in "time cards"
It works perfectly, even the summary fields from the time cards.
But now comes the problem;
My company have different disciplines and I created Users filtering records in "time cards" tables base on this field "discipline"
The user has full access to the Table "to create week reports"
In the table "To create week reports" it have some summary fields , I want the users have access to this data in the table "to create week reports" but not to the field used to calculate this summary field.
I have been using the override option but I do no see any change ;
My users only see the summary field from their time cards , (the out come is the same if I select override that if i do not).
I want to explain you why I do need this override option.
There are reports about the company evolution they are the KPI in the company and they need to be know for everybody , if you see in the report they are in different disciplines one one of them is HVAC, only the people from each discipline should have access to their time cards , in the time cards there is a lot of information and they do no need to be know from other disciplines, we do not want one discipline gossip in the detailed information of time cards from other discipline (things like salaries, categories, ....), is for this I need to have the possibility to show the summary fields without grant access to all sub-fields.
But my user only see this ;
Probably there is a workaround I am not able to see.
Any Idea ??
Thanks.
"to create week reports" < "Time cards"
One record in "to create week reports " to many records in "time cards"
It works perfectly, even the summary fields from the time cards.
But now comes the problem;
My company have different disciplines and I created Users filtering records in "time cards" tables base on this field "discipline"
The user has full access to the Table "to create week reports"
In the table "To create week reports" it have some summary fields , I want the users have access to this data in the table "to create week reports" but not to the field used to calculate this summary field.
I have been using the override option but I do no see any change ;
My users only see the summary field from their time cards , (the out come is the same if I select override that if i do not).
I want to explain you why I do need this override option.
There are reports about the company evolution they are the KPI in the company and they need to be know for everybody , if you see in the report they are in different disciplines one one of them is HVAC, only the people from each discipline should have access to their time cards , in the time cards there is a lot of information and they do no need to be know from other disciplines, we do not want one discipline gossip in the detailed information of time cards from other discipline (things like salaries, categories, ....), is for this I need to have the possibility to show the summary fields without grant access to all sub-fields.
But my user only see this ;
Probably there is a workaround I am not able to see.
Any Idea ??
Thanks.