private void DisplayStatisticsReport(StatisticsReport statisticsReport)
    {
        int count = 0;
        TableHeaderRow headerRow = new TableHeaderRow();
        headerRow.BackColor = Color.MistyRose;

        int postingsCount = 0;

        foreach (XmlNode postings in statisticsReport.RootElement.SelectNodes(@"POSTING-STATISTICS/POSTINGS"))
        {
            if (count == 0)
            {
                TableHeaderCell headerSiteCell = new TableHeaderCell();
                headerSiteCell.Text = "Site";
                headerSiteCell.Scope = TableHeaderScope.Column;
                headerRow.Cells.Add(headerSiteCell);

                TableHeaderCell headerURLNameCell = new TableHeaderCell();
                headerURLNameCell.Text = "Site Name";
                headerURLNameCell.Scope = TableHeaderScope.Column;
                headerRow.Cells.Add(headerURLNameCell);

                TableHeaderCell headerForumIDCell = new TableHeaderCell();
                headerForumIDCell.Text = "Forum ID";
                headerForumIDCell.Scope = TableHeaderScope.Column;
                headerRow.Cells.Add(headerForumIDCell);

                TableHeaderCell headerIsMessageBoardCell = new TableHeaderCell();
                headerIsMessageBoardCell.Text = "Is Messageboard";
                headerIsMessageBoardCell.Scope = TableHeaderScope.Column;
                headerRow.Cells.Add(headerIsMessageBoardCell);

                TableHeaderCell headerTitleCell = new TableHeaderCell();
                headerTitleCell.Text = "Title";
                headerTitleCell.Scope = TableHeaderScope.Column;
                headerRow.Cells.Add(headerTitleCell);

                TableHeaderCell headerTotalPostsCell = new TableHeaderCell();
                headerTotalPostsCell.Text = "Total Posts";
                headerTotalPostsCell.Scope = TableHeaderScope.Column;
                headerRow.Cells.Add(headerTotalPostsCell);

                TableHeaderCell headerTotalUsersCell = new TableHeaderCell();
                headerTotalUsersCell.Text = "Total Users";
                headerTotalUsersCell.Scope = TableHeaderScope.Column;
                headerRow.Cells.Add(headerTotalUsersCell);
            }

            TableRow row = new TableRow();
            string forumID = String.Empty;
            if (postings.SelectSingleNode(@"@FORUMID") != null)
            {
                forumID = postings.SelectSingleNode(@"@FORUMID").InnerText;
            }

            string title = String.Empty;
            if (postings.SelectSingleNode(@"@TITLE") != null)
            {
                title = postings.SelectSingleNode(@"@TITLE").InnerText;
            }

            postingsCount++;

            if (postingsCount % 2 == 0)
                row.BackColor = Color.LightGray;
            else
                row.BackColor = Color.Linen;

            string siteID = postings.SelectSingleNode(@"@SITEID").InnerText;
            string siteName = postings.SelectSingleNode(@"@URLNAME").InnerText;
            string isMessageboard = postings.SelectSingleNode(@"@ISMESSAGEBOARD").InnerText;
            string totalPosts = postings.SelectSingleNode(@"@TOTALPOSTS").InnerText;
            string totalUsers = postings.SelectSingleNode(@"@TOTALUSERS").InnerText;

            TableCell siteIDCell = new TableCell();
            siteIDCell.HorizontalAlign = HorizontalAlign.Center;
            siteIDCell.Text = siteID;
            row.Cells.Add(siteIDCell);

            TableCell siteCell = new TableCell();
            siteCell.HorizontalAlign = HorizontalAlign.Center;
            siteCell.Text = siteName;
            row.Cells.Add(siteCell);

            TableCell forumIDCell = new TableCell();
            forumIDCell.HorizontalAlign = HorizontalAlign.Center;
            forumIDCell.Text = forumID;
            HyperLink forumTitleLink = new HyperLink();
            forumTitleLink.NavigateUrl = GetBaseUrl() + siteName + @"/F" + forumID;
            forumIDCell.Controls.Add(forumTitleLink);
            row.Cells.Add(forumIDCell);

            TableCell isMessageboardCell = new TableCell();
            isMessageboardCell.HorizontalAlign = HorizontalAlign.Center;
            isMessageboardCell.Text = isMessageboard;
            row.Cells.Add(isMessageboardCell);

            TableCell titleCell = new TableCell();
            titleCell.HorizontalAlign = HorizontalAlign.Center;
            titleCell.Text = title;
            row.Cells.Add(titleCell);

            TableCell totalPostsCell = new TableCell();
            totalPostsCell.HorizontalAlign = HorizontalAlign.Center;
            totalPostsCell.Text = totalPosts;
            row.Cells.Add(totalPostsCell);

            TableCell totalUsersCell = new TableCell();
            totalUsersCell.HorizontalAlign = HorizontalAlign.Center;
            totalUsersCell.Text = totalUsers;
            row.Cells.Add(totalUsersCell);

            tblResults.Rows.Add(row);
            count++;
        }

        _total = 0;
        string postStatsTotal = statisticsReport.RootElement.SelectSingleNode(@"POSTING-STATISTICS/@TOTAL").InnerText;
        if (postStatsTotal != null)
        {
            Int32.TryParse(postStatsTotal, out _total);
        }

        if (count == 0)
        {
            TableRow nodatarow = new TableRow();
            TableCell nodataCell = new TableCell();
            nodataCell.ColumnSpan = 4;
            nodataCell.Text = @"No data for those details";
            nodatarow.Cells.Add(nodataCell);
            tblResults.Rows.Add(nodatarow);
            Count.Text = "";
        }
        else
        {
            Count.Text = String.Format(@"{0} entries out of {1} in total.", count.ToString(), _total.ToString());
        }

        tblResults.Rows.AddAt(0, headerRow);

        tblResults.CellSpacing = 5;
        tblResults.BorderWidth = 2;
        tblResults.BorderStyle = BorderStyle.Outset;

        ShowHideResultControls(true);
        UpdatePagingControls();
        StoreValues();
    }
    /// <summary>
    /// Generates the results
    /// </summary>
    /// <param name="purexml">Whether to just produce the XML</param>
    private void GetStatisticsReport(bool purexml)
    {
        tblResults.Rows.Clear();
        Count.Text = "";
        lblEntryError.Text = String.Empty;

        DateTime entryDateTime = entryDate.SelectedDate;

        int intervalvalue = 1;
        Int32.TryParse(interval.SelectedValue, out intervalvalue);

        StatisticsReport statisticsReport = new StatisticsReport(_basePage);
        statisticsReport.TryCreateStatisticsReportXML(_skip, _show, entryDateTime, intervalvalue);

        if (!purexml)
        {
            DisplayStatisticsReport(statisticsReport);
        }
        else
        {
            //Replace an existing node
            if (_basePage.WholePageBaseXmlNode.SelectSingleNode("/POSTING-STATISTICS") != null)
            {
                XmlNode statisticsReportNode = _basePage.WholePageBaseXmlNode.SelectSingleNode("/POSTING-STATISTICS");

                _basePage.WholePageBaseXmlNode.ReplaceChild(statisticsReportNode, _basePage.WholePageBaseXmlNode.OwnerDocument.ImportNode(statisticsReport.RootElement.FirstChild, true));
            }
            else
            {
                _basePage.WholePageBaseXmlNode.FirstChild.AppendChild(_basePage.WholePageBaseXmlNode.OwnerDocument.ImportNode(statisticsReport.RootElement.FirstChild, true));
            }
        }
    }