US and Worldwide: +1 (866) 660-7555
Results 1 to 3 of 3

Thread: CrossTab Report Problem - Show-Changes Attribute

  1. #1
    Join Date
    Jun 2012
    Posts
    5

    Default CrossTab Report Problem - Show-Changes Attribute

    Hi,

    I have a problem with a Crosstab report. I want to see only one Row in my Crosstab Details in my group but when
    I activate it, It doesn't works....... But in a simple Report It works....

    Can I do it in a Crosstab??

  2. #2
    Join Date
    Mar 2003
    Posts
    7,592

    Default

    The Show-Changes attribute uses the "item-hide" function. That function compares the current element with the previous element in the datasource.

    Crosstabs are filled from the left to the right, so this function is useless for you. If you want that function, you have to write a new report function or rewrite the existing item-hide function to be aware of the crosstab structure. Then you would have to compute change information keyed by the values of your column dimensions:

    Code:
    On item advanced: 
    (1) Change the function to record previous values using map with a key that consists of all values of all fields used as column dimension. 
    (2) Compare the current value of your field with the previously seen value of the field. If there are no previous values, assume the field has changed. If the value has changed, show your element, else hide the element. 
    (3) Record that value as remembered value, using the column dimension as key.
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

  3. #3
    Join Date
    Jun 2012
    Posts
    5

    Default

    Thanks a lot Taqua....
    It was a perfect explanation about the Crosstab ,
    ... I'm going to work on this and if I have a trouble I'll be back xD

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •