Forums
Lawson Business Intelligence/Reporting/Crystal
Bursting, How can I restrict one group and allow the rest
Author
Messages
mikeP
Veteran Member
Posts: 151
3/12/2014 4:00 PM
Just getting started with bursting. We have a report that should generally be available to all, but handful of users (all in their own custom group) should only see one work location.
Playing with a simple test report, I created the element, structure, and right to restrict that group. What I can't figure out is how to allow another group full access. The only thing that jumps out is to give them a right that is
NOT= "qwzyxs" or some other string that I know is not a real work location.
I'd like to know how to do this in a situation where there's no good value to use in a "NOT=" filter.
Plus,that method seems kludgy. Is there a better way?
Thanks,
Mike
.
AngieP
Basic Member
Posts: 11
3/12/2014 4:30 PM
Hi Mike.
What I have done is use the " within range of" option when setting up the structure for a specific user. For example, I have a report that is burst by department to 5 or 6 users. Only only of those users needs to see all departments. For her structure, I set up a "range" and used AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA to ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ. The other users have a structure that says they should see department equals something like "MDD02". I've had good luck with the range using several different fields, but if someone has a better way, I would love to hear it!
amynelson
Advanced Member
Posts: 25
3/12/2014 5:00 PM
You can also use the asterisk * to default to all values for String fields.
Ex:
Accounting Unit = *
mikeP
Veteran Member
Posts: 151
3/12/2014 5:15 PM
I just tried the asterisk, that'll be a big help. That's not in the Reporting Services Admin guide. :-L
Between that and using a range for numerics, I can make it work.
Thank you both.
amynelson
Advanced Member
Posts: 25
3/12/2014 5:30 PM
For numeric fields, in the crystal report, create a formula to convert TOTEXT(numeric field) and then use * as well. You don't even have to change the design of the report, as long as the formula is created you can burst off it.