Crystal report viewer database login prompt

Now publish the report to Business Objects Enterprise by going to the File>Save As> and selecting Enterprise folder (see below).Select any other options in the Options section on the bottom of the screen and then click OK to save the new Dynamic Prompt.Click on the Value field and select the database field you want as your values for the prompt.Select Dynamic from the List of Values drop-down menu in the upper right-hand corner.Select the data type for the prompt (number in this example).

Type in the name for your Prompt field (Supervisor ID in this example).

Right-click on Parameter Fields in the Field Explorer and select New.

You cannot schedule the prompt to be refreshed at regular intervals within Crystal Reports to speed up report processing time.Д¬reating a Dynamic Prompt in Crystal Reports:.

You do not have a clear view or inventory of all dynamic prompts created in the system.

If you publish the Crystal report to the Business Objects Enterprise, the dynamic prompt automatically gets created in Business View Manager, so you could potentially be overwriting a dynamic prompt already created with the same name in the system.

The first method, creating the Dynamic Prompt in the Crystal Reports application (detailed below) has these disadvantages:

In the Business View Manager application (if you have purchased Business Objects Enterprise).There are 2 ways you can create Dynamic Prompts in Crystal Reports XIR2: How can I better manage my Crystal Reports Dynamic Prompts?

Crystal report viewer database login prompt