Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Reporting Wizard : Not able to display data horizontally

  1. #1
    Join Date
    May 2008
    Posts
    2

    Default Reporting Wizard : Not able to display data horizontally

    Hi,

    Has any one in this forum tried to diplay data horizontally, providing your table and data structure is as given below.

    I have a set of data coming from Database like what is given below. This is the Table structure that is there in DB.

    Date : Program : NewCount : OldCount
    05/21/2008 : Solaris : 40 : 55
    05/20/2008 : Solaris : 23 : 47
    05/19/2008 : Solaris : 48 : 45
    05/21/2008 : JDK : 40 : 55
    05/20/2008 : JDK : 23 : 47
    05/19/2008 : JDK : 48 : 45
    05/21/2008 : NetBeans : 40 : 55
    05/20/2008 : NetBeans : 23 : 47
    05/19/2008 : NetBeans : 48 : 45
    05/21/2008 : GlassFish: 40 : 55
    05/20/2008 : GlassFish: 23 : 47
    05/19/2008 : GlassFish: 48 : 45

    I need to display this data in pentaho reporting each program horzontally like given below.
    Date :::::::::::::::: Solaris ::::::::::::::::::::::::::JDK :::::::::::::::::::::::::: NetBeans ::::::::::::::::::::: GlassFish
    ::::::::::: NewCount : OldCount ::: NewCount : OldCount ::: NewCount : OldCount ::: NewCount : OldCount

    Right now I am able to display the data verticallly for each program ID. LIke given below.

    Solaris
    Date : NewCount : OldCount
    1/2/00 : 21 : 22
    .....................
    JDK
    Date : NewCount : OldCount
    1/2/00 : 21 : 22
    .....................
    NetBeans
    Date : NewCount : OldCount
    1/2/00 : 21 : 22
    .....................

    Please let me know if it is possible to display horizontally.


    Thanks and Regards
    Meiyaps


    Hi,

    I have a set of data coming from Database like what is given below. This is the Table structure that is there in DB.

    Date : Program : NewCount : OldCount
    05/21/2008 : Solaris : 40 : 55
    05/20/2008 : Solaris : 23 : 47
    05/19/2008 : Solaris : 48 : 45
    05/21/2008 : JDK : 40 : 55
    05/20/2008 : JDK : 23 : 47
    05/19/2008 : JDK : 48 : 45
    05/21/2008 : NetBeans : 40 : 55
    05/20/2008 : NetBeans : 23 : 47
    05/19/2008 : NetBeans : 48 : 45
    05/21/2008 : GlassFish: 40 : 55
    05/20/2008 : GlassFish: 23 : 47
    05/19/2008 : GlassFish: 48 : 45

    I need to display this data in pentaho reporting each program horzontally like given below.
    Date :::::::::::::::: Solaris ::::::::::::::::::::::::::JDK :::::::::::::::::::::::::: NetBeans ::::::::::::::::::::: GlassFish
    ::::::::::: NewCount : OldCount ::: NewCount : OldCount ::: NewCount : OldCount ::: NewCount : OldCount

    Right now I am able to display the data verticallly for each program ID. LIke given below.

    Solaris
    Date : NewCount : OldCount
    JDK
    Date : NewCount : OldCount
    NetBeans
    Date : NewCount : OldCount


    Please let me know if it is possible to display horizontally.
    Last edited by meiyappan; 06-09-2008 at 05:25 PM.

  2. #2
    Join Date
    May 2008
    Posts
    2

    Default Display Format of Data

    Hi,

    Has any one in this forum tried to diplay data horizontally, providing your table and data structure is as given below.

    I have a set of data coming from Database like what is given below. This is the Table structure that is there in DB.

    Date : Program : NewCount : OldCount
    05/21/2008 : Solaris : 40 : 55
    05/20/2008 : Solaris : 23 : 47
    05/19/2008 : Solaris : 48 : 45
    05/21/2008 : JDK : 40 : 55
    05/20/2008 : JDK : 23 : 47
    05/19/2008 : JDK : 48 : 45
    05/21/2008 : NetBeans : 40 : 55
    05/20/2008 : NetBeans : 23 : 47
    05/19/2008 : NetBeans : 48 : 45
    05/21/2008 : GlassFish: 40 : 55
    05/20/2008 : GlassFish: 23 : 47
    05/19/2008 : GlassFish: 48 : 45

    I need to display this data in pentaho reporting each program horzontally like given below.
    Date :::::::::::::::: Solaris ::::::::::::::::::::::::::JDK :::::::::::::::::::::::::: NetBeans ::::::::::::::::::::: GlassFish
    ::::::::::: NewCount : OldCount ::: NewCount : OldCount ::: NewCount : OldCount ::: NewCount : OldCount

    Right now I am able to display the data verticallly for each program ID. LIke given below.

    Solaris
    Date : NewCount : OldCount
    1/2/00 : 21 : 22
    .....................
    JDK
    Date : NewCount : OldCount
    1/2/00 : 21 : 22
    .....................
    NetBeans
    Date : NewCount : OldCount
    1/2/00 : 21 : 22
    .....................

    Please let me know if it is possible to display horizontally.


    Thanks and Regards
    Meiyaps

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.