Home     Our Approach     Services     Pricing     Contact Us     Who We Are     Resources     Blog     Site Map      
Forms     Business Process Automation     Reports     Collaboration     Office Live     OBA Service Center      
Reports 
Accurate and timely information drive decisions at your company.  Good information leads to good decisions and finding the right information quickly improves productivity.  Reports delivered in the 2007 Microsoft Office System offer an effective tool to get the information you need using familiar office products like Excel, Access, and SharePoint.  BPFAST LLC. can create reports for your company using Microsoft Office 2007.  Examples of popular solutions are provided below.

 

Access 2007


Microsoft Access 2007 provides a great platform for report creation and delivery using data stored in SharePoint. Three examples are provided on this page.  The first sample on the left shows a standard Microsoft Access 2007 report with hours grouped by project and task.  A report like this can be directly linked to a list in SharePoint.  The second sample report on the left demonstrates Access 2007 charting capabilities using SharePoint list data. 

 

Pivot tables provide a good tool analyzing a large amount of data by allowing you to organize it into smaller related pieces of information.  The third sample report on the right shows an Access 2007 pivot table.

 

An Access 2007 database linked to SharePoint list data provides a great platform for integrating that information with other Office products including Outlook 2007, Excel 2007, and Word 2007.  Report information can be sent to the Office 2007 products you use every day; reducing training costs and taking advantage of the unique capabilities that each Office 2007 application offers.

 

 

 

 

 

 
 
 
 
 
SharePoint List Views
SharePoint stores nearly everything in lists including documents, tasks, calendar events, and new custom lists that you may create. These lists may be sorted, grouped, or configured to show only certain columns and then saved as SharePoint Views that can be used later. A popular new feature that displays a Gantt chart is displayed on the left. The image on the right shows the common and easy to use grouping ability of SharePoint list views.

 
SharePoint Data Views
The SharePoint Data View is a configurable web part that is created with the assistance of Microsoft's SharePoint Designer tool.  The Data View web part provides report like features like conditional formatting that can be used to change the color, font, or hide information.  Simple dashboards that list key performance indicators or highlight problems can be quickly created using this web part.  The image to the left shows an example where tasks and related task status are listed, but tasks that are "Waiting on Someone Else" are highlighted in red to stand out so they can be addressed.  Clicking on the task name will allow the user to view the details behind this task.