There are a couple of things you need to do to get dynamic prompts working in BOE.
1. At least once you need to publish the report through Crystal instead of the Publishing Wizard. Make sure you check the "Update Repository" checkbox. This will set up a "list of values" in the repository that will be used to provide the data for the prompt.
2. Run the "Business View Manager". If this is not in the Business Objects Enterprise section of your menu, it is located here: <drive>:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86\CrystalBVM.exe.
There are several "parts" to a Business View. By default they are named by the field name(s) they refer to. Find the sets that match your prompts and do the following:
1. If you don't want the report to prompt for a database login for every prompt, edit the Data Connection (name ends in "_DC") and set the log in - the easiest way is by clicking in the password box and then on the button that appears in the box. Set the User ID, Password, and set it to Never require login. Save the Data Connection
2. Right-click on the name that does NOT have an "_xx" suffix (this is a "List of Values") and select "Schedule". Schedule to run "Now".
3. Depending on how long it takes for your query to run, wait anywhere from a few seconds to a few minutes. Double-click on the List of Values and verify that it ran successfully. If it doesn't, you may need to tweak your login parameters. If it does, you'll want to set up a recurring schedule (right-click and select "Schedule") based on how often you expect the data to change. The List of Values server in your BOE installation takes care of running these.
Some best practices that I've found in working with lists of values:
1. These prompts are reusable in other reports. To reuse an existing prompt, log in to the repository in Crystal. Then edit your prompt and set it to "Use Existing" and select the correct "Prompt Group" from the list.
2. If you're going to reuse prompts, it's a good idea to create a special report to set up the prompt. This report contains just the table(s) and fields needed to get the data for the prompt instead of the all of the tables to get the data for a larger report. This will be more efficient to run the List of Values on a schedule. We publish these reports to a special "Prompt Reports" folder that only the developers and Administrator have access to.
3. If you reuse prompts, do NOT select "Update Repository" if you're publishing through Crystal. This prevents duplicate prompts from being created.
4. If you need to update the query for a List of Values, do it in the Business View Manager - this is stored in the items with the "_DF" suffix (Data Foundation).
-Dell
A computer only does what you actually told it to do - not what you thought you told it to do.
