Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: PRD 6.0.1, I only want to populate a cell ONCE in a report

  1. #1
    Join Date
    May 2017
    Posts
    20

    Default PRD 6.0.1, I only want to populate a cell ONCE in a report

    Within my SQL Query, my data pulls back this dataset (myGrandTotal = SUM(myCount) based on a specific week day:

    Name:  example1.jpg
Views: 48
Size:  9.4 KB

    Within my actual Report, I have a Pie Chart that pulls all the other relevant information from my dataset (myCount for the Chart and myCombo for the Legend.)
    My outstanding issue is I want 3 labels, and 2 fields to return only in my Details section:

    Name:  example2.jpg
Views: 50
Size:  9.1 KB

    I do NOT want this repeating over and over like this:

    Name:  example3.jpg
Views: 46
Size:  20.0 KB

    I just want to see the information once.

    Is there a way I can limit those cells to only populate once and not repeat for every line item in the dataset?

    Thank you in advance
    Iowabeef
    Attached Images Attached Images  
    Last edited by Iowabeef; 06-08-2017 at 11:06 AM.

  2. #2
    Join Date
    Aug 2016
    Posts
    142

    Default

    Put them in a report footer (or group footer if you only have one group)

  3. #3
    Join Date
    May 2017
    Posts
    20

    Default

    Bah!

    moved the cells\fields from 'Details' to 'Group Footer' and successfully returned a single value. ...the good news is the 3-4 hours I spent trying different variations, I was being paid... helps to offset the frustration.

    Thanks Deanicus!

  4. #4
    Join Date
    Aug 2016
    Posts
    142

    Default

    Quote Originally Posted by Iowabeef View Post
    Bah!

    moved the cells\fields from 'Details' to 'Group Footer' and successfully returned a single value. ...the good news is the 3-4 hours I spent trying different variations, I was being paid... helps to offset the frustration.

    Thanks Deanicus!

    You're welcome

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.