I have a copy of a RB security report I either downloaded from the user group area or perhaps from the Epicor/Vantage downloads. I know I did not write it. It probably does 80% of what you want but it is not formated that way. I did a quick tweak on it and added a filter for username within the "allowed" entrylist(s). The report uses several levels deep of aliased files so each level of the Security table has to be searched. Quite the tricky little report and not sure who wrote it but something about it seems to hint to me it was Mark Pladson at Epicor.
When I added a filter" UserFound = True
and the calculated field
UserFound =IIF(INDEX(Security-x.EntryList,'caugheyt') > 0 or
INDEX(Security-2.EntryList,'caugheyt') > 0 or
INDEX(Security-1.EntryList,'caugheyt') > 0 or
INDEX(Security-1.EntryList,'caugheyt') > 0,True,False)
The report shows just the items I, by name, am authorized for. Of course I am also in many groups so to be really useful the report would also have to find the groups I am in and use than in setting "UserFound" for the filter.
Instead of bolting the username in the calc field I suppose you could try building it into the filter as a dummy test and parse it out using the Report-Filter function (pre-pass and all that) then feed it back to the filter. But RB sometimes chokes on this sort of thing.
After this reformatting the report for the indentions would be pretty easy. If you can't find it in the download areas let me know.
Now....a Crystal version would be really sweet right about now.
-Todd C.
-----Original Message-----
From: Larry Barriere [mailto:
larrybarriere@...]
Sent: Wednesday, December 01, 2004 2:58 PM
To: Vantage Group
Subject: [Vantage] Security Report
I have been trying to write a simple security report without any success.
What I am trying to do is create a report for a SINGLE user to see what right he/she has.
I can get the groups that the user is a member of. This particular individual is in three groups (AP, MFGEng, OffMgr). But I have not been able to come up with a report that would say for example:
John Doe Sales Managements
Order Management
General Operations
Order Entry
Production Managements
Job Management
Master File Maintenace
Department
etc.
If anyone has any guidance on how I could do this. I would be forever greatful
Larry
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Sponsor
ADVERTISEMENT
<
http://us.ard.yahoo.com/SIG=129btp7fm/M=298184.5639630.6699735.3001176/D=groups/S=1705007183:HM/EXP=1102021113/A=2434971/R=0/SIG=11eeoolb0/*http://www.netflix.com/Default?mqso=60185400> click here
<
http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=groups/S=:HM/A=2434971/rand=519696297>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:
vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <
http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]