Crystal Reports XI Error: Database Vendor Code:942
I have a defined set of Dynamic Prompts in Business View Manager named "PortfolioOverview" When I check everything there I get no errors, I can see data etc... When I try to run my Crystal Report using this prompt I get the error: [Cause of error:Error in File PortfolioOverview: Failed to retrieve data from the database. [Database Vendor Code: 942]]
Yet in Business View manager it works just fine...Could it be corrupt? I am stumped. Any guidance?
Graham Cunningham replied
Is the data connection that the prompt group is based on set to never prompt?
Can you create a Crystal Report off of the BV using the same fields that the LOV is based on?
Can you connect to the database directly, bypassing the BV, and report off of those table and fields?