Export (0) Print
Expand All

Reporting on a Custom Commerce Event

Commerce Server 2002

A report for commerce events can be created through Commerce Server Business Desk by using a new cube or an SQL query. But before you can create reports for the new commerce event, you must have wishlist event data in your log files to import into the Data Warehouse. The process of adding the wish list user interface and updating ASP pages is left to the user. If you have not added the wish list functionality to your Web site, you can use the sample log files included in the procedures to see how the process will work when your site has wish list functionality in place for users.

Ee783633.note(en-US,CS.20).gif Important

  • We recommend that you do not develop a production-quality site based on the Retail2002 Site. We recommend that you use the Commerce Server 2002 Starter Site to develop a production quality site. You can download the Starter Site from http://go.microsoft.com/fwlink/?linkid=37800.

To generate sample log file data for the Retail Solution Site

To generate sample log file data for the Retail2002 - International Retail Site

To make the current log file available for reports

To create a Custom Commerce Event report based on an SQL query

To create a Custom Commerce Event report based on an OLAP cube

Ee783633.note(en-US,CS.20).gif Note

To generate sample log file data for the Retail Solution Site

  1. Click Start, point to Programs, point to Accessories, and then click Notepad.
  2. In Notepad, paste the following code:
    <%
     'An array of Commerce Events to log.
     g_rgEvents = Array( _
       "CEVT={T=WISH,EVT=ADDTOLIST,PRID=""Bike"",QTY=""1"",LN=""Wife""}", _
       "CEVT={T=WISH,EVT=ADDTOLIST,PRID=""HolidayCD"",QTY=""1""," + _ 
       "LN=""Holidays""}", _
       "CEVT={T=WISH,EVT=ADDTOLIST,PRID=""Printer"",QTY=""1""," + _ 
       "LN=""Wife""}", _
       "CEVT={T=WISH,EVT=DROPFROMLIST,PRID=""Printer"",QTY=""1""," + _ 
       "LN=""Wife""}", _
       "CEVT={T=WISH,EVT=ADDTOLIST,PRID=""JazzCD"",QTY=""1""," + _ 
       "LN=""Brother""}", _
       "CEVT={T=WISH,EVT=DROPFROMLIST,PRID=""StonewashedJeans""," + _
    "QTY=""1"",LN=""Kid""}" _
       )
    
     'Determine if the request involves adding a new event to the log file
     If (Not vbNullString = Request.QueryString("Event")) Then
        sEventID = CLng(Request.QueryString("Event"))
       
       'Make sure the requested event is available
       If (Not sEventID > UBound(g_rgEvents)) Then
          
          'Log the event
          Call Response.AppendToLog("&")
          Call Response.AppendToLog(g_rgEvents(sEventID))
          
          'Get the event data to display on the page
          sEventData = g_rgEvents(sEventID) 
        End If
     End If
    %>
    
    <html>
    <head>
    <title>Extending Commerce Events</title>
    </head>
    
    <body>
    
    <%
     'Dynamically render a collection of links for logging different
     'Commerce Events to the IIS log file. Note that this is required
     'because each call to Response.AppendToLog() will only log the data on
     'a single line associated with the current GET request.
     For itr = 0 to UBound(g_rgEvents)
       Call Response.Write("<a href=""SampleEventData.asp?Event=" _
    & CStr(itr) & """>Log Commerce Event " & CStr(itr) & "</a><br/>")
     Next
    %>
    
    Commerce Event logged: <b><%= sEventData %></b>
    
    </body>
    </html>
  3. On the File menu, click Save As.
  4. In the Save As dialog box, in the Save In box, navigate to the root drive of your Web site, for example C:/Inetpub/wwwroot/retail, type SampleEventData.asp, and then click Save.
  5. On the File menu, click Exit.
  6. Click Start, point to Programs, and then click Internet Explorer.
  7. Navigate to the SampleEventData.asp page, for example, http://localhost/retail/SampleEventData.asp.
  8. To add each event to the log file, click each Log Commerce Event link on the page. Add as many events to the log file as you want. Adding more events to the log file means there will be more events to report on later. You can add multiple instances of the same event.

    To view the log file in which the event information was stored, open the log file for the appropriate day from the log file directory, for example, C:\WINNT\system32\LogFiles\W3SVC1.

  9. To close Internet Explorer, on the File menu, click Close.

Ee783633.note(en-US,CS.20).gifNote

To generate sample log file data for the Retail2002 - International Retail Site

  1. Click Start, point to Programs, point to Microsoft Visual Studio .NET, and then click Microsoft Visual Studio .NET.
  2. In Visual Studio .NET, on the File menu, point to Open, and then click Projects.
  3. In the Open Project dialog box, navigate to <drive>:/Inetput/wwwroot/retail2002, select Retail2002.sln, and then click Open.

    The Retail2002 site opens in the Visual Studio .NET window.

  4. On the Project menu, click Add New Item.
  5. In the Add New Item – Retail2002 dialog box, in the Templates section, select Class, type Wishlist.vb in the Name window, and then click Open.
  6. On the Edit menu, click Select All, and then press the Delete key.
  7. Paste the following code into the Wishlist.vb page:
    Imports Microsoft.CommerceServer.Runtime
    
    <CommerceEvent("WISH")> _
    Public Class MyWishListEvent : Inherits BaseCommerceEvent
    
        ' Visual Basic .NET is case insensitive, 
        ' so you must make these names unique 
        ' from the public property names
        Private _myCustomValue As String
        Private _myPRID As String
        Private _myQTY As String
        Private _myLN As String
        Private _myEvent As String
    
        'Constructor
        Public Sub New(ByVal customValue As String)
    
            _myCustomValue = customValue
    
        End Sub
    
        'Body of BaseCommerceEvent.Validate() method
        Public Overrides Function Validate() As Boolean
            'noop validation
            Return True
        End Function
    
        'Define event properties
    
        <CommerceEventMember("EVT")> _
        Public Property MyEvent() As String
    
            Get
                Return _myEvent
            End Get
    
            Set(ByVal value As String)
                _myEvent = value
            End Set
    
        End Property
    
        <CommerceEventMember("PRID")> _
        Public Property MyPRID() As String
    
            Get
                Return _myPRID
            End Get
    
            Set(ByVal value As String)
                _myPRID = value
            End Set
    
        End Property
    
        <CommerceEventMember("QTY")> _
        Public Property MyQTY() As String
    
            Get
                Return _myQTY
            End Get
    
            Set(ByVal value As String)
                _myQTY = value
            End Set
    
        End Property
    
        <CommerceEventMember("LN")> _
        Public Property MyLN() As String
    
            Get
                Return _myLN
            End Get
    
            Set(ByVal value As String)
                _myLN = value
            End Set
    
        End Property
    
    End Class
    
  8. On the Project menu, click Add New Item.
  9. In the Add New Item-Retail2002 dialog box, do the following: In the Add New Item – Retail2002 dialog box, in the Templates section, select WebForm, type Wishlist.aspx in the Name window, and then click Open.
  10. On the View menu, click HTML Source.
  11. On the Edit menu, click Select All, and then press the Delete key.
  12. Paste the following code into the Wishlist.aspx HTML page:
    <%@ Page Language="vb" AutoEventWireup="false" Codebehind="Wishlist.aspx.vb" Inherits="Microsoft.CommerceServer.Site.Wishlist"%>
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
    <HTML>
        <HEAD>
            <title>Wishlist</title>
            <meta name="GENERATOR" content="Microsoft Visual Studio.NET 7.0">
            <meta name="CODE_LANGUAGE" content="Visual Basic 7.0">
            <meta name="vs_defaultClientScript" content="JavaScript">
            <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie3-2nav3-0">
        </HEAD>
        <body MS_POSITIONING="GridLayout">
            <TABLE height="297" cellSpacing="0" cellPadding="0" width="266" border="0" ms_2d_layout="TRUE">
                <TR vAlign="top">
                    <TD width="266" height="297">
                        <FORM id="Form1" method="post" runat="server">
                            <TABLE height="249" cellSpacing="0" cellPadding="0" width="285" border="0" ms_2d_layout="TRUE">
                                <TR vAlign="top">
                                    <TD width="56" height="32"></TD>
                                    <TD width="160"></TD>
                                    <TD width="69"></TD>
                                </TR>
                                <TR vAlign="top">
                                    <TD height="32"></TD>
                                    <TD colSpan="2">
                                        <asp:Button id="Button1" runat="server" Text="Log Commerce Event 0"></asp:Button></TD>
                                </TR>
                                <TR vAlign="top">
                                    <TD height="32"></TD>
                                    <TD colSpan="2">
                                        <asp:Button id="Button2" runat="server" Text="Log Commerce Event 1"></asp:Button></TD>
                                </TR>
                                <TR vAlign="top">
                                    <TD height="32"></TD>
                                    <TD colSpan="2">
                                        <asp:Button id="Button3" runat="server" Text="Log Commerce Event 2"></asp:Button></TD>
                                </TR>
                                <TR vAlign="top">
                                    <TD height="32"></TD>
                                    <TD colSpan="2">
                                        <asp:Button id="Button4" runat="server" Text="Log Commerce Event 3"></asp:Button></TD>
                                </TR>
                                <TR vAlign="top">
                                    <TD height="32"></TD>
                                    <TD colSpan="2">
                                        <asp:Button id="Button5" runat="server" Text="Log Commerce Event 4"></asp:Button></TD>
                                </TR>
                                <TR vAlign="top">
                                    <TD height="40"></TD>
                                    <TD colSpan="2">
                                        <asp:Button id="Button6" runat="server" Text="Log Commerce Event 5"></asp:Button></TD>
                                </TR>
                                <TR vAlign="top">
                                    <TD height="17"></TD>
                                    <TD>
                                        <asp:Label id="Label1" runat="server" Font-Size="Smaller" Font-Names="Arial">Commerce Event logged:</asp:Label></TD>
                                </TR>
                                <TR vAlign="top">
                                    <TD height="17"></TD>
                                    <TD>
                                        <asp:Label id="EventData" runat="server" Font-Names="Arial" Font-Size="Smaller"></asp:Label></TD>
                                </TR>
                                &nbsp;
                            </TABLE>
                        </FORM>
                    </TD>
                </TR>
            </TABLE>
        </body>
    </HTML>
  13. In Solution Explorer, click Show All Files button .
  14. In Solution Explorer, expand Wishlist.aspx, and then double-click the code-behind page, Wishlist.aspx.vb.
  15. On the Edit menu, click Select All, and then press the Delete key.
  16. Paste the following code into the Wishlist.aspx.vb page:
    Imports Microsoft.CommerceServer.Runtime
    
    Public Class Wishlist
        Inherits System.Web.UI.Page
        Protected WithEvents Label1 As System.Web.UI.WebControls.Label
        Protected WithEvents Button1 As System.Web.UI.WebControls.Button
        Protected WithEvents Button3 As System.Web.UI.WebControls.Button
        Protected WithEvents Button4 As System.Web.UI.WebControls.Button
        Protected WithEvents Button5 As System.Web.UI.WebControls.Button
        Protected WithEvents Button6 As System.Web.UI.WebControls.Button
        Protected WithEvents EventData As System.Web.UI.WebControls.Label
        Protected WithEvents Button2 As System.Web.UI.WebControls.Button
    
    #Region " Web Form Designer Generated Code "
    
        'This call is required by the Web Form Designer.
        <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
    
        End Sub
    
        Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
            'CODEGEN: This method call is required by the Web Form Designer
            'Do not modify it using the code editor.
            InitializeComponent()
        End Sub
    
    #End Region
    
        Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
            'Put user code to initialize the page here
        End Sub
    
        Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
            'Create an instance of the new Commerce Event class
            Dim cevt As MyWishListEvent
            cevt = New MyWishListEvent("My Wishlist Event")
    
            'Set event data
            cevt.MyEvent = "ADDTOLIST"
            cevt.MyPRID = "Bike"
            cevt.MyQTY = "1"
            cevt.MyLN = "Wife"
    
            'Log event data
            CommerceContext.LogCommerceEvent(cevt)
    
            'Output event data to the page
            EventData.Text = cevt.ToString()
    
        End Sub
    
        Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
            Dim cevt As MyWishListEvent
    
            cevt = New MyWishListEvent("My Wishlist Event")
            cevt.MyEvent = "ADDTOLIST"
            cevt.MyPRID = "HolidayCD"
            cevt.MyQTY = "1"
            cevt.MyLN = "Holidays"
    
            CommerceContext.LogCommerceEvent(cevt)
            EventData.Text = cevt.ToString()
        End Sub
    
        Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
            Dim cevt As MyWishListEvent
    
            cevt = New MyWishListEvent("My Wishlist Event")
            cevt.MyEvent = "ADDTOLIST"
            cevt.MyPRID = "Printer"
            cevt.MyQTY = "1"
            cevt.MyLN = "Wife"
    
            CommerceContext.LogCommerceEvent(cevt)
            EventData.Text = cevt.ToString()
        End Sub
    
        Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
            Dim cevt As MyWishListEvent
    
            cevt = New MyWishListEvent("My Wishlist Event")
            cevt.MyEvent = "DROPFROMLIST"
            cevt.MyPRID = "Printer"
            cevt.MyQTY = "1"
            cevt.MyLN = "Wife"
    
            CommerceContext.LogCommerceEvent(cevt)
            EventData.Text = cevt.ToString()
        End Sub
    
    
    
        Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click
            Dim cevt As MyWishListEvent
    
            cevt = New MyWishListEvent("My Wishlist Event")
            cevt.MyEvent = "ADDTOLIST"
            cevt.MyPRID = "JazzCD"
            cevt.MyQTY = "1"
            cevt.MyLN = "Brother"
    
            CommerceContext.LogCommerceEvent(cevt)
            EventData.Text = cevt.ToString()
        End Sub
    
        Private Sub Button6_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button6.Click
            Dim cevt As MyWishListEvent
    
            cevt = New MyWishListEvent("My Wishlist Event")
            cevt.MyEvent = "DROPFROMLIST"
            cevt.MyPRID = "Stonewashed Jeans"
            cevt.MyQTY = "1"
            cevt.MyLN = "Kid"
    
            CommerceContext.LogCommerceEvent(cevt)
            EventData.Text = cevt.ToString()
        End Sub
    End Class
  17. In Solution Explorer, double click Web.config.
  18. Update the Commerce Event section with your new class information. Replace the contents of the Commerce Event section with the following code. Notice that the following code contains the fully-qualified assembly name for the first three entries, the original code did not:
    <commerceEvent>
    <add className="Microsoft.CommerceServer.Runtime.AddItemToBasketEvent, Microsoft.CommerceServer.Runtime, Version=4.5.2002.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" loggingEnabled="true"/>
    <add className="Microsoft.CommerceServer.Runtime.RemoveItemFromBasketEvent, Microsoft.CommerceServer.Runtime, Version=4.5.2002.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" loggingEnabled="true"/>
    <add className="Microsoft.CommerceServer.Runtime.SubmitOrderEvent, Microsoft.CommerceServer.Runtime, Version=4.5.2002.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" loggingEnabled="true"/>
    <add className="Microsoft.CommerceServer.Site.MyWishListEvent, Microsoft.CommerceServer.Retail2002" loggingEnabled="true" />
    </commerceEvent>
  19. On the Build menu, click Build Solution.

    The build process may take a few minutes. The build process is complete when the following message appears on the Output tab:

    ---------------------- Done ----------------------
    
        Build: 10 succeeded, 0 failed, 0 skipped
  20. To close Visual Studio .NET, on the File menu, click Exit.
  21. After the project is built, click Start, point to Programs, and then click Internet Explorer.
  22. Navigate to the SampleEventData.asp page, for example, http://localhost/retail2002/Wishlist.aspx.
  23. To add each event to the log file, click each Log Commerce Event button on the page. Add as many events to the log file as you want. Adding more events to the log file means there will be more events to report on later. You can add multiple instances of the same event.

    To view the log file in which the event information was stored, open the log file for the appropriate day from the log file directory, for example, C:\WINNT\system32\LogFiles\W3SVC1.

  24. To close Internet Explorer, on the File menu, click Close.

To make the current log file available for reports

Ee783633.note(en-US,CS.20).gif Notes

  • Before creating a new report, you must run the Configuration synchronization Data Transformation Services (DTS) task, the Web server log import DTS task, and the Report preparation DTS task. For more information about running these DTS tasks, see Running the Configuration Synchronization DTS Task, Running the Web Server Log Import DTS Task, and Running the Report Preparation DTS Task, respectively.
  • All World Wide Web Consortium (W3C) log files are logged in Greenwich Mean Time (GMT), and the correction for your time zone occurs when the Web server log import DTS task is run. When running the Web server log import DTS task to import the sample event data, you will need to use the Logs by date/time range option to select the log file for the following day if the time zone for your server is not within the same day as the current time in GMT. For example, if the current time for your server is 8:00 pm on 3/1/2002, and the time in GMT is 2:00 am on 3/2/2002, the sample event data appears in the 3/2/2002 log file.
  • Before you can create a Custom Commerce Event report based on an SQL Query, you must ensure that your sample data was successfully imported into the Wishlist01 table of the Data Warehouse.

To create a Custom Commerce Event report based on an SQL Query

  1. Open the Business Desk for the site.
  2. In Business Desk, click Analysis, and then click Reports.
  3. Click New on the report toolbar to create your new report.
  4. In the Create a new report - Web Page Dialog screen, do the following:
    Use thisTo do this
    Report TypeSelect SQL.
    SQL QueryType Select * from wishlist01.

    Ee783633.note(en-US,CS.20).gif Note

    • If the PivotTable Field List does not appear automatically when you open the table, click Field List on the PivotTable toolbar to view the PivotTable Field List.
  5. Drag ProductNameCat from the PivotTable Field List and drop it into the Drop Row Fields Here box on the PivotTable.
  6. Drag Event from the PivotTable Field List and drop it into the Drop Column Fields Here box on the PivotTable.
  7. Select the Event column, click AutoCalc on the PivotTable toolbar, and then select Count from the drop-down list.

    The total number of events for each product appears in the Grand Total column in the PivotTable.

  8. On the PivotTable, click Show/Hide Details.

    The total number of times each product was added and deleted from the list appears in the addtolist and dropfromlist columns.

  9. Click Show Chart on the toolbar to view the chart.

    The chart for the data appears below the pivot table.

  10. In the New Report screen, click Save Report on the toolbar.
  11. In the Save a report—Web Page Dialog screen, do the following:
    Use thisTo do this
    Report NameType the name of the new report.
    Report CategoryType the report category.
    Report DescriptionType a description for the new report.
    Report Long DescriptionOptional. Type a longer description for the report. This description will be visible in the browser window above the PivotTable controls when you click Show description above the PivotTable controls.
  12. Click OK.

    Ee783633.important(en-US,CS.20).gif Important

    When you save a new report, you are saving the report definition, not the data. The next time you run the report, it will have the same rows, columns, and filters, and current data will be queried from Microsoft SQL Server 2000 as specified in the report definition.

  13. On the File menu, click Close.

Ee783633.note(en-US,CS.20).gif Note

  • For more information about working with PivotTables, click Pivot Help on the PivotTable toolbar.

To create a Custom Commerce Event report based on an OLAP cube

  1. Click Start, point to Programs, point to Administrative Tools, and then click Commerce Server Manager.
  2. In Commerce Server Manager, expand the Analysis Servers node, expand the node for the local server, right-click the Data Warehouse you extended for wish list events, point to New Cube, and then click Wizard.
  3. In the Cube Wizard screen, click Next.
  4. In the Select a fact table from a data source screen, in the Data sources and tables section, select Wishlist01, and then click Next.
  5. In the Select the numeric columns that define your measures screen, in the Fact table numeric columns section, select Quantity, click the right arrow button, select Request Index, click the right arrow button, select Uri Key, click the right arrow button, select User Key, click the right arrow button, and then click Next.
  6. In the Select the dimensions for your cube screen, click New Dimension.
  7. In the Dimension Wizard screen, click Next.
  8. In the Choose how you want to create the dimension dialog box, select Star Schema: A single dimension table, and then click Next.
  9. In the Select the dimension table screen, select Wishlist01, and then click Next.
  10. In the Select the dimension type screen, select Standard dimension, and then click Next.
  11. In the Select the levels for your dimension screen, select ProductNameCat, click the right arrow button, and then click Next.
  12. In the Specify the member key columns screen, click Next.
  13. In the Select advanced options screen, click Next.
  14. In the Finish the Dimension Wizard screen, in the Dimension name box, type ProductNameCat, and then click Finish.
  15. In the Cube Wizard, in the Select the dimensions from your cube screen, click New Dimension again to create a second dimension.
  16. Repeat steps 8 through 10.
  17. In the Select the levels for your dimension screen, select Event, click the right arrow button, and then click Next.
  18. Repeat steps 12 and 13.
  19. In the Finish the Dimension Wizard screen, in the Dimension name box, type Event, and then click Finish.
  20. In the Select the dimensions for your cube screen, click Next.
  21. In the Finish the Cube Wizard screen, in the Cube Name box, type Wishlist Activity, and then click Finish.

    The Cube Editor screen appears, displaying the schema of the Wishlist Activity cube.

  22. In the Cube Editor screen, on the File menu, click Exit.
  23. In the Tree tab of Commerce Server Manager, expand Cubes, right-click Wishlist Activity, and then click Process.
  24. In the Process a Cube dialog box, accept the defaults and click OK.
  25. In the Process dialog box, click Close.
  26. In Commerce Server Manager, expand Microsoft SQL Servers, expand SQL Server Group, expand the node for the local server, expand Databases, expand the node for the Data Warehouse that is being extended, and then click Tables.
  27. In the details pane on the right side of the screen, right-click CubeProcInfo, point to Open Table, and then click Return all rows.

    The contents of the CubeProcInfo table are displayed.

  28. In the bottom row of the CubeProcInfo table, type the following information in the Entry column of the following table for each associated column:
    Column nameEntry
    CubeNameWishlist Activity
    IncEnabled1
    IsVirtual1
    Optimization<NULL>
    ProcessingEnabled1
    AutoPartition1
    FactTabledbo.Wishlist01
    ProcessingKeySourcedbo.ProductNameCat
    ProcessingKeyProductNameCat
    PartitionKeySourcedbo.Wishlist01
    PartitioningKeyProductNameCat
    PartitionSize<NULL>
    ProcessingPass0
  29. To exit the CubeProcInfo table, click the close button in the upper-right corner.
  30. Before creating the report, you must run the Configuration synchronization DTS task, the Web server log import DTS task, and the Report preparation DTS task. For more information about running these tasks, see Running the Configuration Synchronization DTS Task, Running the Web Server Log Import DTS Task, and Running the Report Preparation DTS Task, respectively.
  31. Open the Business Desk for the site.
  32. In Business Desk, click Analysis, and then click Reports.
  33. Click Add on the report toolbar to create your new report.
  34. In the Create a new report - Web Page Dialog screen, do the following:
    Use thisTo do this
    Report TypeSelect OLAP.
    Cube NameSelect Wishlist Activity from the drop-down list.
    MDX QueryLeave blank.

    Ee783633.note(en-US,CS.20).gif Note

    • If the PivotTable Field List does not appear automatically when you open the table, click PivotTable Field List on the PivotTable toolbar to view the PivotTable Field List.
  35. Drag ProductNameCat from the PivotTable Field List and drop it into the Drop Row Fields Here box on the PivotTable.
  36. Drag Event from the PivotTable Field List and drop it into the Drop Column Fields Here box on the PivotTable.
  37. Drag Quantity from the PivotTable Field List and drop it into the Drop Totals or Detail Fields Here box on the PivotTable.

    The total number of events for each product appears in the Grand Total column in the PivotTable.

  38. Click Show Chart on the toolbar to view the chart.

    The chart for the data appears below the pivot table.

  39. On the New Report page, click Save Report on the toolbar.
  40. In the Save a report—Web Page Dialog screen, do the following:
    Use thisTo do this
    Report NameType the name of the new report.
    Report CategoryType the report category.
    Report DescriptionType a description for the new report.
    Report Long DescriptionOptional. Type a longer description for the report. This description will be visible in the browser above the PivotTable controls when you click Show description above the PivotTable controls.
  41. Click OK.

    Ee783633.important(en-US,CS.20).gif Important

    • When you save a new report, you are saving the report definition, not the data. The next time you run the report, it will have the same rows, columns, and filters, and current data will be queried from Microsoft SQL Server 2000 Analysis Services (OLAP) as specified in the report definition.
  42. On the File menu, click Close.

Ee783633.note(en-US,CS.20).gif Note

  • For more information about working with PivotTables, click Pivot Help on the PivotTable toolbar.

See Also

Creating a New Dynamic Report Definition

Copyright © 2005 Microsoft Corporation.
All rights reserved.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft