Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Parameters not working when called from a jdbc source

  1. #1

    Default Parameters not working when called from a jdbc source

    I have a report with paramerters. I the parameters are called from a mysql jdbc table.

    Everything works great in report designer. However when i upload to the server, the report body is blank.

    if i use the table as a datasource instead of jdbc and upload it all works.

    any ideas? im using RD 3.5 and biserver 3.5 CE

  2. #2
    Join Date
    Apr 2008
    Posts
    4,690

    Default

    Perhaps:
    http://forums.pentaho.org/showthread...ght=Parameters
    or
    http://forums.pentaho.org/showthread...rameters+mysql

    If your JDBC drivers on the BIServer do not match what is used in PRD, you can get what you describe.

    There's lots of possibilities. Turn on logging, and review carefully.

  3. #3

    Default

    Thanks, i converted the type to "long" instead of int and it worked.

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.