Stored Proc, Row Security, Parameters

[RS12]

Hi-
We are trying to achieve row level security which exists in our database, though through a somewhat unorthodox method.
I do not have experience with using stored procedures and had a question or two.

Basically what we need to do is pass several parameters back to the database, in sort of a drill down fashion, to bring back the correct data for each person.
So it will all start with userID > then bring back relevant departments > then groups.
It seems like upgrading to XI and using dynamic, cascading prompts will emulate this behavior with basic SQL select statements and parameters.

How does that same functionality work with stored procs and crystal? Does it collect the information in a step-wise fashion like regular SQL combined with dynamic/cascading prompts, or does it collect it all at once and pass it back to the db?

I’m also wondering if we need to upgrade to XI or can achievce this with CE10 and stored procs?

Thanks,
Rich

 

[synapsevampire]

For dynamic or cascading parameters, you need XI.

There are 3rd party viewers that emulate it, such as:

http://www.milletsoftware.com/DataLink_Viewer.htm

-k

-k