Crystal Reports 2013 not showing list of values

[Former Member]

I'm building a report in Crystal Reports 2013 Support Pack 8 Version 14.1.8.2016 with a dynamic parameter that uses a list of values from Business View Manager. I've built the Data Connection, Data Foundation, Business Element, Business View, and List of Values in the BVM using an Admin logon. When I "Browse field...." on my Business Element, I get the proper list of data, so I know that's working.

In Crystal Reports I logged into the Repository Explorer and selected my List of Values from the repository data source as the data source for my report's dynamic parameter. When I refresh the data in my report, my parameter prompt is just a text field and not the list of values that I'm expecting. I can even enter a parameter value that I know exists and the report runs correctly. but I need a list of values. I've read through several previous questions in the SAP community with this problem, but those were all for CR 2008, and those solutions didn't fix my problem. Why do I not get a list of values for my parameter?

[DellSC]

I'm going to assume that you're using "classic" Crystal and not Crystal for Enterprise. Does this happen when you refresh the report in Crystal or when you refresh in BI Launchpad?

Has security been configured so that you can run the LOV? This has to be done in the Business View Manager (BVM). I generally do this by giving the Everyone group "View" access on the "Cascading Dynamic Prompts" folder. That covers everything except the Data Connection, where you have to specifically edit the rights and grant the "Data Access" right.

Look at the Data Connection in the BVM. Make sure that you have set the User ID and Password properties and set the Runtime Prompt Mode to "Never Prompt". Then save the Data Connection.

Now go to the LOV, right click on it and select "Schedule List of Values". After scheduling to "Run Now", right-click on the LOV and select "Edit List of Values". Wait about 30 seconds and click on the "Refresh Status" button. If the "Schedule Status" box at the bottom right still shows that the LOV hasn't run, wait another 30 seconds and click on "Refresh Status" again. An error will appear in the box if there was an error in the schedule. If it doesn't ever run, you'll need to check a couple of things under "Servers" in the CMC:

- Make sure that you have at least one CrystalReports20XXReportApplicationServer running. This is where the LOVs run.

- Make sure that users have "View" access to the CrystalReports20XXReportApplicationServer. I usually set this for the Everyone group on the Top Level for servers instead of just setting for individual servers. I believe that, by default, users don't have this access.

-Dell

[Former Member]

Dell

Thanks for your quick and thorough answer, it was very helpful. I went through everything you mentioned above and I'm still having the same problems. When I schedule "Now" the LOV and then click "Refresh Status" I get an error with this in the error message:

Error Message: Failed to open the connection.
~tmp1bd89f4b97738d0.rpt
Details: Logon to underlying database failed

I checked everything you mentioned pertaining to the CMC, and that all checked out okay. Do you have any additional thoughts about what could be causing the error when I do a "Refresh Status" ?

Chad

[DellSC]

This means that the database credentials in your Data Connection are not correct. I would re-enter them and try scheduling the LOV again.

-Dell

[Former Member]

My credentials must be correct in my Data Connection because I can open up the appropriate Business Element, right click on the field name in the Object Explorer to "Browse Field...." and get the list of values I'm looking for.

Chad

[DellSC]

Then something is not configured correctly because the LOV is not able to connect to the database. Would you post a screen shot of the configuration for your Data Connection, please?

-Dell

[Former Member]

Runtime Prompt mode = Never Prompt, Use Owner = true, Use Catalog = true, Use single sign on = false

[DellSC]

I don't see anything that stands out as an issue. Is this using the same connection type as your report (ADO)? If not, has the correct driver been installed on the BusinessObjects server?

-Dell

[Former Member]

Eureka! The connection type in my report was different than in BVM, so I changed my BVM one to match the report and now I have a list of values. Thank you very much Dell, you've been extremely helpful!

Chad

[DellSC]

Woohoo! I'm glad it's working now!

-Dell