Skip to Content
0
Former Member
Jul 16, 2008 at 02:29 PM

Logon parameter and dynamic parameters

45 Views

Using Crystal Reports XI, and publishing in Crystal Server.

I need to do the following:

1. How do I pass a user logon information to a procedure on SQL server to retrieve records without prompting user for login information since I can use the special field "Current CE User Name" to retrieve records? The reason I am asking is that I know that when a procedure has an input parameter, Crystal automatically creates a parameter for it and displays it. How can I avoid Crystal requesting this parameter although I need to pass it?

2. After retrieving records, I will need to create 3 dynamic parameters for the user be able to filter down some more.

Thanks in advance for your help,