Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: PRD. Combine groups and crosstabs

  1. #1
    Join Date
    Feb 2017
    Posts
    7

    Default PRD. Combine groups and crosstabs

    Hello everybody! Sorry for bad English.
    Can anyone help me with report in Pentaho Report Designer?
    In my report I use SQL query that returns the following fields:
    section_id, section_number, row_id, row_number, column_id, column_number, value.
    I use group by section_id in PentahoReportDesigner to separate results to different tabs.
    Inside group I use crosstab to make dynamic number of columns for each tab. In crosstab I put row_number in rowAxis , and column_number in columnAxis.
    In generated report I get the same set of columns in each tab (wherein all possible columns).
    How can I make the report with only its set of columns in each tab?
    Thanks for any help!

  2. #2
    Join Date
    Feb 2017
    Posts
    7

    Default

    I also tried to hide columns with empty/zero cells, but it didn't give any result (I guess it hides by rows)

  3. #3
    Join Date
    Feb 2017
    Posts
    7

    Default

    I've hidden columns, but there are empty spaces. Found an advice to use block layout here http://stackoverflow.com/questions/2...th-empty-field
    Tried to use block or row layout, but I don't understand if it should work for crosstab columns or not. Does someone have any ideas?
    Last edited by enthusasist; 03-01-2017 at 05:06 AM.

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.