adding a "group by" clause

[jdbppd]

In an existing report, I know I can make changes to the from, where, and order by clauses in the "show sql". But what I really need to do is add a group by clause. Is there a way to do this without having to make massive changes to my existing report (amounting to moving my detail section into a group section and summarizing there)? My report is based on a view and some other linked tables. I need to summarize away one field in the view, keeping my detail section in tact. Thanks in advance!

 

[nagornyi]

You don't have to group to sum up a field. Use running total.

 

[kenhamady]

It isn't clear what you mean by "summarize away one field in the view" but you can add a group within CR and do a summary or a running total to get group values.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com