We have a request to provide user data for a portal. This should include profile information from the Users and UserProfile tables, etc.

This data is all easily visible in the DB, and we can display it in the reports module without problem. BUT! The data is spread out over numerous rows, so the data for each user can be on ten rows, rather than just one.

This makes it extremely hard to read.

What we need to do is to get the data to be displayed in a grid, with column headings for each data type and one row per user.

Any ideas how this can be done?

Thanks for any input!