Datagrid/repeater like a report

[voidfill3d]

I do not know if this is possible with a datagrid or a repeater or some
other object, but I am looking to create a report via a table like
structure similar to that of a report you would create in MS Access.
For example:

Category1
----------------------------
ID Name Field1 Field2
1 Bob Data Data
3 Sally Data Data

Category2
----------------------------
ID Name Field1 Field2
2 Greg Data Data
4 Marge Data Data

Instead of the usual:

ID Name Field1 Field2 CategoryName
-------------------------------------------
1 Bob Data Data Category1
3 Sally Data Data Category1
2 Greg Data Data Category2
4 Marge Data Data Category2

I know how I could program it the long way, but I was wondering if
there was a way to do this with a datagrid or a repeater.

Can anyone help me out?

THANKS!

[Phillip Williams]

A DataGrid within a Repeater if you intend to move between pages on the
report would work fine: http://www.societopia.net/samples/repeater1.aspx.

If your report is static (no pagination) then you can simply use a repeater
within a repeater. You still need to program the OnItemDataBound event to
select the category.

---
Phillip Williams
http://www.societopia.net
http://www.webswapp.com

"vo********@yahoo.com" wrote:

I do not know if this is possible with a datagrid or a repeater or some
other object, but I am looking to create a report via a table like
structure similar to that of a report you would create in MS Access.
For example:

Category1
----------------------------
ID Name Field1 Field2
1 Bob Data Data
3 Sally Data Data

Category2
----------------------------
ID Name Field1 Field2
2 Greg Data Data
4 Marge Data Data

Instead of the usual:

ID Name Field1 Field2 CategoryName
-------------------------------------------
1 Bob Data Data Category1
3 Sally Data Data Category1
2 Greg Data Data Category2
4 Marge Data Data Category2

I know how I could program it the long way, but I was wondering if
there was a way to do this with a datagrid or a repeater.

Can anyone help me out?

THANKS!

[voidfill3d]

THANKS. I should have thought of that!

[voidfill3d]

Actually, how would I do that since the current CategoryID has to be
thrown into a Stored Procedure (in my case).

[Phillip Williams]

The source code is available from the sample I gave to you:
http://www.societopia.net/samples/repeater1.aspx

Basically on dataBinding the Repeater items I access the DataItem (which is
the dataRowView) and retrieve the CategoryID associated with that row. I use
that CategoryID to create a new view of the data for the child datagrid.
--
Phillip Williams
http://www.webswapp.com
"vo********@yahoo.com" wrote:

Actually, how would I do that since the current CategoryID has to be
thrown into a Stored Procedure (in my case).