Skip to Content
Former Member
Aug 13, 2009 at 03:22 PM

"Current CE User Name" in cascading prompt


Hi All,

I'm trying to set the security in a Crystal report.

Here are the rules I would like to implement :

1-Users should be able to see only the data of the countries they are allowed to.

2-Once the country is selected, users should be able to select the city they want to see in the report

In the database, I have a view that makes the relationship between the users and the countries they are allowed to see.

Thus I created the following cascading prompt User>Country>City.

Then in Business View Manager, I added the filter User = "Current CE User Name"

This works fine 😊 but when a user connects to Infoview, he (logically) has to select his user account as first value of the cascading prompts in order to select the country and then the city.

My question is : Is there a way to set the default value of the 1st prompt (User) to "Current CE User Name" so the user doesn't have to select his own user account? Or maybe is there an other way to implement this?

Any support or advice would be appreciated.