Sams Teach Yourself SharePoint 2007 in 24 Hours: Using Windows SharePoint Services 3.0

Hour 18 Using Access 2007 Tables to Produce Reports from WSS 3.0 Lists

What You’ll Learn in This Hour

Creating a simple report from a single WSS 3.0 list

Creating complex reports combining data from several WSS 3.0 lists

The Evolution of Making Reports of SharePoint Lists

WSS 3.0 lists are designed to be viewed onscreen. They usually don’t print well, so you must use a help program if you want quality reports from lists.

With WSS 2.0 and Office 2003, this was done by transferring the contents of a list to Excel 2003 and creating a report there. ...