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

Display burst rights info in report?

 3 Replies
 0 Subscribed to this topic
 23 Subscribed to this forum
Sort:
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
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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
.