Display burst rights info in report?

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

mikeP

Veteran Member

Posts: 151

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

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.

Greg Moeller

Veteran Member

Posts: 1498

MVP

New Poster

Engaged Reader

Avid Reader

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

mikeP

Veteran Member

Posts: 151

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
.