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,