Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Data Sets columns and fields missing

  1. #1
    Join Date
    Aug 2016
    Posts
    1

    Question Data Sets columns and fields missing

    I am trying to create a report. I have connected my database and tables using mysql successfully. I created the jdbc query. When I try to create a report under the query I notice there aren't any columns/fields showing up! How do I fix this?

  2. #2
    Join Date
    May 2016
    Posts
    280

    Default

    It usually happens to me when Pentaho can't render the query. Does the Preview button in the Datasource editor returns any rows? If it returns an error, try to run the query in the sql editor of your choice and correct the errors, you can do it directly in the Report Designer, but the error messages are less specific, so when I have an error I usually debug my queries in a proper SQL tool.
    Regards
    Ana GH

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.