Business View Manager Formula

[Former Member]

Hi Everyone,

I have created a Business View using Business View Manager. I need to create a formula in the Data Foundation of Business View which will be like:

"ConID where Username = CurrentUserName" i.e. I need ConID for the user who loged in.

As we don't have where clause there (in Crystal Syntax), can anyone tell how to achieve this.

Regards,

Neeraj Sharma

[julio_serrano1]

Hi, Do a filter at level of universe with the condition filter is where username = CurrentUserName, you can use at report level and the view Manager.

Option 2.- Creae a parameter in Crystal Report Designer. with the same condition, you can do prompts with this.

Julio

[Former Member]

Hi,

Instead of formula u can create a filter and enter the databse feild in filter and click on it , it will list a drop down from that select equals to and write down CurrentUserName. save it and scehdule it and check it in report ur filter will be applied.