Hi Kapil Lehar,
Create a users in the Server and create a group for the members who want to view the report with out restriction and name that group has "Executive Group"
1) Create Calculation like below
if ismemberof("Executive Group")
2) Drag this calculated field in filter and select True
above calculation will Give True whenever Member from Executive group logins will give True and your view will show all the data.
If dealer logged in based on username()=[CwsID] validation it will give TRUE and will show only dealer data
Hope this helps
Plz Mark this answer as correct and helpful to close the thread
I know username function has to be written.
But here is the issue :
My calculated field called 'username' is :
I drag this to the filter shelf and i will select true so that it only shows the relevant bar for the logged in dealer
But the issue arises when the person is executive and he is not present in the dealer list table.
In that case he should be able to see all the dealers.
But with the above condition he wont be able to see any.
Thanks a lot, this is what i wanted.