PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 03/12/2014 1:30 PM by  amynelson
Bursting, How can I restrict one group and allow the rest
 4 Replies
Sort:
You are not authorized to post a reply.
Author Messages
mikeP
Private
Private
Veteran Member
(407 points)
Veteran Member
Posts:151


Send Message:

--
03/12/2014 12: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
    Sr Lawson HR Consultant
    Avaap
    Basic Member
    (25 points)
    Basic Member
    Posts:11


    Send Message:

    --
    03/12/2014 12: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
    Private
    Private
    Advanced Member
    (69 points)
    Advanced Member
    Posts:25


    Send Message:

    --
    03/12/2014 1:00 PM
    You can also use the asterisk * to default to all values for String fields.
    Ex:
    Accounting Unit = *
    mikeP
    Private
    Private
    Veteran Member
    (407 points)
    Veteran Member
    Posts:151


    Send Message:

    --
    03/12/2014 1: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
    Private
    Private
    Advanced Member
    (69 points)
    Advanced Member
    Posts:25


    Send Message:

    --
    03/12/2014 1: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.
    You are not authorized to post a reply.