Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

List of Values not Showing up (Crystal 2008)-BOE XI 3.1

Posted on 2009-05-19
7
Medium Priority
?
733 Views
Last Modified: 2013-11-15
I am using Crystal 2008. I created a parameter 'X' and it uses a Prompt Group(PG_1) built in Business View Manager. And the Data Connection's(DC_1) property 'Runtime Prompt Mode' is set to 'Always Prompt'.

Now when I run my report runs in the Crystal Reports 2008, it never asks me for the database user credentials for DC_1. And it asks me for database credentials when I try to schedule the report by giving the parameter values from the INFOVIEW. After enting the database details, it gives me the List of values.

Now that I didn't want to be asked for the credentials everytime, I set the Data Connection's(DC_1) property 'Runtime Prompt Mode' is set to 'Never Prompt'. After I do this, whenever I run the report it doesn't ask me for the database details, which is good. But the issue is now after the property change it does not show the list of values in only in INFOVIEW when prompted. It only shows a text box against the prompt just to enter the value.

Is there any way to show the LOVs after the change in the property for 'Runtime Prompt Mode' to 'Never Prompt'?

Thanks in Advance.
0
Comment
Question by:nani11
  • 4
  • 3
7 Comments
 
LVL 2

Expert Comment

by:vetaldj
ID: 24425610
Did you specify user name and passwor in DC as well?
0
 
LVL 1

Author Comment

by:nani11
ID: 24425639
Now it has blankin the Username and Password Properties for Data Connection
0
 
LVL 2

Accepted Solution

by:
vetaldj earned 2000 total points
ID: 24425660
In order to get LOV without prompt you need to specify both user and password.
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 2

Expert Comment

by:vetaldj
ID: 24425684
Sorry, press enter before type all answer...

I had same issue before and in order to get LOV without prompt you need to enter user name and password to appropriate boxes in DC and specify Never Prompt, what you already did.
0
 
LVL 1

Author Comment

by:nani11
ID: 24425709
What is "press enter before type all answer..."? ..Could you please explain in detail?
0
 
LVL 2

Expert Comment

by:vetaldj
ID: 24425754
It not  related to your question... sorry for confusion...

first line "Sorry, press enter before type all answer..." it was excuse that my previous answer was not in full because I press "Submit" before I typed it.
0
 
LVL 1

Author Comment

by:nani11
ID: 24425922
Thanks a lot..That worked...Cheers..
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

927 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question