http://weblogs.sqlteam.com/jeffs/articles/5091.aspx provided an excellent
insight for pivioting DataSet.
As things stand, the example could happily pivot Something SQLServer returns
as:
frmInstanceID frmName Department Status
1 formA IT Complete
2 formB IT Complete
3 formC IT Incomplete
4 formA HR Missing
5 formB HR Inomplete
6 formC HR Complete
with the invocation of Pivot(dataReader,"frmInstanceID","frmName","Status"),
pivotted data into
frmInstanceID Department formA formB formC
1 IT Complete
2 IT Complete
3 IT
Incomplete
4 HR Missing
5 HR Incomplete
6 HR
Complete
What I really really want is:
Department formA formB formC
IT Complete Complete Incomplete
HR Missing InComplete Complete
With each of the form status being a hyperlink with the frmInstanceID as a
parameter:
e.g. <a href="showStatus.aspx?id=7">Complete</a>
I managed to "fool" the system into displaying the above with the invocation
of Pivot(dataReader,"Department","frmName","Status") (i.e. changing the
keyColumn parameter to the Pivot method).
Could someone assist with helping me set a hyperlink column and managing
sorting with this example at
http://weblogs.sqlteam.com/jeffs/articles/5091.aspx ?
Many Thanks