Re: cannot select "group by" on the column tab in the query builder when
Ernest,
The Group By check box is enabled only if you select an aggregate function.
Regards
Roger
a
anonymous
said
almost 12 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: cannot select "group by" on the column tab in the query builder when
Roger,
Tried that and still not able to select
Hans Bergsten
said
almost 12 years ago
[This reply is migrated from our old forums.]
Re: cannot select "group by" on the column tab in the query builder when
Hi Ernest,
Group By for the column with an aggregate function is not enabled, if that is what you mean, because a column cannot both have an aggregate function and be used for grouping.
If this does not solve the problem, please post a screenshot.
Best Regards,
Hans
a
anonymous
said
almost 12 years ago
[This reply is migrated from our old forums. The original author name has been removed] [Attachment has been removed.]
Re: cannot select "group by" on the column tab in the query builder when
Hans,
see attached screen shot.
notice that the Grouping tab is grayed out.
Roger Bjärevall
said
almost 12 years ago
[This reply is migrated from our old forums.]
Re: cannot select "group by" on the column tab in the query builder when
Frank,
In the Columns list you need to select an aggregate function for one of the columns. Once you do that the Group By column and its check boxes will be enabled. Click what column to group by and then the Grouping tab will be enabled.
I hope this helps.
Regards
Roger
anonymous