Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Performance Management
Lawson Business Intelligence/Reporting/Crystal
Creation of New Role In RS
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
chaoticist
Past 24 Hours:
2
Prev. 24 Hours:
0
Overall:
5185
People Online:
Visitors:
190
Members:
0
Total:
190
Online Now:
New Topics
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
IPA/ProcessFlow
IPA executing Job
3/13/2024 7:08 PM
New to the IPA world and was wondering, can an IPA
Lawson S3 HR/Payroll/Benefits
Life Age Reduction on benefits plans
3/12/2024 7:15 PM
For our optional life we have an age based coverag
Lawson S3 HR/Payroll/Benefits
BN53.1 Add-In
3/7/2024 3:31 PM
We are migrating to Solstice. They require a
Lawson Business Intelligence/Reporting/Crystal
Domain Name Change
3/5/2024 7:45 PM
Our domain name needs to change and was hoping I c
S3 Customization/Development
Cobol calling Shell Script
2/29/2024 1:27 PM
Has anyone created or modified a Lawson Cobol prog
Infor ION
ION vs IPA
2/29/2024 1:24 AM
We had a person new to Lawson and Infor go to Info
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1348
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Lawson Business Intelligence/Reporting/Crystal
Creation of New Role In RS
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
Ruma Malhotra
Veteran Member
Posts: 412
9/14/2010 2:34 PM
Is there a way to create a role in reporting services that has access to all departments but excludes 2 departments.
All users can access all reports for all departments except for those 2 that have been restricted.
Chris Martin
Veteran Member
Posts: 277
9/14/2010 2:39 PM
Hi Ruma,
One way that I've handled this type of situation is by filtering these departments out at the sql/report level. It's not ideal, but less maintenance than creating/maintaining rights to handle this.
Thanks,
Chris
Jimmy Chiu
Veteran Member
Posts: 641
9/14/2010 2:45 PM
You can do this in many ways within LBI reporting services.
You can create a "Everyone" security group, then assign "roles" to the security group, then assign the security group to reports except the two departments' reports?
Ruma Malhotra
Veteran Member
Posts: 412
9/14/2010 2:52 PM
Sorry not be clear. But of all the users, that access these reports there are 2 users who need access to these departments.
If I filter these departments in the crystal report then those 2 users will not have access to these 2 departments that they need to see.
I am trying to think whether I can create a role in RS that has access to all of the depratments and one that does not have access to those 2 departments.
Looking at the report security groups, roles for RS I cannot think how to exclude a department on the ceration of a role in RS.
Chris Martin
Veteran Member
Posts: 277
9/14/2010 3:07 PM
Okay, I understand now. I haven't tested this out, but I believe this would work:
*Create a Right for the 2 users who can see all depts:
1) Create a Structure Group with Dept element = *
*Create a Right for the rest of the users who can't see the 2 depts:
1) Create a Structure Group with Dept element = *
2) Create a Structure Group that has the Dept element "Not Equal To" those 2 depts
*Create separate roles for a) the 2 users who can see all depts and b) the rest of the users and assign these roles to the appropriate rights created in the 1st two steps.
Ruma Malhotra
Veteran Member
Posts: 412
9/14/2010 3:27 PM
Thanks for the quick replies. I am creating it now and testing it. Hopefully is should work .
Thanks again.
Ruma Malhotra
Veteran Member
Posts: 412
9/14/2010 5:56 PM
It is not working.
These are my steps.
There is a role in LS sec admin called - lbi-rpts. This is added to each id in ls.
I created a new right and defined it as dept = * and dept != 800 and dept != 801. This right is added to to lbi-rpts.
The report is bursted by this structure which manes that whenever any user belonging to this right runs the report he will be able to access all depts but not 800 and 801.
Unfortunatedly the users can see both these depts. i cannot understand why.
Chris Martin
Veteran Member
Posts: 277
9/14/2010 6:29 PM
I did some testing and found some odd results. If you create a right with just 1 "not equal to" operand, it correctly displays all values except for the value set to "not equal to". If you create a right with 2 "not equal to" operands, it incorrectly displays all values. Looks like a bug.
Also, it won't allow you to pipe the values when using the "not equal to" operand.
Ruma Malhotra
Veteran Member
Posts: 412
9/14/2010 6:34 PM
I got the same results.
I might take the easy way out and create 2 sets of reports and try and limit the departments in the filter and set access different for these 2 sets.
Chris Martin
Veteran Member
Posts: 277
9/14/2010 6:48 PM
Sounds like your best bet.
FYI - I split the 2 "not equal to" conditions into 2 separate rights (instead of 1 right with multiple Structure Group), but still got the same results (all data).
Ruma Malhotra
Veteran Member
Posts: 412
9/14/2010 8:14 PM
Yes. I am creating and publishing 2 sets of reports with 2 kinds of access which is the only way out.
Thanks for your great help.
You are not authorized to post a reply.