I recently came across this error while trying to consume a BEx Query into Crystal Reports for Enterprise.
The BEx Query that I am using has a mandatory Interval Prompt Variable set for Fiscal Year/Period which prompts me to enter a selection before processing the query and running the report in crystal reports. Upon giving the appropriate intervals in the prompt, my CR for Enterprise throws the following error message:
Failed to execute query: 'com.sap.sl.parameter.impl.IntervalAnswerImpl cannot be cast to com.sap.sl.parameter.SingleValueAnswer'. Redesign your query or contact the data source maintainer to solve the problem
I have been looking at various related issues but have come up with nothing so far and I would need some help to sort this out as this issue is really causing a delay in for my deliverable.
Thanks in Advance