Prev
Next
Forums Lawson Business Intelligence/Reporting/Crystal

Display burst rights info in report?

Sort:
You are not authorized to post a reply.
Author
Messages
mikeP
Veteran Member
Posts: 151
Veteran Member
3/19/2014 1:47 PM
    I have a Crystal report that's bursting properly now; most users see all info, one group sees a reduced set.

    Is there a way I can report some bursting rights info on the report, so I could place a header similar to:

    "Report limited to Fund xxx",

    where the xxx comes from the filter criteria placed on the right's imported structure?

    Thanks,

    Mike
    .
    Matthew Nye
    Veteran Member
    Posts: 514
    Veteran Member
    3/19/2014 2:14 PM
      as I recall bursting rights get passed as a selection clause. you could identify the pattern of the rights and then parse them out of the Record Selection special field. Otherwise youll probably need to query RS repository which could be a lot of work.
      If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
      Greg Moeller
      Veteran Member
      Posts: 1498
      Veteran Member
      3/19/2014 2:49 PM
        I've got a report already created, that may help you. I'll attach it here.
        It queries the RS database and will display all rights for a prompted user.

        Feel free to modify as needed. *Note: If you use any |'s (pipes) in your rights values, they will all come out as separate records. Not sure if there is a way around that or not.

        Good luck,
        -Greg
        Attachments
        mikeP
        Veteran Member
        Posts: 151
        Veteran Member
        3/19/2014 4:08 PM
          These responses are very helpful.

          Matthew, I found the bursting selection clause in the CR Special Field, "Record selection formula", it should be easy enough to parse it out.

          Greg, I had read about the RS database. Your report got me looking for it on our SQL Server backend. I found it and created DSNs to convert and run the report. This will be useful knowledge going forward.

          Thank you both.

          Mike
          .

          You are not authorized to post a reply.