Displaying objects as per user rights

[#1]

So when user1 logs in, it should display

Pivot table 1

Hello,

I have 2 pivot tables and depending on user rights it should display the object.

Layout is as below.

Pivot table 1

Pivot table 2

I have 3 users: user1, user2 and user3

user1 is having access to Pivot table 1

user2 is having access to Pivot table 2

user3is having access to both Pivot table 1 and Pivot table 2.

So when user1 logs in, it should display

Pivot table 1

So when user2 logs in, it should display

Pivot table 2

So when user3 logs in, it should display

Pivot table 1

Pivot table 2

So how to make it working.

[tresesco]

See: Object level security

[ashfaq_haseeb]

Hi Rupali,

You can do the same with osuser() function.

Right click on your chart1 --> Properties --> Layout --> Select Conditional

and write below code.

If(osuser()='Domain\user1',1,0)

Simultaneously do the same for the other users and charts.

Regards

ASHFAQ

[jagan]

Hi,

Check this thread, hope it helps you.

Chart Level Access by user

Regards,

Jagan.

[#5]

Hello Jagan,

Ya using this option we can hide or show the pivot tables.

But then in my case, Pivot table 1 and Pivot table 2 are placed 1 below the other.

so when Pivot table 2 should be displayed, space required for pivot table 1 is blank and then below it Pivot table 2 is displayed.

and when user with both access, should be able to see Pivot table 1 and below it Pivot table 2.

[jagan]

Hi,

It is not possible to change the coordinates of the charts based on the user, instead you can put the charts in container object, based on the user access the charts are displayed.

Hope this helps you.

Regards,

Jagan.

[#7]

Hello Jagan,

Yes tried with the container object with the grid style.

If we use single object type, then it displays object as per user access.

But if we use grid style, still it shows blank space when a object is not displayed.

so we cant change the coordinates in container also?

[jagan]

Yes we cannot change the coordinates in container.

[#9]

Hello Jagan,

I am now using container object and it have solved my problem...

But then when I create report using Reports -> Edit Report section,

I am facing problem that is shows only 1 object at a time based on the selected tab.

e.g: if 1st tab of the container is selected, report will will show object of 1st tab, and when 2nd tab is selcted, it will show that object..

how can I resolve this issue?

[jagan]

Hi,

It is not possible to handle the container objects in report, instead you can create the same set of objects and hide it behind the container and drag this objects into the report.

Hope this helps you.

Regards,

Jagan.