on 09-13-2012 8:28 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.