This is also true after saving the report to the SAP BusinessObjects BI Platform and viewing the report in InfoView or SAP BI Launchpad.įor performance reasons, the maximum number of values that are returned for a List of Values (LOV) in Crystal Reports is set to 1,000. When refreshing the report, notice it only display a maximum of 1,000 values. In Crystal Reports, create a report off any data source.Ĭreate a dynamic LOV parameter containing over 1,000 values. SAP BusinessObjects Business Intelligence Platform 4.2 SAP BusinessObjects Business Intelligence Platform 4.1 SAP BusinessObjects Business Intelligence Platform 4.0 How to modify the maximum number of values available in a dynamic parameter in Crystal Reports? List of Values (LOV) is not showing everything.ĭynamic Parameter does not display all the values in the List of Values (LOV). Hope this helps someone.ĭynamic prompt not populated with all values. The solution can be found in SAP KnowledgeBase article 1218588. I was able to find the solution to this and wanted to post it in case anyone else runs into the same issue. Does anyone have any ideas on what I could try to do next fix this issue? I’ve tried creating a new List of Values off the Business View but it still hides some of the values from query. I know that the Business Element is getting the correct data because if I create a brand new report and use that Business Element as the source it shows the same data as the SQL query. The issue I’m having is when I run the SQL query I get a certain set of data but when I run the List of Value as a prompt in a report the data is different, there are values missing. The view is then sourced for a Business Element which then connects to a shared Business View and finally a List of Values is created. The view contains two columns, a key field and a description field. The prompt is built off of a SQL view that is imported into the Data Foundation. Since the migration I’ve seen some odd behavior with one of my dynamic prompts. I’ve recently upgrade from 4.2 SP3 to 4.2 SP7.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |