• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Bursting, How can I restrict one group and allow the rest

 4 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
mikeP
Veteran Member
Posts: 151
Veteran Member
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
Basic Member
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
Advanced Member
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
Veteran Member
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
Advanced Member
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.