OK, so let's sum up my recent flury of crosstab / pivoting posts the past week or so:
Here's a dynamic way to do crosstabs in SQL Server But here's an alternate way to do this at the presentation layer in .
Read more →
As promised, here's a sample ASP report from Northwind using my ASP Report Class (http://weblogs.sqlteam.com/jeffs/posts/526.aspx).
Hopefully, everyone will agree that the script is very easy to write and read and much shorter.
Read more →
If you use ASP, ADO and SQL Server, check out my new article at:
http://weblogs.sqlteam.com/jeffs/posts/526.aspx
It includes code for a VBScript class which makes writing HTML reports based on an ADO recordset with group headers, footers, and subtotals extremely easy.
Read more →