I can't exactly remember what it was called in Crystal but I know by design, Crystal only reads like 25000 records (I'm guessing, I don't remember the exact number) when reading LOVs for a dynamic prompt.
I remember there was a registry key that can change the default value of how many records it reads but I can't find the knowledgebase for the life of me anymore.
So two questions.
1. What was the location of the registry key?
2. Where are the knowledgebase residing now? 😊