CE and Info Views with Row security

[aevans]

Does anyone know of any work around for using/ converting Info Views, which have row security, in CE or implementing a similar feature?

Preferably I need this to view successful scheduled instances of reports and not and on-demand reports as they are large reports and take too long for users to wait.

I am aware of the technical Brief (ce8_crystal_qry_dct_and_civ.pdf) describing "the functionality and requirements for publishing Crystal Reports that use Query, Dictionary or Info View files as a data source in the Crystal Enterprise environment."

But this article states that “Crystal Enterprise 8 does not include Row or Column security via Info Views; however, Info Views created in a Seagate Info environment can be converted for use in Crystal Enterprise 8.“

To me was a good feature of the previous versions of Info.

Any ideas? Has anyone heard of this issue being addressed in future releases? Or even the way CE will address metadata in future versions?

Alexander

 

[AEldridge]

The way to achieve this is to, in your CSP, dynamically add a selection formula to the report URL, based on the user ID or group of the viewing user.

You would need to define some access rules (like the rules in the Info View) - perhaps setting up a small permissions DBMS would be a good way to do this. You then add this rule to the URL as a selection formula:

http://myserver/myreport.rpt?SF="your

rule here"

Several solution providers (including the Crystal Decisions professional services group) have written solution in this space... based around ISAPI plug-ins to make the solution more secure (ie. it does not expose the final URL to the end user).

Hope this helps.

Cheers, Alan Eldridge
Melbourne, Australia

 

[aevans]

I kind of get what you are saying but wouldn't your solution just work for on demand reports and not a successful instance? I might just not understand the sf though.

Ideally I have 100+ clients and rather than writing 100 different reports and scheduling 100 reports I wrote 1 report and it filters out based on the client who logs in and the Info View security.

Then any of the previous years worth of run instances are filtered for just that client when it is opened.

You've definitely given me a starting place.

Thanks

Alexander

 

[AEldridge]

The SF also works when viewing a pre-scheduled instance.

Cheers, Alan Eldridge
Melbourne, Australia

 

[aevans]

Fantastic! thanks for the help.

 

[Infobiggot]

additionally Crystal's services group has a solution for this that is supposed to be forward compatible with future inbox solutions