Dropdown is not coming in Crystal Report

[Former Member]

Dear All,

I have created Crystal Report using dynamic Parameter.

In development server I am getting drop down in input parameter (ref. ProperParaValue.png).

But now when I published it into Production server then in input parameter instead of getting drop down i am only getting blank textbox (ref DropdownMissing.png).

Kindly help me to solve this issue as early as possible.

Thanks,

ARPITA

[former_member205840]

Hi Arpita,

It is because, you / the user don't have privileges on Business View Manager on Production Server.

Check with your BO admin, he need to provide sufficient rights for you on BVM.

Thanks,

Sastry

[Former Member]

Thanks for your immediate reply.

Can you please let us know the steps how to check rights on BVM.

Thanks,

ARPITA

[DellSC]

- Log in to the BVM with an Administrator account.

- Cancel out of the default landing screen if it appears.

- If the Repository Explorer is not visible, go to the View menu and turn it on.

- Right-click on the "Dynamic Cascading Prompts" folder and select "Edit Rights".  Make sure that the Everyone group has View access.

The other thing you need to do verify the Data Connection for the prompt for this report. 

- If the prompt was originally created in the report and not in the BVM, get the name of the Prompt Group from the parameter definition in the report.

- In the BVM, find the Data Foundation that has the same name as the Prompt Group.  This should have a "_DF" suffix on the name.

- Open the Data Foundation to determine which connection it's using.  Right-click on "Tables" on the left and select "Set Table Location".  A screen will appear that shows you the name of the Data Connection , which should have a suffix of "_DC".

- Open the Data Connection by double-clicking on it.  In the column on the left, there will be a bunch of information about the connection, including the credentials for the database. Do the following:

     1.  Make sure that it's connecting to the correct database for the environment.  If it's not, you may have to create a new one that does.  When you do, the steps below also apply.

     2.  Make sure that the User Name and Password information are correct for the connection,

     3.  Set the "Runtime Prompt Mode" to "Never Prompt".

- Save the connection.

- If you had to create a new connection, edit the Data Foundation and use "Set Table Location" to change it to use the new connection.  Then save the Data Foundation.

-Dell