Solved

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

Posted on 2009-05-19
7
729 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

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

Suggested Solutions

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

752 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