Skip to Content
Former Member
Aug 03, 2015 at 07:57 AM

BO 4.1 -> Crystal Report for Enterprise The search does not work with the prompt created based on Universe parameter



I have created a crystal report based on a universe (unx) using Crystal Enterprise. The BO platform is on 4.1. The prompt created in a Query Filter panel is based on the Universe Parameter. When I refresh the query using the 'Refresh' button on the Query Panel, the Search functionality of the prompt (an example would be searching for E100 which is an Employee ID) works perfectly fine. But when I run the report, the prompt's search functionality does not work. It gives me a message "Maximum number of records exceeded" and unable to find the Employee number I am searching for.

Steps to create:

  1. Create a query bases on UNX universe
  2. Create a prompt in the Query Panel
  3. While defining the prompt, select 'Universe Parameter' option
  4. Run the report
  5. Search for a value that exists using Search button
  6. Message - "Maximum number of records exceeded"

Is this a limitation? Or is there any configuration/additional setting that needs to be done?