BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

LOV for cascading dynamic prompts not populating


 
Search this topic... | Search Crystal Reports... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Crystal Reports  Previous TopicPrint TopicNext Topic
Author Message
capper
Forum Member
Forum Member



Joined: 19 Mar 2018

Posts: 2



PostPosted: Fri Sep 28, 2018 2:34 pm 
Post subject: LOV for cascading dynamic prompts not populating

We have two different servers, one for test and one for prod. I am using Crystal Reports 2016. I created a report (on the test server) w/cascading dynamic prompts and let the report create the BV/BE/DF/DC. When I run the report on the test server, the report works fine...I get a dropdown that is populated for my dynamic cascading prompts.

However, when I promote this report to the production server using Promotion Management in BO CMC, I do not get a dropdown for the dynamic cascading prompts when the report is run.

I've tried scheduling the LOV, verifying the database, as previous posts have suggested.

Any other suggestions would be greatly appreciated.

Thanks!
Back to top
kevlray
Forum Associate
Forum Associate



Joined: 23 Jun 2010

Posts: 907
Location: California


flag
PostPosted: Mon Oct 01, 2018 9:38 am 
Post subject: Re: LOV for cascading dynamic prompts not populating

I know that the dynamic prompt gets saved on the server (not sure where). But I wondered when the report got promoted that the dynamic prompt did not come over with the report. Not sure how to fix other that re-create the dynamic prompt.
Back to top
hilfy
Forum Enthusiast
Forum Enthusiast



Joined: 16 Apr 2007
ASUG Icon
speaker.gif*3
Posts: 1855
Location: Atlanta, GA


flag
PostPosted: Mon Oct 08, 2018 9:39 am 
Post subject: Re: LOV for cascading dynamic prompts not populating

When you promote the report, you need to include the "repository objects" in the dependencies in order to get the LOV to come over with the report.

There are a number of things that might cause this issue.

- Did you set the database logon credentials in the Data Connection to the appropriate values for your prod environment.

- Have you checked security on the objects (in the Business View Manager (BVM))? Anyone using the report needs to have View access to the DC, DF, BE, BV, LOV, and prompt.

For future reference, having the report created the objects in the BVM is NOT a best practice. You will end up with many objects that contain the same information and the data foundations created this way have the whole query for the report instead of just what they need to lookup the prompt values. It's more difficult to manage prompts when you do this.

Best practice is to create a single DC per database, a single DF, BE, and BV for a "topic", a single LOV for each field or "cascade" of fields, and two prompts - one for a single select and one for multi-select, although you might have more if you need both mandatory and optional prompts.

-Dell

_________________
Protiviti
Data & Analytics Practice
https://www.protiviti.com/US-en/data-management-advanced-analytics
Back to top
capper
Forum Member
Forum Member



Joined: 19 Mar 2018

Posts: 2



PostPosted: Tue Oct 09, 2018 6:23 am 
Post subject: Re: LOV for cascading dynamic prompts not populating

I've done everything you've listed. However, I did not schedule the LOV, and I think that was my problem. I can now see the LOV.
Thanks so much for your reply...
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Crystal Reports  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0301 seconds using 17 queries. (SQL 0.0025 Parse 0.0009 Other 0.0267)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo