Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2009-05-19
7
Medium Priority
?
732 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 2000 total points
ID: 24425660
In order to get LOV without prompt you need to specify both user and password.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Independent Software Vendors: 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!

Question has a verified solution.

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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Suggested Courses

721 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