On Feb 21, 2007, at 12:58 PM, Rich Shepard wrote:
> Should I not group by and order by in the select statement, but
> do this in the banded ReportDesigner instead?
In general, it's best to let the database handle this. That's what
they are designed to do, after all.
Also, with 31 columns, if you add 'group by' statements, you'll have
to group by all the non-derived fields. You might want to limit your
select to only include those fields you care about.
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
