Logon parameter and dynamic parameters

[Former Member]

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,

[former_member260594 · Accepted solution]

Rocio,

1) Crystal Reports can't pass database log on information directly to the database. The only way within CR to avoid being prompted for db logon information is to set up the DSN to use NT Authentication, this would then pass the Windows user to teh database.

Otherwise if you are using Enterprise you can provide the database username and password for the report within the CMC so that Enterprise users are not prompted for db logon.

2) Dynamic Parameters will process before data is retrieved from the database. It has to be this way in order for a List Of Values to be available to the user before the query is executed.

[Former Member]

Sorry, but what is CMC??

[Former Member]

The Central Management Console(CMC) is the main administration utility for Business Objects Business Intelligence platform. It runs in your web browser and provides access to all administration functions. With the CMC, you can deploy reports, configure security, tune servers and manage licensing.