Crystal Reports XI R2 - Java Prompts

[Former Member]

Hi All,

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)

-

---

Or

-

---

LOV of locations for which the user has access to.

[ted_ueda]

Trying to handle security at the prompting level won't be secure.

What database connectivity are you using? There are some - such as Universes or Business Views - that can pass the Enterprise User identity to the database layer, so your security set-up can do the row-level security.

Sincerely,

Ted ueda

[Former Member]

Hi Ted,

We were connecting to an Oracle Database using ODBC (RDO). using ASP connection strings.

We are porting these standalone Crystal Reports XI R2 into BOE XI R2 and Java person want to build some Row Level Security to reports.

Are there any examples of using Business Views with Crystal Reports?

Thanks,

Rick