Jump to content

  • SQL query creating duplicates when using group by

    edmurray

    By edmurray

     Share
    Assigned User chicuslavic
    CategoryBug report
    PriorityHigh
    ReproducibilityAlways
    ResolutionUnable to Reproduce
    SeverityMajor
    StatusClosed
    Versionv6.2

    When using the following SQL syntax with a GROUP BY statement the Studio's Dataset and Query Dialog returns a value for each itemvalue instead of aggregating them into one group.

    When using this same command directly against the Postgresql server using psql the results are returned as expected.

     

    select itemtype , sum(itemvalue) from expense group by itemtype;

     

    Postgresql 9.4

     

     Share
    Go to bugs

    User Feedback

    Recommended Comments

    Massimo Rabbi

    Changed Status from New to Feedback Requested

    Hi,the last version of iReport is based on JasperReports 5.6.0. So it's an older version compared to the JSS 6.2.0 you mentioned.It could be also something related to JR. Could you please attach a sample report showing the problem? If it is related to the sample postgres db in JRS even better (foodmart / sugarcrm).Thanks.Regards,Massimo.
    Link to comment
    Share on other sites
    Massimo Rabbi

    I quickly tested with a 6.2.0 inside a Windows 7 VM. It worked fine for me. As you can see from the attached screenshot the results appears coherent.

    I used the foodmart sample db from JRS.

     

    Maybe your problem is indirectly related to this one: http://community.jaspersoft.com/jaspersoft-studio/issues/6801

    But you didn't mentioned errors, therefore it should not be the case. So please proceed in attaching the JRXML.

     

    Regards,

    Massimo.

    Link to comment
    Share on other sites

×
×
  • Create New...

© 2023 Cloud Software Group,
Inc. All rights reserved

Products

Explore