Suppose we want to develop a statics section were we can find reports like most active article posters (username, post Count), Post by category (category id, post count), and so on.

Using TBH pattern and 3 tier architecture, what you think is the best solution to resolve such scenario?

Keep in mind that there will be allways different fields retrieved from DB, so we can't do a DAL or BLL class to map those fields in a generic class we cant use later on UI layer (object datasource)

Asking directly to DB, brokes totally 3 tier schema but i'm sure there must be a solution i can't figure out right now.

Thnx