Jump to content
  • use crosstab with DataPresorter=true


    blosser
    Assigned User User_306070
    CategoryBug report
    PriorityHigh
    ReproducibilityN/A
    ResolutionDuplicate
    SeverityMajor
    StatusClosed
    Versionv3.6.2

    Hi, friends.

    I want to reopen issue, because we forced stay in old JR (3.6.0) version.

    In my opinion, problem is not in ordering (table contain one row and columns have value 1,2,3,4 accordingly).

    Problem appears when column header have same (repeated) value.

     

     

    History:

     

    The following issue requires your FEEDBACK.

    ======================================================================

    http://jasperforge.org/plugins/mantis/view.php?id=5281

    ======================================================================

    Reported By: blosser

    Assigned To: lucianc

    ======================================================================

    Project: JasperReports Library

    Issue ID: 5281

    Category: Bugs

    Reproducibility: always

    Severity: major

    Priority: high

    Status: feedback

    Add CC to mail:

    ======================================================================

    Date Submitted: 06/22/2011 16:35

    Last Modified: 11/16/2011 16:06

    ======================================================================

    Summary: crosstab different behaviour 3.6.1 vs 3.6.2 and more

    Description:

    use crosstab with DataPresorter=true.

     

    I think, that crosstab header can has same value in different colums. JR

    3.6.1 works fine (in my opinion), but 3.6.2 was change calculation crosstab

    header.

     

    datasoure:

     

    select '' gr, 'a' attr1, 'c1' h1, 'h1' h2, '1' val from dual union all

     

    select '' gr, 'a' attr1, 'c2' h1, 'h2' h2, '2' val from dual union all

     

    select '' gr, 'a' attr1, 'c1' h1, 'h1' h2, '3' val from dual union all

     

    select '' gr, 'a' attr1, 'c2' h1, 'h2' h2, '4' val from dual

     

    attach result 3.6.1 and 4.0.0 version

    ======================================================================

     

    ----------------------------------------------------------------------

    (0010563) lucianc (administrator) - 11/16/2011 16:06

    http://jasperforge.org/plugins/mantis/view.php?id=5281#c10563

    ----------------------------------------------------------------------

    isDataPreSorted="true" requires that the data is presorted by a specific

    order as explained at

    http://jasperforge.org/uploads/publish/jasperreportswebsite/trunk/schema.reference.html#crosstabDataset

     

    Are you sure your data is sorted accordingly? If that's not the case, the

    outcome is unspecified.

     

    Regards,

    Lucian

     

    Issue History

    Date Modified Username Field Change

    ======================================================================

    06/22/2011 16:35 blosser New Issue

    06/22/2011 16:35 blosser Assigned To => teodord

    06/22/2011 16:35 blosser File Added: s.jpg

    11/16/2011 16:06 lucianc Note Added: 0010563

    11/16/2011 16:06 lucianc Assigned To teodord => lucianc

    11/16/2011 16:06 lucianc Status new => feedback

    ======================================================================


    Attachments: report3.jrxml

    User Feedback

    Recommended Comments


×
×
  • Create New...