Home Datapipelines
New Blog Posts: Merging Reports - Part 1 and Part 2

Bug on Group By on ReportBuilder 11.04

edited May 2009 in Datapipelines
ReportBuilder Enterprise 11.04
Delphi 2007 R2 Version 11.0.2902.10471

Hi,

I upgraded from ReportBuilder 10.09 to 11.04 and I saw that group by does
not work!
I can see the group by clause on the sql, but if I look at the preview the
result is not "grouped".
It seems unbelievable, but it's really true!
I have only tried with an end user solution.

I discovered the problem with old reports, but I get the same behaviour with
new ones too.

Steps to reproduce:
Create a new report.
Add a new query with one table, one field, grouped on the same field.
Look at Sql: it's fine
Look at the preview of data: it's not grouped.
Add a DbText in the detail band linked to the field
Make a preview: you get duplicated values, because it's not grouped.

I reproduced the same problem in more end user solutions and I can send you
the BDE example.

What can I do? I need to fix this problem ASAP.

Best Regards.
Massimiliano Trezzi.

Comments

  • edited May 2009
    I tried from a Delphi Project and it's the same.
    Hi,
    Massimiliano Trezzi

    "Massimiliano Trezzi" ha
  • edited May 2009

    There is now patch available for RB 11.04, that fixes this issue. Please
    send an email to support@digital-metaphors.com and request the SQL Group By
    patch.

    Typically a SQL Group By is used when the SQL includes one or more aggregate
    calculations such as Sum, Min, Max, etc.

    The patch fixes the Group By case in which no aggregate calculations are
    present. (When no calculations are present, it is more correct to use Select
    Distinct.)

    example:

    Select Distinct orders.custno
    from orders

    The above will provide a list of unique customer numbers.



    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited May 2009
    Thank you,
    I will require the patch.
    I agree with you that "distinct" clause it's the right choice to avoid
    duplicate records, but this use of "group by" it's correct and I have a lot
    of reports developed by different persons and it should be too expensive to
    check all of them.

    Best Regards,
    Massimiliano Trezzi




  • edited May 2009
    Ok, it works.
    Thank you.

    "Massimiliano Trezzi" ha
This discussion has been closed.