Group by expressions
We added some date functionality to our old RB6 version. Now I want to
use inheritance to allow ease of upgrade for the future. So I must use
existing properties etc.
Now a couple of the functions added where Quarter and Week of the year.
These functions enabled the user to format data to allow ease of grouping
and then to display the info appropriately.
To make it compatible with RB10 :-
To get the data into the correct format we can use the calcs tab, by
setting the function to expression and placing the SQL code in the
expression column. Meets the first part of our requirements, second part
is much harder.
How can you group by an expression?
Is the going to be possible in the future?
The reason I ask is we edited the code base to allow just this scenario
due to customer requests. So I know it is possible in that regard.
Regards
Charles
--- posted by geoForum on http://delphi.newswhat.com
use inheritance to allow ease of upgrade for the future. So I must use
existing properties etc.
Now a couple of the functions added where Quarter and Week of the year.
These functions enabled the user to format data to allow ease of grouping
and then to display the info appropriately.
To make it compatible with RB10 :-
To get the data into the correct format we can use the calcs tab, by
setting the function to expression and placing the SQL code in the
expression column. Meets the first part of our requirements, second part
is much harder.
How can you group by an expression?
Is the going to be possible in the future?
The reason I ask is we edited the code base to allow just this scenario
due to customer requests. So I know it is possible in that regard.
Regards
Charles
--- posted by geoForum on http://delphi.newswhat.com
This discussion has been closed.
Comments
ReportBuilder currently does not allow grouping by an expression or
calculated field. This is due to the fact that some databases do not allow
it. It has come to our attention recently that most DB's these days do in
fact allow this type of statement. This enhancement has been noted and is
something we may add for a later release of ReportBuilder. Thanks for your
feedback. One option would be to create your own query designer and
manually edit the SQL code if the user wants to group by an expression.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com