Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Repeated values in drop down type parameter

  1. #1

    Question Repeated values in drop down type parameter

    Hello,
    I have a report that is grouped by 2 fields. Those fields are the report parameters too.
    When I load the report for preview, in the drop down boxes a lot of values are repeated.
    How can I make a value appear once?
    Thanks

  2. #2
    Join Date
    May 2016
    Posts
    280

    Default

    You can add a DISTINCT in the SELECT query you are using to get the list of values you are using in the Drop down boxes.
    Regards

  3. #3

    Exclamation

    Quote Originally Posted by Ana GH View Post
    You can add a DISTINCT in the SELECT query you are using to get the list of values you are using in the Drop down boxes.
    Regards
    I'm sorry, but I can't. It is a openerp based report, I don't use any select sentence

  4. #4

    Default

    For example,

    Table A (Agents)

    ID | Name
    1 | Paul
    2 | Katy
    3 | John

    Table C (Clients)

    ID | Name | Agent ID
    1 | Orginals LTD | 1
    2 | Awesome LTD | 2
    3 | Imports LTD | 2
    4 | Example LTD | 2
    5 | Imagine LTD | 1
    6 | ALL Customs LTD | 3
    7 | Prop Co. | 3
    8 | Industries TT . Co | 3

    In a Report of Clients per agent, PRD I suppose that internally makes a join between tables, and produces something like this:

    ID | Name | Agent
    1 | Orginals LTD | Paul
    2 | Awesome LTD | Katy
    3 | Imports LTD | Katy
    4 | Example LTD | Katy
    5 | Imagine LTD | Paul
    6 | ALL Customs LTD | John
    7 | Prop Co. | John
    8 | Industries TT . Co | John

    So, I make a group by Agent, but If I make a drop down type parameter, for filtering by agent, the result is:

    Paul
    Katy
    Katy
    Katy
    Paul
    John
    John
    John

    But that I need, is:

    Paul
    Katy
    John
    All of them <-- (It isn't very important, only if it is possible)


    PD: Sorry for my english, but this is not my primary language

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.