11-24-2009 9:11 AM
if i use user 1 and user 2 for org 1 and org 2 respectively. I want user 1 can see the data of org 1 only not org 2 and same for user 2 can see the data for org 2 only how i can do this in reports. Now suppose you have 200 user and org then how you handle this in reports.
11-25-2009 6:23 AM
Hi Ranjeet,
Maintain a table with two fields - user & organisation.
Fill it with proper user & his corresponding org details.
While fetching the data for report output, take the user as input & fetch the corresponding Organisation.
Then while preparing the final output data, prepare it based on the users organisation.
Hope this helps you.
Revert back if you have any issues.
11-25-2009 8:19 AM
11-26-2009 8:59 AM
Hi,
We can restrict user by creating an authorization object also . Create an authorization object with three fields Org , User and
activity . For a refrence you can see any standard auth object .
**In this case you need to maintain table .
Regards
Rahul