Jump to content
  • SQL query creating duplicates when using group by

    Assigned User chicuslavic
    CategoryBug report
    ResolutionUnable to Reproduce

    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


    User Feedback

    Recommended Comments

    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

    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.




    Link to comment
    Share on other sites

  • Create New...