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.