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!

 

[Guest]

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.

 

[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).

 

[Guest]

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.