On a Web page in a SharePoint site, click Site Actions, and then click Edit Page. The page is placed in edit mode.

In a Web Part zone, click Add a Web Part.

In the Add Web Parts dialog box, select the Content Query Web Part check box. Click Add to add the Web Part to the selected Web Part zone.

On the Content Query Web Part, click edit, and then click Modify Shared Web Part.

The Content Query Tool Part shows Web Part property categories.

Expand the Query category. In the Source section, click Show items from the following list.

Click Browse. In the Select List or Library dialog box, click the Project Status Reports document library, and then click OK.

Do the following:

1. In the List Type section, in the Show items from this list type box, click Document Library.

2. In the Content Type section, in the Show items of this content type group box, click Project Status Reports. In the Show items of this content type box, click Project Status Report.

In the Additional Filters section, set Show items when to Project Status is equal to Requires Attention Or Project Status is equal to Might Need Attention And <no filter> (Figure 8).

Expand the Presentation section. In the Group items by box, click Project Status, and then click Show groups in descending order.

Expand the Appearance section. For Title, type Projects to Watch as the title of the Web Part.

Click OK in the tool part to save the changes to the Web Part properties.

The Content Query Web Part displays the documents currently in the Project Status Reports document library that have a status of Requires Attention or Might Need Attention, and groups the items by their status.

In the Web Part, click edit, and then click Export.

In the File Download dialog box, click Save. In the Save As dialog box, type a name and location for the .webpart file. Click Save in the Save As dialog box to save the file.

Set the value of the CommonViewFields property. The Content Query Web Part does not return all fields for all items automatically. You can use the CommonViewFields property to request specific fields to render. Locate the CommonViewFields property in the .webpart file, and then edit it to look like the following.

<property name="CommonViewFields" type="string">
Project_x0020_Name, Text;Project_x0020_Owner, Text;Project_x0020_Status_x0020_Summary, Text
</property>

This markup requests the Project Name, Project Owner, and Project Status Summary columns, to make the data in the columns available for rendering. Each internal column name is specified, followed by its data type. The name/type pairs are separated by semicolons.

Save the modified .webpart file.

Start Office SharePoint Designer 2007.

On the File menu, click Open Site.

In the Open Site dialog box, type the URL of the Office SharePoint Server site, and then click Open.

On the View menu of the SharePoint site, click Folder List, expand Style Library, and then expand XSL Style Sheets.

Locate and double-click the ItemStyle.xsl file to open it. SharePoint Designer prompts that the file is under source control and asks if it should check out the file. Click Yes.

Scroll to the bottom of the ItemStyle.xsl file and insert the following markup after the last </xsl:template> tag and before the </xsl:stylesheet> tag.

<xsl:template name="CustomStyle" match="Row[@Style='CustomStyle']"
mode="itemstyle">
  <xsl:variable name="SafeImageUrl">
    <xsl:call-template name="OuterTemplate.GetSafeStaticUrl">
      <xsl:with-param name="UrlColumnName" select="'ImageUrl'"/>
    </xsl:call-template>
  </xsl:variable>
  <xsl:variable name="SafeLinkUrl">
    <xsl:call-template name="OuterTemplate.GetSafeLink">
      <xsl:with-param name="UrlColumnName" select="'LinkUrl'"/>
    </xsl:call-template>
  </xsl:variable>
  <xsl:variable name="DisplayTitle">
    <xsl:call-template name="OuterTemplate.GetTitle">
      <xsl:with-param name="Title" select="@Title"/>
      <xsl:with-param name="UrlColumnName" select="'LinkUrl'"/>
    </xsl:call-template>
  </xsl:variable>
  <xsl:variable name="LinkTarget">
    <xsl:if test="@OpenInNewWindow = 'True'" >_blank</xsl:if>
  </xsl:variable>
  <div id="linkitem" class="item">
    <xsl:if test="string-length($SafeImageUrl) != 0">
      <div class="image-area-left">
        <a href="{$SafeLinkUrl}" target="{$LinkTarget}">
          <img class="image-fixed-width"
            src="{$SafeImageUrl}" alt="{@ImageUrlAltText}" />
        </a>
      </div>
    </xsl:if>
    <div class="link-item">
      <div class="description">
        Project Name:
        <xsl:value-of select="@Project_x005F_x0020_Name" />
        <br></br>
        Project Owner:
        <xsl:value-of select="@Project_x005F_x0020_Owner" />
        <br></br>
        Project Status Summary:
        <xsl:value-of
          select="@Project_x005F_x0020_Status_x005F_x0020_Summary" />
      </div>           
      <xsl:call-template
        name="OuterTemplate.CallPresenceStatusIconTemplate"/>
        <a href="{$SafeLinkUrl}" target="{$LinkTarget}"
          title="{@LinkToolTip}">
          <xsl:value-of select="$DisplayTitle"/>
        </a>
    </div>
  </div>
</xsl:template>

This markup defines a style named CustomStyle that displays the Project Name, Project Owner, and Project Status Summary, and a link to the item's document. Notice that the Project Status Report column names here are encoded differently from how they were previously in the .webpart file for the Content Query Web Part CommonViewFields custom property. This difference relates to the way certain characters are encoded when they are passed as XML to the XSL to be rendered. One way to see exactly what field names should be sent to the XSL is to insert the following markup into the ItemStyle.xsl file. This markup renders the field names. After the correct field names are determined, you can remove this markup from the XSL file. To see the field names to use in the XSL file, add the following markup to the XSL shown previously, as the first item in the new custom style.

<xsl:template name="CustomStyle" match="Row[@Style='CustomStyle']"
mode="itemstyle">
  <xsl:for-each select="@*">
    P:<xsl:value-of select="name()" />
  </xsl:for-each>
…

Check in and publish the changed ItemStyle.xsl file in SharePoint Designer.

Click Site Actions, and then click Edit Page.

On the page editing toolbar, on the Page menu, point to Add Web Parts, and then click Import.

In the Add Web Parts pane, click Browse. In the Choose File dialog box, navigate to the folder that contains the .webpart file you modified earlier, click the file, and then click Open.

In the Add Web Parts pane, click Upload.

After the Web Part is uploaded, in the Add Web Parts pane, select the Web Part zone to add the Web Part to, and then click Import. The customized Content Query Web Part is added to the selected Web Part zone.

If the Web page is not already in edit mode, click Site Actions, and then click Edit Page.

On the Content Query Web Part, click edit, and then click Modify Shared Web Part.

In the Content Query Tool Part, expand the Presentation category. In the Styles section, in the Item style box, click CustomStyle.

In the Web Part pane, click OK to apply the change.

The Content Query Web Part uses the custom XSLT transformation to render the custom Project Status Report content type fields.