Crystal Reports XI R2 - Java Prompts
We have some Crystal Reports that are row-level security based on location.
We are using Business Objects Enterprise Server that uses InfoView to work with Security with Reports.
Outside of BOE a user/folder/location table was created and will be maintained by a web application and it interfaces to the CMC BOE security information.
An exception to the security is for certain users that will need to have access to all locations for these location secured reports, regardless of the report's containing folder.
To this end, a new special group will be created and assigned to such users. It's sole purpose is to act as a flag, to indicate that this user needs to be able to see data from all locations.
When user clicks on a standard report link within InfoView, that the rpt code starts to execute.
The rpt code, which is responsible for presenting the query prompts, will these prompts be able to interface with a java program module ????. that will be written to return either:
A flag will be passed back to indicate there should be no location restrictions (provided, user belongs to this special group)
LOV of locations for which the user has access to.