The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
VA Teams
Posted: 30 Jun 09 9:12 AM
|
I have two clients that would like the users to be able to view not only their personal information in VA but that of their SLX team members.
I have tried different methods of modifying the load script all without success!
Has anyone out there delt with this request before and how did you handle it?
Thanks
Geo! |
|
|
|
Re: VA Teams
Posted: 30 Jun 09 9:40 AM
|
SLX applies security to the report.
You could run Script to clear out this condition.
I pretty much Implement my own security by using Teams to handle the Level of visibility. E.g. No membership to special VA Team means you can see your data, VA Level 1, you could see one level down (as long as you have anyone who reports to you, Level 2 you could see 2 levels down and Level 3 you could see the whole DB.
Then again, since they are remote Subscription also comes into play....
|
|
|
|
Re: VA Teams
Posted: 30 Jun 09 9:55 AM
|
Raul
The problem I have is not that the manager cannot see thier team items. it is that team members cannot see other team members info. I am to the point that I want to rewrite the data pull by using SQL Views, at least that way you can easily see the data that is being loaded.
Thanks for your Reply
Geo |
|
|
|
Re: VA Teams
Posted: 30 Jun 09 10:17 AM
|
That I did understand, I was just explaining how I had gone further to bypass the built security and apply my own.
Are the users able to see the data on SLX? If so, the data will get loaded onto the Report file.
However, and this is what I was trying to communicate, SLX applies data filter based on the user login code and locks it.
You should be able to create a Function to remove it from the report and then add that function to an event on the report:
e.g.
Sub OnOpen
....
ActiveDocument.Fields("NAME").Unlock ' Since SLX Locks the field, Unlock it -- Sorry, I don't have the field name handy.
ActiveDocument.Fields("NAME").Clear ' Clear the Field value
ActiveDocument.GetApplication.WaitForIdle(2000) ' This just gives the Wait for Idle a timeout, otherwise VA tends to lock on me, but may be due to the amount of Code and Data that I am loading into my reports.
....
End Sub
|
|
|
|
Re: VA Teams
Posted: 30 Jun 09 10:25 AM
|
Hey thanks Raul, I get where you are coming from. I will try this and see if I get anywhere.
Geo |
|
|
|
Re: VA Teams
Posted: 30 Jun 09 12:13 PM
|
If you want to totally disable security, just go into the load script - go down to the very end.
(It should be the cleanup tab).
Add this line
Drop Field SECCODEID;
This will disconnect the user table from everything else, making everything visible to everyone.
Its quick.
Its dirty.
It should work for you.
hth
ws |
|
|
|