Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: PRD sub-report with CASE in WHERE clause

  1. #1
    Join Date
    Sep 2009

    Post PRD sub-report with CASE in WHERE clause


    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???

    Attached Files Attached Files
    Last edited by LBhate; 06-15-2010 at 01:44 PM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.