Solved

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

Posted on 2009-05-19
7
727 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 500 total points
ID: 24425660
In order to get LOV without prompt you need to specify both user and password.
0
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

 
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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
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…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

856 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