Passing Colors based on the user Login in Section access

[#1]

Hi Guys,

I have created an application which will Change the color cheme of the application based on the Login user (using Section Access) but here i got struck with onething One user accessing the data of two customers(clients) , so the color of the application should change based on selection of customers button on the front end .

Let me give you all an example

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD

    ADMIN, ADMIN, ADMIN

    USER,USER1,USER1

    USER, USER2, USER2

    USER, USER3, USER3

];

Section Application;

NoConcatenate

LOAD * INLINE [

  USERID, Customer_Code, User_Role,v__ColorChange,

  USER1,'ABC Company',1,'Violet'

  USER1,'DEF Company',1,'Green'

  USER2, 'ABC Company',2,'Violet'

  USER3, 'DEF Company',3,'Green'

  ];

So based on the above code by default when user Logs in i am getting the expected result

                         CompanyData Shown      ColorWe Get on report

For USER2          'ABC Company'               'Violet'

For USER3           'DEF Company'               'Green'

But for USER1 i require both so i am able to display the data for both but

"How can i get the color related to that company when that company is selected through Text Box"

like for user and on selection of ABC company it should show me Violet , for DEF Company it should show me green

For USER1          'ABC Company'                'Violet'

For USER1          'DEF Company'                  'Green'

Please help me out from this as i have tried some features but the problem is that when we click on the clear button the color changes are getting back to default and These attributes should not be shown in current selections

[#2]

Hi ,

Pls Is there anyone who could help me out ?

[Anonymous]

try to use textcolor or Background Color for your Dimension "CompanyDataShown" and define

"only(ColorWe Get on Report)

But you Need the Color whether as predfeined color like green(), red() or with rgb values

like ABC Company rgb(x,y,z)

in my example i have a Dimension and used the Color Definition i have in 1 column

[#4]

Hi Rudolf,

Thanks for your time !!!..Actually i am using the color not just for charts but also for highlighting the Text color on Buttons and Background color and Labels .

[Anonymous]

this should be the same

if you select the Company (and only one Company) you canuse

the same Expression for textcolor etc.

"only(ColorWe Get on Report) as it contains only 1 Color for 1 company

[#6]

How can i use the only function ?, Can i use it on Triggers/Actions ?

You have got any example which you can share so that it can be helpful for my understading

[Anonymous]

you can skip the only function if you ensure that only one value is selected.

you can use it on Triggers also if only one value is selected

I would test it on a button or Dimension and Color function

next step use Trigger etc.

one step by the other

[#8]

Maybe i got you idea partially, let me try and come back

[#9]

Many thanks !!