Gathering data from different sources or parts of a web application in SharePoint can be tricky. Consider a scenario where one needs to gather data from the entire web application as well as from data sources outside the web application. In MOSS 2007, one of the ways to achieve this is by using a new feature named Data Views in Microsoft SharePoint Designer 2007. In this article we will discuss how one could connect to another application and use it as a data source.

This article demonstration how to collect data from a user during a workflow and use it change the outcome of the workflow.

Wouldn't you like to hide some fields from a user when filling out a new item form for a list?

Dynamically control workflow recipients from a separate SharePoint list based on a field in the workflow list, to receive an email.

Every SharePoint site template (both MOSS 2007 and WSS3) has its own default layout of Web Part Zones. I would like to customize the layout of these zones for flexibility of design in a particular site.

I've heard that Microsoft SharePoint Designer 2007 is a great administrator and designer tool for SharePoint. What are some of the compelling features, how do I get it and how much does it cost?