Posted by Thomas Bihn on 12/16/05 23:55

Thanks for the quick replies. I tried using the Excel pivot table, but
it simply shows the same number of columns as serial number styles and
displays a count of the number of each style for each board ID:

BoardID,Style1,Style2,Style3,Style4,Style5
21,1,1,1,3,1
43,1,1,1,3,1
76,1,1,1,3,1
78,1,1,1,3,1
etc...

Like the MSDN article on cross-tabs, it wants to perform some aggregate
function on the serial number values in the data area.

Thanks again.

*** Sent via Developersdex http://www.developersdex.com ***

• Next in forum: Re: How to pass table names to a Stored procedure
• Prev in forum: Re: How to pass table names to a Stored procedure
• Thread view: Re: dynamically trasnpose rows into columns

[Reply to this message]