pivot table

microsoft.public.dotnet.framework

20 Oct 2006 2:25 AM

Curtis

Should I post this elsewhere?

In MSAccess one can do a pivot table where multiple items are shown in the
cells (not just avg, sum, etc.). We're trying to get that display in
vb.net. We can connect to the database, etc. We can even fill a datagrid
with pivot table information, but only where the cells contain average,
sums, etc. How do we do an sql statement or whatever we need to do to
simulate what msaccess does when it does a pivot table and shows like times
for rows and locations for columns and then gives a list of whoever is
scheduled for those times/locations - not just averages or sums.

Table would have

Time
Location
Item

Data would be like:

Time1 Location1 Item1
Time1 Location1 Item2
Time2 Location1 Item1
Time2 Location2 Item2

Pivot Table would be

                Location1       Location2
Time1        Item1
                  Item2

Time2        Item1             Item2

The pivot table in MSAccess will do this. How can we get that in vb.net?
Can we use the datagrid somehow?

[attached file: HP Deskjet 5700 Series User's Guide.lnk]