Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Crosstab in pentaho report designer 3.8.3

  1. #1

    Post Crosstab in pentaho report designer 3.8.3

    Hi All,
    i have used crosstab in report designer but when i generate to report
    the data not display all
    especially on crosstab column
    plz, I need your help right now
    any idea ?

    this is my query :

    SELECT DISTINCT
    "cstm"."name" AS "customer_customer_name",
    "pdc"."name" AS "product_product_name",
    SUM("wb"."liters_at_ambient") AS "waybill_liters_at_ambient",
    "dpt"."name" AS "depot_depot_name",
    "wb"."waybill_date" AS "waybill_waybill_date"
    FROM
    "waybills" AS "wb"
    JOIN "customers" AS "cstm" ON "wb"."customer_id" = "cstm"."id"
    JOIN "products" AS "pdc" ON "wb"."product_id" = "pdc"."id"
    JOIN "depots" AS "dpt" ON "wb"."depot_id" = "dpt"."id"
    GROUP BY
    "cstm"."name",
    "pdc"."name",
    "dpt"."name",
    "wb"."waybill_date"
    ORDER BY
    "cstm"."name",
    "pdc"."name",
    "dpt"."name",
    "wb"."waybill_date"


    The best regards.
    Attached Files Attached Files

  2. #2

    Default

    Quote Originally Posted by wildanSawaludin View Post
    Hi All,
    i have used crosstab in report designer but when i generate to report
    the data not display all
    especially on crosstab column
    plz, I need your help right now
    any idea ?

    this is my query :

    SELECT DISTINCT
    "cstm"."name" AS "customer_customer_name",
    "pdc"."name" AS "product_product_name",
    SUM("wb"."liters_at_ambient") AS "waybill_liters_at_ambient",
    "dpt"."name" AS "depot_depot_name",
    "wb"."waybill_date" AS "waybill_waybill_date"
    FROM
    "waybills" AS "wb"
    JOIN "customers" AS "cstm" ON "wb"."customer_id" = "cstm"."id"
    JOIN "products" AS "pdc" ON "wb"."product_id" = "pdc"."id"
    JOIN "depots" AS "dpt" ON "wb"."depot_id" = "dpt"."id"
    GROUP BY
    "cstm"."name",
    "pdc"."name",
    "dpt"."name",
    "wb"."waybill_date"
    ORDER BY
    "cstm"."name",
    "pdc"."name",
    "dpt"."name",
    "wb"."waybill_date"


    The best regards.
    i am still wating for you all.
    thanks for the quick response...

  3. #3
    Join Date
    Apr 2010
    Posts
    24

    Default

    I cannot run the report as it is using your own DB. Can you please show the data of your SQL ?

  4. #4

    Default

    Quote Originally Posted by hellovineet View Post
    I cannot run the report as it is using your own DB. Can you please show the data of your SQL ?
    Hi hellovineet

    this is the displaying of my own DB
    please see the capture

    Name:  Screenshot from 2012-12-26 13:36:36.jpg
Views: 55
Size:  30.8 KB

    my crosstab report still error
    could you help me ?

    regards.

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.