View Full Version : PRD sub-report with CASE in WHERE clause

06-15-2010, 01:33 PM

I am trying to create a report with a subreport where parameters are passed from parent report to subreport and the sub-report query (whcih is w/in parent definitions) is not working... I get the following errors:

Exception: Unable to initialize the report ....
ParentException: java.sql.SQLException: Invalid column index

The sub-report's query works fine in Oracle BUT aborts in Report Desinger (3.5 TRUCK-SNAPSHOT version / post GA version) with above noted error.

A short mockup of the query is attached. I can provide entire actual query, if it would help further.

I suspect PRD does not like the CASE stmt in the WHERE clause.

Anyone ideas how to make it work???