Is there a way to pass Native SQL through the Data access layer? as I got to create a report with a lot of summary information, and counts(0), group by, order by and some aggrigate functions.

Create dynamic lists and use the aggregate functionality as well as the expression functionality, group by functionality etc. build into the runtime/generated code See the documentatoin on these topics for details.

Otis wrote:

Create dynamic lists and use the aggregate functionality as well as the expression functionality, group by functionality etc. build into the runtime/generated code See the documentatoin on these topics for details.

CMC: Careful though, non-aggregate SQL functions (e.g., datediff(), etc) are not supported as of yet...Frans did mention that it might be possible to implement those yourself right now, but I haven't personally tried it.

Jeff...