Calc expressions with aggregates
Hello,
I have noticed a problem with the use of calc expressions containing
aggregates in Reportbuilder 7.02.
If I use a calc expression like 'select max(value) from table' then the
query designer automatically adds group by fields, while it shouldn't.
I read a post in this newsgroup from 17/07/2003 where this problem was
exposed. Is there a patch available to solve this problem or is it
solved in any of the reportbuilder versions after 7.02?
Thanks a lot.
Luc Feys
I have noticed a problem with the use of calc expressions containing
aggregates in Reportbuilder 7.02.
If I use a calc expression like 'select max(value) from table' then the
query designer automatically adds group by fields, while it shouldn't.
I read a post in this newsgroup from 17/07/2003 where this problem was
exposed. Is there a patch available to solve this problem or is it
solved in any of the reportbuilder versions after 7.02?
Thanks a lot.
Luc Feys
This discussion has been closed.
Comments
An issue similar to this one was fixed for RB 7.03. Please try downloading
a trial copy of ReportBuilder 9.01 and test with that.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com